From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
---|---|
To: | Anton de Wet <adw(at)obsidian(dot)co(dot)za> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Why PostgreSQL is better than other commerial softwares? |
Date: | 1998-12-18 09:41:40 |
Message-ID: | 367A2354.E998763@krs.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Anton de Wet wrote:
>
> >
> > Often quick mailing list support?
>
> :-)
>
> While on the subject I finally found the solution to a problem I (and one
> or two other people) posted about without answer. (So sometimes it's slow
> mailing list support).
>
> In importing about 5 million records (which I copy in blocks of 10000) the
> copy became linearly slower. After a friend RTFM and refered me, I used
> the -F switch (passed by the postmaster to the backend processes) and the
> time became linear and a LOT shorter. Import time for the 5000000 records
> now the same (or maybe even slightly faster, I didn't accurately time
> them) as importing the data into oracle on the same machine.
"While on the subject..." -:)
This is the problem of buffer manager, known for very long time:
when copy eats all buffers, manager begins write/fsync each
durty buffer to free buffer for new data. All updated relations
should be fsynced _once_ @ transaction commit. You would get
the same results without -F...
I still have no time to implement this -:(
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 1998-12-18 09:48:07 | Re: [GENERAL] date_part bug? |
Previous Message | Anton de Wet | 1998-12-18 08:57:55 | Re: [GENERAL] Why PostgreSQL is better than other commerial softwares? |