: FERREIRA, William (VALTECH)
Cc : Albert Cervera Areny; pgsql-performance@postgresql.org
Objet : Re: [PERFORM] copy and postgresql.conf
What version of Solaris are you using?
Do you have the recommendations while using COPY on Solaris?
http://blogs.sun.com/roller/page/jkshah?entry
Hi, Ferreira,
FERREIRA, William (VALTECH) wrote:
i load data from files using copy method.
Files contain between 2 and 7 millions of rows, spread on 5 tables.
For loading all the data, it takes 40mn, and the same processing takes 17mn
with Oracle.
I think that this time can be improved
]
[mailto:[EMAIL PROTECTED] la part de Albert
Cervera Areny
Envoyé : mardi 14 février 2006 17:07
À : pgsql-performance@postgresql.org
Objet : Re: [PERFORM] copy and postgresql.conf
Sorry, COPY improvements came with 8.1
(http://www.postgresql.org/docs/whatsnew)
A Dimarts 14 Febrer 2006 14:26
?
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 15 février 2006 15:14
À : FERREIRA, William (VALTECH)
Cc : Albert Cervera Areny; pgsql-performance@postgresql.org
Objet : Re: [PERFORM] copy and postgresql.conf
What's your postgresql.conf parameter
:[EMAIL PROTECTED]
Envoyé : mercredi 15 février 2006 15:14
À : FERREIRA, William (VALTECH)
Cc : Albert Cervera Areny; pgsql-performance@postgresql.org
Objet : Re: [PERFORM] copy and postgresql.conf
What's your postgresql.conf parameter for the equivalent ones that I
suggested?
I believe your
FERREIRA, William (VALTECH) [EMAIL PROTECTED] writes:
with PostgreSQL 8.1.3, here are my parameters (it's the default configuration)
wal_sync_method = fsync
wal_buffers = 8
checkpoint_segments = 3
bgwriter_lru_percent = 1.0
bgwriter_lru_maxpages = 5
bgwriter_all_percent = 0.333
hi,
i load data from files using copy method.
Files contain between 2 and 7 millions of rows, spread on 5 tables.
For loading all the data, it takes 40mn, and the same processing takes 17mn
with Oracle.
I think that this time can be improved by changing postgresql configuration
file.
But
Hi William,
which PostgreSQL version are you using? Newer (8.0+) versions have some
important performance improvements for the COPY command.
Also, you'll notice significant improvements by creating primary
foreign
keys after the copy command. I think config tweaking can
: [PERFORM] copy and postgresql.conf
Hi William,
which PostgreSQL version are you using? Newer (8.0+) versions have some
important performance improvements for the COPY command.
Also, you'll notice significant improvements by creating primary
foreign
keys after the copy command. I
PROTECTED]
[mailto:[EMAIL PROTECTED] la part de Albert
Cervera Areny
Envoyé : mardi 14 février 2006 12:38
À : pgsql-performance@postgresql.org
Objet : Re: [PERFORM] copy and postgresql.conf
Hi William,
which PostgreSQL version are you using? Newer (8.0+) versions have some
30% faster !!! i will test this new version ...
thanks a lot
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] la part de Albert
Cervera Areny
Envoyé : mardi 14 février 2006 17:07
À : pgsql-performance@postgresql.org
Objet : Re: [PERFORM] copy and postgresql.conf
!!! i will test this new version ...
thanks a lot
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] la part de Albert
Cervera Areny
Envoyé : mardi 14 février 2006 17:07
À : pgsql-performance@postgresql.org
Objet : Re: [PERFORM] copy and postgresql.conf
Sorry, COPY
12 matches
Mail list logo