Re: Autovacuum firing up during my manual vacuum on same table

От

Scott Marlowe

Тема

Дата

3 апреля 2011 г. в 18:22:11

Msg-id

BANLkTinsG8sAEr3As+Y0rKu6gV9XEOH_JA@mail.gmail.com

обсуждение

Ответ на

Re: Autovacuum firing up during my manual vacuum on same table (Joshua D. Drake)

Список

pgsql-general

Дерево обсуждения

Autovacuum firing up during my manual vacuum on same table "Henry C." <henka@cityweb.co.za> 2 апреля 2011 г. в 08:25:30

Re: Autovacuum firing up during my manual vacuum on same table Jens Wilke <jens@wilke.org> 2 апреля 2011 г. в 09:23:54

Re: Autovacuum firing up during my manual vacuum on same table "Sven Haag" <sven-haag@gmx.de> 2 апреля 2011 г. в 11:06:40

Re: Autovacuum firing up during my manual vacuum on same table "Henry C." <henka@cityweb.co.za> 2 апреля 2011 г. в 14:20:20

Re: Autovacuum firing up during my manual vacuum on same table Guillaume Lelarge <guillaume@lelarge.info> 2 апреля 2011 г. в 11:47:24

Re: Autovacuum firing up during my manual vacuum on same table "Henry C." <henka@cityweb.co.za> 2 апреля 2011 г. в 14:58:52

Re: Autovacuum firing up during my manual vacuum on same table Jens Wilke <jens@wilke.org> 2 апреля 2011 г. в 16:41:57

Re: Autovacuum firing up during my manual vacuum on same table "Joshua D. Drake" <jd@commandprompt.com> 3 апреля 2011 г. в 17:39:59

Re: Autovacuum firing up during my manual vacuum on same table Jens Wilke <jens@wilke.org> 4 апреля 2011 г. в 16:49:59

Re: Autovacuum firing up during my manual vacuum on same table Scott Marlowe <scott.marlowe@gmail.com> 3 апреля 2011 г. в 18:22:11

Re: Autovacuum firing up during my manual vacuum on same table Scott Marlowe <scott.marlowe@gmail.com> 2 апреля 2011 г. в 16:26:59

Re: Autovacuum firing up during my manual vacuum on same table Tom Lane <tgl@sss.pgh.pa.us> 2 апреля 2011 г. в 17:31:30

Re: Autovacuum firing up during my manual vacuum on same table "Henry C." <henka@cityweb.co.za> 3 апреля 2011 г. в 07:04:18

Re: Autovacuum firing up during my manual vacuum on same table "Henry C." <henka@cityweb.co.za> 2 апреля 2011 г. в 17:25:32

Re: Autovacuum firing up during my manual vacuum on same table "Henry C." <henka@cityweb.co.za> 2 апреля 2011 г. в 08:45:51

On Sun, Apr 3, 2011 at 2:39 PM, Joshua D. Drake  wrote:
> On Sat, 2 Apr 2011 19:26:56 +0200, "Henry C."  wrote:
>> On Sat, April 2, 2011 14:17, Jens Wilke wrote:
>>> Nevertheless since at least 8.4 IMO there's no need to bother with
>>> manual vacuum any more.
>
> Uhh, this is entirely untrue. There are plenty of cases where 8.4
> autovacuum can't cut it.

This is doubly true if you haven't adjusted any of the default costing
parameters of autovacuum. It is not set to the level of aggressiveness
needed for big servers under high load, since doing so would slow down
/ swamp smaller servers.

В списке pgsql-general по дате отправления

Предыдущее

От: Joshua D. Drake

Дата: 3 апреля 2011 г. в 17:39:59

Сообщение: Re: Autovacuum firing up during my manual vacuum on same table

Следующее

От: Annamalai Gurusami

Дата: 4 апреля 2011 г. в 01:43:10

Сообщение: Re: Merged Model for libpq