Horton

Re: [BUGS] Optimization disaster

Josh Berkus <josh@agliodbs.com>

View thread
From: Josh Berkus <josh@agliodbs.com>
To: Andrew McMillan <andrew@catalyst.net.nz>, Dietrich <hoglabogla@hotmail.com>
Cc: pgsql-novice@postgresql.org
Date: 2002-10-24T00:07:50Z
Lists: pgsql-bugs 
Deitrich,

> > The following Query needs about 0,2 seconds with SEQ_SCAN set to OFF
> > and 150 seconds with SEQ_SCAN set to ON:

1. When was the last time you ran "VACUUM ANALYZE"?

2. How about sending us an EXPLAIN if you need help?

3. There is a new list, PGSQL-PERFORMANCE, that is intended for discussion of 
these kinds of problems.   Please join it.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco