pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: mcelroy, tim <tim.mcelroy@bostonstock.com>
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>
Subject: Re: dbsize &  pg_dump
Date: Tue, 25 Apr 2006 17:06:24 -0400
Message-ID: <0C4841B42F87D51195BD00B0D020F5CB044B2586@MORPHEUS> (raw)

Please disregard this question.  I'm using pg_dump -F c which compresses the
data a it backs it up.
 
Tim
 
 
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of mcelroy, tim
Sent: Tuesday, April 25, 2006 4:40 PM
To: 'pgsql-admin@postgresql.org'
Subject: [ADMIN] dbsize & pg_dump
 
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

view thread (4+ messages)  latest in thread

Message-ID: <0C4841B42F87D51195BD00B0D020F5CB044B2586@MORPHEUS>
Permalink:  ../0C4841B42F87D51195BD00B0D020F5CB044B2586@MORPHEUS/
Also on:    postgresql.org/message-id/0C4841B42F87D51195BD00B0D020F5CB044B2586@MORPHEUS

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tim.mcelroy@bostonstock.com
  Subject: Re: dbsize &  pg_dump
  In-Reply-To: <0C4841B42F87D51195BD00B0D020F5CB044B2586@MORPHEUS>
  References: <0C4841B42F87D51195BD00B0D020F5CB044B2586@MORPHEUS>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox