Re: [SQL] curious delay on view/where

2004-10-28 Thread Gary Stainburn
On Thursday 28 October 2004 3:25 pm, Tom Lane wrote: > Gary Stainburn <[EMAIL PROTECTED]> writes: > > Anyone got any ideas of the cause, or thoughts on how I can trace > > the problem? > > EXPLAIN ANALYZE results for the fast and slow cases would be > interesting. Also, have you ANALYZEd the under

Re: [SQL] curious delay on view/where

2004-10-28 Thread Tom Lane
Gary Stainburn <[EMAIL PROTECTED]> writes: > Anyone got any ideas of the cause, or thoughts on how I can trace the > problem? EXPLAIN ANALYZE results for the fast and slow cases would be interesting. Also, have you ANALYZEd the underlying tables lately? And what PG version is this?