From: | Aldor <an(at)mediaroot(dot)de> |
---|---|
To: | cbuschini(at)carax(dot)com |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [ADMIN] COPY TO / COPY FROM |
Date: | 2005-09-23 15:52:02 |
Message-ID: | 433424A2.8030403@mediaroot.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-sql |
> I kown I can use pg_dump to perform that "back up" but I wanted to
> test performences.
pg_dump does the same.. if you same custom it makes binary (WITH BINARY)
but with compression.
Performance?
1. TOP: inserte into select ....
2. TOP: copy / pg_restore with uncompressed binary
3. TOP: copy / pg_restore with uncompressed text
4. TOP: pg_restore with compressed binary (custom format in pg_dump)
5. TOP: normal inserts...
This is my experience.
> PATH = /home/postgres//carax_exec.out
Be aware to give postgres write/read access to this file/dir - i think
the double "//" is typee
Cédric Buschini wrote:
> Aldor wrote:
>
>> What is the name of the table you want to dump?
>>
>>
> I kown I can use pg_dump to perform that "back up" but I wanted to test
> performences.
>
> The table is carax_exec
>
>> What is the exact path you try to dump it to?
>>
>>
> PATH = /home/postgres//carax_exec.out
>
>> What version of PostgreSQL do you have?
>>
>>
> uhmm 8.0
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Darley | 2005-09-23 17:39:54 | Re: Encrypted Disks |
Previous Message | Scott Marlowe | 2005-09-23 15:32:28 | Re: alter user |
From | Date | Subject | |
---|---|---|---|
Next Message | Hilary Forbes | 2005-09-23 16:18:22 | Re: Where are user defined functions stored? |
Previous Message | Tom Lane | 2005-09-23 14:40:14 | Re: Where are user defined functions stored? |