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

Поиск
Список
Период
Сортировка
От Matthew T. O'Connor
Тема Re: CREATE INDEX speeds up query on 31 row table ...
Дата
Msg-id 415CDE18.9070504@zeut.net
обсуждение исходный текст
Ответ на Re: CREATE INDEX speeds up query on 31 row table ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
Ответы Re: CREATE INDEX speeds up query on 31 row table ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: AIX and V8 beta 3
Следующее
От: "Johann Robette"
Дата:
Сообщение: Record unassigned yet