| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steve <cheetah(at)tanabi(dot)org> |
| Cc: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Strangely Variable Query Performance |
| Date: | 2007-04-12 23:29:09 |
| Message-ID: | 10067.1176420549@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:
> Here's my planner parameters:
I copied all these, and my 8.2.x still likes the bitmap scan a lot
better than the seqscan. Furthermore, I double-checked the CVS history
and there definitely haven't been any changes in that area in REL8_2
branch since 8.2.3. So I'm a bit baffled. Maybe the misbehavior is
platform-specific ... what are you on exactly? Is there anything
nonstandard about your Postgres installation?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-12 23:32:43 | Re: Strangely Variable Query Performance |
| Previous Message | Steve | 2007-04-12 23:28:02 | Re: Strangely Variable Query Performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-12 23:32:43 | Re: Strangely Variable Query Performance |
| Previous Message | Steve | 2007-04-12 23:28:02 | Re: Strangely Variable Query Performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-12 23:32:43 | Re: Strangely Variable Query Performance |
| Previous Message | Steve | 2007-04-12 23:28:02 | Re: Strangely Variable Query Performance |