Postgres Pro
Downloads
Home   >   mailing lists

Re: pl/tcl function to detect when a request has been canceled - Mailing list pgsql-hackers

From Peter Da Silva
Subject Re: pl/tcl function to detect when a request has been canceled
Date
Msg-id C82A8B79-027A-4A6D-89FE-5859C240A409@flightaware.com
Whole thread Raw
In response to Re: pl/tcl function to detect when a request has been canceled  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
On 6/8/18, 1:12 PM, "Andres Freund" <andres@anarazel.de> wrote:
    I'm not terribly opposed to this, but I wonder if the much more
    pragmatic solution is to just occasionally call a database function that
    checks this?  You could just run SELECT 1 occasionally :/
    
That seems to work, and I suppose in most cases the overhead could be mitigated by only calling it every N times
througha loop, but it's not as clean.

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Performance regression with PostgreSQL 11 and partitioning
Next
From: Tom Lane
Date:
Subject: Re: Performance regression with PostgreSQL 11 and partitioning