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

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@hub.org           Yahoo!: yscrappy              ICQ: 7615664