Re: [ADMIN] COPY TO / COPY FROM - Mailing list pgsql-sql

From Aldor
Subject Re: [ADMIN] COPY TO / COPY FROM
Date
Msg-id 433424A2.8030403@mediaroot.de
Whole thread Raw
List 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
> 
> 


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Where are user defined functions stored?
Next
From: Hilary Forbes
Date:
Subject: Re: Where are user defined functions stored?