Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] Optimization disaster - Mailing list pgsql-novice

From Josh Berkus
Subject Re: [BUGS] Optimization disaster
Date
Msg-id 200210231707.50016.josh@agliodbs.com
Whole thread Raw
In response to Re: [BUGS] Optimization disaster  (Andrew McMillan <andrew@catalyst.net.nz>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Andrew McMillan
Date:
Subject: Re: [BUGS] Optimization disaster
Next
From: "Josh Berkus"
Date:
Subject: Re: how to create secondary key!!