| From: | "mcelroy, tim" <tim(dot)mcelroy(at)bostonstock(dot)com> |
|---|---|
| To: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | dbsize & pg_dump |
| Date: | 2006-04-25 20:39:40 |
| Message-ID: | 0C4841B42F87D51195BD00B0D020F5CB044B2584@MORPHEUS |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Good afternoon,
Probably an easy question but why are the file sizes differ so much between
these two tools?
For example:
A backup using pg_dump of our largest DB creates a file 384MB in size
Using the following SQL code utilizing dbsize I get the following:
FIX1=# SELECT D1.pg_size_pretty AS "FIX1_DB_SIZE"
FIX1-# FROM (SELECT pg_size_pretty(database_size('FIX1'))) D1;
FIX1_DB_SIZE
--------------
3832 MB
(1 row)
Is it safe to assume that pg_dump does a compression of the data?
Thanks
Tim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mcelroy, tim | 2006-04-25 21:06:24 | Re: dbsize & pg_dump |
| Previous Message | Uwe Maiwald | 2006-04-25 20:26:32 | waring from pg_restore |