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

Re: curious delay on view/where

From: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: curious delay on view/where
Date: 2004-10-28 15:01:59
Message-ID: (view raw or whole thread)
Lists: pgsql-sql
On Thursday 28 October 2004 3:25 pm, Tom Lane wrote:
> 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

Hi Tom.

I've the analyze but don't understand what it's telling me.  I've made 
it available at

Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     

In response to

pgsql-sql by date

Next:From: Murphy PopeDate: 2004-10-28 16:52:31
Subject: Re: ORDER BY and NULLs
Previous:From: andre.toscanoDate: 2004-10-28 14:53:25
Subject: Re: extra info - curious delay on view/where

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