Re: Vacuum on the database versus individual tables.

Поиск
Список
Период
Сортировка
От Hartman, Matthew
Тема Re: Vacuum on the database versus individual tables.
Дата
Msg-id 366642367C5B354197A1E0D27BC175BD0225979B@KGHMAIL.KGH.ON.CA
обсуждение исходный текст
Ответ на Re: Vacuum on the database versus individual tables.  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Ответы Re: Vacuum on the database versus individual tables.  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Список pgsql-general
Windows XP, PostgreSQL 8.3.5, using pgAdmin III 1.8.4. It's the typical "Running vacuum on this table is recommended"
dialogbox. 


Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
(613) 549-6666 x4294

-----Original Message-----
From: Grzegorz Jaśkiewicz [mailto:gryzman@gmail.com]
Sent: Thursday, June 25, 2009 11:25 AM
To: Hartman, Matthew
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Vacuum on the database versus individual tables.

On Thu, Jun 25, 2009 at 3:40 PM, Hartman,
Matthew<Matthew.Hartman@krcc.on.ca> wrote:
> On occasion I'll perform a full vacuum on a database but will still receive
> a suggestion to vacuum an individual table immediately after. Does the full
> database vacuum not handle each individual table?

What's the exact message, what OS, what pg version, how do you call vacuum.




--
GJ


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

Предыдущее
От: mobiledreamers@gmail.com
Дата:
Сообщение: Re: horizontal sharding
Следующее
От: "Chris Spotts"
Дата:
Сообщение: planned recovery from a certain transaction