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

Re: [BUGS] Optimization disaster

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>,Dietrich <hoglabogla(at)hotmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [BUGS] Optimization disaster
Date: 2002-10-24 00:07:50
Message-ID: 200210231707.50016.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-novice
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


In response to

pgsql-novice by date

Next:From: Josh BerkusDate: 2002-10-24 04:41:57
Subject: Re: how to create secondary key!!
Previous:From: Andrew McMillanDate: 2002-10-24 00:02:15
Subject: Re: [BUGS] Optimization disaster

pgsql-bugs by date

Next:From: Arne WoernerDate: 2002-10-24 08:59:53
Subject: Re: 10 concurrent clients / pure insert SQL scripts (each 100000 lines)
Previous:From: Andrew McMillanDate: 2002-10-24 00:02:15
Subject: Re: [BUGS] Optimization disaster

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