| 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-13 00:20:06 |
| Message-ID: | 10503.1176423606@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:
> Either way, it runs perfectly fast. So it looks like the indexes are
> confusing this query like you suspected. Any advise?
Wow --- sometimes grasping at straws pays off. I was testing here with
just a subset of the indexes to save build time, but I bet that one of
the "irrelevant" ones is affecting this somehow. Time to re-test.
If you have some time to kill, it might be interesting to vary that
begin/rollback test script to leave one or two other indexes in place,
and see if you can identify exactly which other index(es) get it
confused.
I'm about to go out to dinner with the wife, but will have a closer
look when I get back, or tomorrow morning. We'll figure this out.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florian G. Pflug | 2007-04-13 00:30:30 | Re: What tools do people use to hack on PostgreSQL? |
| Previous Message | Koichi Suzuki | 2007-04-13 00:09:50 | Re: [HACKERS] Full page writes improvement, code update |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve | 2007-04-13 00:34:18 | Re: Strangely Variable Query Performance |
| Previous Message | Koichi Suzuki | 2007-04-13 00:09:50 | Re: [HACKERS] Full page writes improvement, code update |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve | 2007-04-13 00:34:18 | Re: Strangely Variable Query Performance |
| Previous Message | Steve | 2007-04-13 00:05:48 | Re: Strangely Variable Query Performance |