Re: [GENERAL] [GENERAL/INTERFACES] Dynamically detecting need to vacuum?
От
Peter Eisentraut
Тема
Re: [GENERAL] [GENERAL/INTERFACES] Dynamically detecting need to
vacuum?
Дата
Msg-id
Pine.LNX.4.20.9912132250040.361-100000@localhost.localdomain
Ответ на
Список
Дерево обсуждения
Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM? Adriaan Joubert <a.joubert@albourne.com>
On 1999-12-13, Ed Loehr mentioned: > documentation recommends to vacuum nightly or after copying a large class > (not sure exactly what that means) or deleting a large number of records. copying -- as invoked via the COPY command (in general this means inserting, though) large -- probably anything with triple-digit row counts class -- table, relation; in general rows, records, data, stuff > [Hackers: it'd be nice to have pgsql optionally take care of this...] There are some disabled code fragments that take into account a "vacuum daemon". It's even on the TODO list, but vacuum itself needs to be sorted out first. Sorry, no free lunch here, probably. -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
В списке pgsql-general по дате отправления
От: Peter Eisentraut
Дата:
От: Lamar Owen
Дата: