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

Re: Poor index choice -- multiple indexes of the same

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
Cc: josh(at)agliodbs(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Poor index choice -- multiple indexes of the same
Date: 2005-06-28 03:11:25
Message-ID: 1119928285l.11411l.4l@mofo (view raw or flat)
Thread:
Lists: pgsql-performance
On 06/27/2005 09:36:51 PM, Karl O. Pinc wrote:

> I'm doing this in a torture test script, loading data.
> Every fibnocci number of rows * 100 I VACCUM ANALYZE.
> So, 100, 200, 300, 500, 800, etc.

(And of course disconnect my client and re-connect so
as to use the new statistics.  sure would be nice if
I didn't have to do this.)

Karl <kop(at)meme(dot)com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein


In response to

pgsql-performance by date

Next:From: Christopher Kings-LynneDate: 2005-06-28 03:20:36
Subject: Re: How can I speed up this function?
Previous:From: David MitchellDate: 2005-06-28 03:11:02
Subject: Re: How can I speed up this function?

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