Re: On-disk size of db increased after restore

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: On-disk size of db increased after restore
Дата
Msg-id 1283374138-sup-5802@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: On-disk size of db increased after restore  (Richard Huxton <dev@archonet.com>)
Ответы Re: On-disk size of db increased after restore  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: On-disk size of db increased after restore  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Список pgsql-general
Excerpts from Richard Huxton's message of mié sep 01 16:39:55 -0400 2010:

> OK - so not fillfactor and not some unicode-related padding. I can't see
> how a 32 vs 64-bit architecture change could produce anything like a
> doubling of database size.

Depending on table schemas, why not?  e.g. consider a table with a
single bool column.  It will waste 7 bytes on 8-byte MAXALIGN machine
but only 3 on a 4-byte MAXALIGN machine.  Of course, this is a corner
case.  Devrim didn't specify the platform on each server AFAICS.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: On-disk size of db increased after restore
Следующее
От: Tom Lane
Дата:
Сообщение: Re: On-disk size of db increased after restore