copy and postgresql.conf

From: "FERREIRA, William (VALTECH)" <william(dot)ferreira(at)airbus(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: copy and postgresql.conf
Date: 2006-02-14 09:44:59
Message-ID: 414D259CE29DE54DAD534037C83CE4B7269627@FR0-MAILMB20.res.airbus.corp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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 parameters i need to manipulate and with which values ?

Here are the specifications of my system :
V250 architecture sun4u
2xCPU UltraSparc IIIi 1.28 GHz.
8 Go RAM.

Regards.

Will

This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Albert Cervera Areny 2006-02-14 11:38:24 Re: copy and postgresql.conf
Previous Message Adnan DURSUN 2006-02-14 09:33:57 Re: SQL Function Performance