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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group