Re: CREATE INDEX speeds up query on 31 row table ...

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Greg Stark <gsstark(at)mit(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: CREATE INDEX speeds up query on 31 row table ...
Date: 2004-09-30 23:03:14
Message-ID: 20040930195958.K23868@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 30 Sep 2004, Matthew T. O'Connor wrote:

> Are you using default values for autovacuum? Could you prove a little
> more detail by setting pg_autovacuum debug with -d 2

Sure ... just restarted it with that setup ... btw ... I'm using -L for
logging ... what is the usual way of gettin git to go to syslog? I don't
mind the extra debugging level, but would like to be able to auto-rotate
the log :)

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2004-09-30 23:04:30 Re: CREATE INDEX speeds up query on 31 row table ...
Previous Message Alvaro Herrera 2004-09-30 22:57:16 Re: Reviving Time Travel (was Re: 'TID index')