On 02/24/11 11:02 AM, Aleksey Tsalolikhin wrote:
> How do I check the fillfactor on the table, please?
its in the field reloptions in pg_class. so...
select reloptions from pg_class where relname='tablename';
if tablename is non-unique, you'll need to qualify that with the OID of
the namespace (aka schema).
> My largest table is 50 GB in size; when I pg_dump it, and then
> pg_restore it, it becomes 100 GB in size.
>
> How do I pg_restore it so that it is 50 GB in size? Is it a setting
> to pg_dump or to pg_restore?
>
are you truncating the table before restoring, or is this a restore into
a new database, or what?