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?

[SQL] curious delay on view/where

2004-10-28 Thread Gary Stainburn
Hi folks. I have the following view: CREATE VIEW "stock_available" as SELECT * FROM stock_details WHERE available = true AND visible = true AND location not in (SELECT descr FROM ignored); Stock_details is itself a view pulling in a number of tables. Everything works fine until I try to