| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steve <cheetah(at)tanabi(dot)org> |
| Cc: | PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Strangely Variable Query Performance |
| Date: | 2007-04-12 21:24:52 |
| Message-ID: | 5772.1176413092@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches pgsql-performance |
Steve <cheetah(at)tanabi(dot)org> writes:
> On a Postgres 8.2.3 server, I've got a query that is running very slow in
> some cases.
Could we see the exact definition of that table and its indexes?
It looks like the planner is missing the bitmap scan for some reason,
but I've not seen a case like that before.
Also, I assume the restriction on receipt date is very nonselective?
It doesn't seem to have changed the estimated rowcount much.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve | 2007-04-12 21:40:28 | Re: Strangely Variable Query Performance |
| Previous Message | Tom Lane | 2007-04-12 21:18:44 | Re: TOASTing smaller things |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve | 2007-04-12 21:40:28 | Re: Strangely Variable Query Performance |
| Previous Message | Steve | 2007-04-12 21:03:17 | Strangely Variable Query Performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve | 2007-04-12 21:40:28 | Re: Strangely Variable Query Performance |
| Previous Message | Steve | 2007-04-12 21:03:17 | Strangely Variable Query Performance |