| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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 14:20:59 |
| Message-ID: | 491994CB.5070202@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Sergey Konoplev wrote:
>
> Another thing is that even I set statement_timeout to 20s the query
> with NOT IN finishes working after 30+ seconds without "canceled by
> statement timeout" error.
Maybe it's not taking that long to execute the query then.
Maybe something to do with process startup is delaying things - could
you tweak the test script to send the outputs of the explain somewhere
other than /dev/null? That way we'd know if there was a big difference
between query-execution-time and process-execution-time.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | NetGraviton | 2008-11-11 14:45:52 | Web Application Engineer - Drupal, PHP, CSS, JavaScript, Postgresql |
| Previous Message | Richard Huxton | 2008-11-11 14:16:53 | Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-11-11 14:22:51 | Re: Message-ID should surely not be shown as a mailto: URL |
| Previous Message | Richard Huxton | 2008-11-11 14:16:53 | Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case) |