Skip site navigation (1) Skip section navigation (2)

Re: poor performance of loading data

From: "Mitch Vincent" <mitch(at)doot(dot)org>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: poor performance of loading data
Date: 2001-12-19 18:31:25
Message-ID: 021701c188bb$5e2ca2d0$0200000a@Mitch (view raw or flat)
Thread:
Lists: pgsql-admin
    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" <azhang(at)verisign(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
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 majordomo(at)postgresql(dot)org
>


In response to

pgsql-admin by date

Next:From: Bojan BelovicDate: 2001-12-19 19:04:32
Subject: Re: Tuning questions..
Previous:From: Bojan BelovicDate: 2001-12-19 18:02:51
Subject: Re: [Tuning questions..]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group