set in transaction - Mailing list pgsql-general

From Joseph Shraibman
Subject set in transaction
Date
Msg-id asjk63$1u5q$1@news.hub.org
Whole thread Raw
Responses Re: set in transaction
List pgsql-general
I have a query that performs much better using
set enable_seqscan = false; The problem is that variables sets don't get rolled back when
a transaction aborts, so I'm forced to destroy my db connection rather than putting it
back in the pool. Is there any way around this in general other than just setting
enable_seqscan = true; and the end?


pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: performance tuning
Next
From: "Chris White"
Date:
Subject: Efficient Boolean Storage