Re: On-disk size of db increased after restore

Поиск
Список
Период
Сортировка
От Devrim GÜNDÜZ
Тема Re: On-disk size of db increased after restore
Дата
Msg-id 1283375080.2484.10.camel@hp-laptop2.gunduz.org
обсуждение исходный текст
Ответ на Re: On-disk size of db increased after restore  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: On-disk size of db increased after restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Wed, 2010-09-01 at 16:50 -0400, Alvaro Herrera wrote:
> Devrim didn't specify the platform on each server AFAICS.

Both are Red Hat /CentOS 5.5, x86_64, running with identical software
versions...

I first inclined to blame LVM+storage, however I could duplicate this
issue on local disks, too. This happened recently -- restoring data on
the same machine about 3 weeks ago did not have this issue. I need to
figure out what may happened since then...

Alvaro, this may be a stupid question but: I enabled custom autovac
settings for some tables. These changes are included in the dump. May
this affect on-disk size?

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Вложения

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: postgreSQL problem
Следующее
От: Phil Jackson
Дата:
Сообщение: Problems with ODBC Driver