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: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, 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-10-01 13:09:40
Message-ID: 20041001100921.M31631@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 1 Oct 2004, Matthew T. O'Connor wrote:

> Marc G. Fournier wrote:
>
>> 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 :)
>>
> There is no "normal" way to get it to go to syslog. The version of
> autovacuum that didn't make the 8.0 cut had support for it. I'm sorry to say
> that since I tried and failed to integrate autovacuum into the backend, that
> the 8.0 autovacuum in contrib is exactly the same as the 7.4.3 version :-(
>
> I'm not sure but I think someone a while ago posted a patch that added syslog
> support to pg_autovacuum.

Nope, that's cool ... using the -L function works for my purposes :)
Thanks ...

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-10-01 14:47:05 Re: Record unassigned yet
Previous Message Richard Huxton 2004-10-01 11:45:54 Re: RE : Record unassigned yet