Are the rows huge? What kind of machine hardware-wise are we talking
about? Did you start the postmaster with fsync disabled? I generally turn
fsync off for importing, the improvement is amazing :-)Good luck! -Mitch ----- Original Message ----- From: "Zhang, Anna" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 10:57 AM Subject: [ADMIN] poor performance of loading data > > I just installed Postgres 7.1.3 on my Red Hat 7.2 linux box. We are doing > research to see how postgres doing, I used copy utility to import data from > a text file which contains 32 mils rows, it has been 26 hours passed, but > still running. My question is how postgres handles such data loading? it > commited every row? or commit point is adjustable? How? Does postgres > provide direct load to disk files like oracle? Other ways to speed up? If > loading performance can't be improved significantly, we have to go back to > oracle. Anybody can help? Thanks! > > Anna Zhang > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
