Re: [PERFORM] copy and postgresql.conf

2006-02-15 Thread Tom Lane
"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 >

Re: [PERFORM] copy and postgresql.conf

2006-02-15 Thread Jignesh K. Shah
L 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 for the equivalent ones that I

Re: [PERFORM] copy and postgresql.conf

2006-02-15 Thread FERREIRA, William (VALTECH)
again ? -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

Re: [PERFORM] copy and postgresql.conf

2006-02-15 Thread Jignesh K. Shah
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 improvements came with 8.1 (http://www.postgresql.org/docs/whatsnew) A Dimarts 14 Fe

Re: [PERFORM] copy and postgresql.conf

2006-02-15 Thread FERREIRA, William (VALTECH)
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, FERREIRA, William (VALTECH) va escriure: > thanks,

Re: [PERFORM] copy and postgresql.conf

2006-02-15 Thread Markus Schaber
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 impro

Re: [PERFORM] copy and postgresql.conf

2006-02-15 Thread FERREIRA, William (VALTECH)
06 22:47 À : 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/jk

Re: [PERFORM] copy and postgresql.conf

2006-02-14 Thread Jignesh K. Shah
!!! 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,

Re: [PERFORM] copy and postgresql.conf

2006-02-14 Thread FERREIRA, William (VALTECH)
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

Re: [PERFORM] copy and postgresql.conf

2006-02-14 Thread Albert Cervera Areny
--Message d'origine- > De : [EMAIL 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, >

Re: [PERFORM] copy and postgresql.conf

2006-02-14 Thread FERREIRA, William (VALTECH)
Objet : Re: [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

Re: [PERFORM] copy and postgresql.conf

2006-02-14 Thread Albert Cervera Areny
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 improv

[PERFORM] copy and postgresql.conf

2006-02-14 Thread FERREIRA, William (VALTECH)
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 which