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)
Список
Дерево обсуждения
On-disk size of db increased after restore Devrim GÜNDÜZ <devrim@gunduz.org>
Re: On-disk size of db increased after restore yj2133011 <274040551@qq.com>
Re: On-disk size of db increased after restore Richard Huxton <dev@archonet.com>
Re: On-disk size of db increased after restore Devrim GÜNDÜZ <devrim@gunduz.org>
Re: On-disk size of db increased after restore Richard Huxton <dev@archonet.com>
Re: On-disk size of db increased after restore Alvaro Herrera <alvherre@commandprompt.com>
Re: On-disk size of db increased after restore Devrim GÜNDÜZ <devrim@gunduz.org>
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>
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>
Re: On-disk size of db increased after restore Devrim GÜNDÜZ <devrim@gunduz.org>
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>
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>
Re: On-disk size of db increased after restore Devrim GÜNDÜZ <devrim@gunduz.org>
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>
Re: On-disk size of db increased after restore Scott Marlowe <scott.marlowe@gmail.com>
Re: On-disk size of db increased after restore Devrim GÜNDÜZ <devrim@gunduz.org>
Re: On-disk size of db increased after restore Thom Brown <thom@linux.com>
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 The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support
В списке pgsql-general по дате отправления