Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case) - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)
Date
Msg-id c3a7de1f0811120643g187b6c0p8043be4bdf67d295@mail.gmail.com
Whole thread Raw
In response to Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)
List pgsql-general
> What configure options did you use, what locale/encoding are you using,
> what nondefault settings have you got in postgresql.conf?
>
>                        regards, tom lane

You are right. I've found the odd thing (that completely drives me
mad) in postgresql.conf.

You are able to reproduce slow-not-in queries by switching
constraint_exclusion to on in your postgresql.conf and running my test
(which is attached to the first message).

Looking forward to hearing from you.

--
Regards,
Sergey Konoplev
--
PostgreSQL articles in english & russian
http://gray-hemp.blogspot.com/search/label/postgresql/

pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: sort_mem param of postgresql.conf
Next
From: "Scott Marlowe"
Date:
Subject: Re: sort_mem param of postgresql.conf