Re: CREATE INDEX speeds up query on 31 row table ... - Mailing list pgsql-hackers

From Matthew T. O'Connor
Subject Re: CREATE INDEX speeds up query on 31 row table ...
Date
Msg-id 415CDE18.9070504@zeut.net
Whole thread Raw
In response to Re: CREATE INDEX speeds up query on 31 row table ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
Responses Re: CREATE INDEX speeds up query on 31 row table ...
List pgsql-hackers
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.

Matthew



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: AIX and V8 beta 3
Next
From: "Johann Robette"
Date:
Subject: Record unassigned yet