| 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 04:38:11 |
| Message-ID: | 12736.1176439091@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 Thu, 12 Apr 2007, Tom Lane wrote:
>> I'm still not having any luck reproducing the failure here. Grasping at
>> straws again, I wonder if it's got something to do with the order in
>> which the planner examines the indexes --- which is OID order. Could
>> you send me the results of
> Here you go:
Nope, still doesn't fail for me. [ baffled and annoyed... ] There must
be something about your situation that's relevant but we aren't
recognizing it. Are you in a position to let me ssh into your machine
and try to debug it? Or other options like sending me a dump of your
database? I'm about out of steam for tonight, but let's talk about it
off-list tomorrow.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2007-04-13 04:50:23 | Re: Benchmarking tools for the Postgres, EDB and Oracle Database |
| Previous Message | Steve | 2007-04-13 03:55:00 | Re: Strangely Variable Query Performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | NikhilS | 2007-04-13 05:51:56 | Re: CREATE TABLE LIKE INCLUDING INDEXES support |
| Previous Message | Steve | 2007-04-13 03:55:00 | Re: Strangely Variable Query Performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew McMillan | 2007-04-13 08:35:55 | Re: Question about memory allocations |
| Previous Message | Steve | 2007-04-13 03:57:24 | Re: Question about memory allocations |