| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Sergey Konoplev" <gray(dot)ru(at)gmail(dot)com> |
| Cc: | "Richard Huxton" <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case) |
| Date: | 2008-11-11 20:17:39 |
| Message-ID: | 11722.1226434659@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
"Sergey Konoplev" <gray(dot)ru(at)gmail(dot)com> writes:
>> Finally - did you compile this from source yourself, or is it installed
>> via apt? I'm wondering whether you have an unusual version of a library
>> linked in, and it's taking a long time to parse the query.
> I've compiled it from sources. BTW, I tested it on both 8.3.3 and 8.3.4.
What configure options did you use, what locale/encoding are you using,
what nondefault settings have you got in postgresql.conf?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-11-11 20:20:56 | Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case) |
| Previous Message | Tom Lane | 2008-11-11 20:16:13 | Re: Timestamp precission question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-11-11 20:20:56 | Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case) |
| Previous Message | Magnus Hagander | 2008-11-11 20:08:39 | Re: Quick patch for correct pg_stat_database columns |