Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group