Postgres Pro
Downloads
Home   >   mailing lists

Re: curious delay on view/where - Mailing list pgsql-sql

From Tom Lane
Subject Re: curious delay on view/where
Date
Msg-id 1758.1098973507@sss.pgh.pa.us
Whole thread Raw
In response to curious delay on view/where  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Responses Re: curious delay on view/where
List pgsql-sql
Tree view 
Gary Stainburn <gary.stainburn@ringways.co.uk> 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?
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Select Instead on a table
Next
From: "andre.toscano"
Date:
Subject: Re: extra info - curious delay on view/where