Re: curious delay on view/where

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: curious delay on view/where
Date: 2004-10-28 14:25:07
Message-ID: 1758.1098973507@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message andre.toscano 2004-10-28 14:53:25 Re: extra info - curious delay on view/where
Previous Message Tom Lane 2004-10-28 14:22:47 Re: Select Instead on a table