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
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?
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 underlying