Jeff Davis <[EMAIL PROTECTED]> writes:
> On Tue, 2006-10-03 at 00:42 +0200, Alexander Staubo wrote:
>> Why does pg_dump serialize data less efficiently than PostgreSQL when
>> using the "custom" format?
> What you're saying is more theoretical. If pg_dump used specialized
> compression based on
On Tue, 2006-10-03 at 00:42 +0200, Alexander Staubo wrote:
> Why does pg_dump serialize data less efficiently than PostgreSQL when
> using the "custom" format? (Pg_dump arguably has greater freedom in
> being able to apply space-saving optimizations to the output format.
> For example, one co
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/02/06 16:19, Tom Lane wrote:
> Alexander Staubo <[EMAIL PROTECTED]> writes:
>> You could count the disk space usage of the actual stored tuples,
>> though this will necessarily be inexact:
>>http://www.postgresql.org/docs/8.1/static/diskusa
On Oct 2, 2006, at 23:19 , Tom Lane wrote:
Alexander Staubo <[EMAIL PROTECTED]> writes:
You could count the disk space usage of the actual stored tuples,
though this will necessarily be inexact:
http://www.postgresql.org/docs/8.1/static/diskusage.html
Or you could count the size of the physi
Alexander Staubo <[EMAIL PROTECTED]> writes:
> You could count the disk space usage of the actual stored tuples,
> though this will necessarily be inexact:
>http://www.postgresql.org/docs/8.1/static/diskusage.html
> Or you could count the size of the physical database files (/var/lib/
> post
Alexander Staubo wrote:
On Oct 2, 2006, at 22:17 , Madison Kelly wrote:
I am (re)writing a backup program and I want to add a section for
backing up pSQL DBs. In the planning steps (making sure a given
destination has enough space) I try to calculate how much space will
be needed by a 'pg_d
Steve Wampler wrote:
Madison Kelly wrote:
Hi all,
I am (re)writing a backup program and I want to add a section for
backing up pSQL DBs. In the planning steps (making sure a given
destination has enough space) I try to calculate how much space will be
needed by a 'pg_dump' run *before* actual
On Oct 2, 2006, at 22:17 , Madison Kelly wrote:
I am (re)writing a backup program and I want to add a section for
backing up pSQL DBs. In the planning steps (making sure a given
destination has enough space) I try to calculate how much space
will be needed by a 'pg_dump' run *before* actu
Madison Kelly wrote:
> Hi all,
>
> I am (re)writing a backup program and I want to add a section for
> backing up pSQL DBs. In the planning steps (making sure a given
> destination has enough space) I try to calculate how much space will be
> needed by a 'pg_dump' run *before* actually dumping i
