From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Postgres Speed or lack thereof |
Date: | 1999-01-19 02:31:57 |
Message-ID: | 36A3EE9D.78796774@krs.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
>
> Vadim Mikheev <vadim(at)krs(dot)ru> writes:
> > For the table with single int4 column & 2000 INSERTs I have:
>
> > BEGIN/END: 3.5sec ~600insert/sec
> > Without: 151sec ~13insert/sec
>
> > (IDE disk!)
>
> > I guess that you don't use -F flag..?
>
> *Do* use -F, you meant of course. You're right, I do. With an
Actually no -:)
> fsync after every transaction, I'm sure my test would've been much
> slower.
Just use BEGIN/END to run all queries in single transaction -:)
> However, with a UPS and an OS that only crashes about once every
> other year, I feel pretty secure using -F ...
However, it's easy to crash Postgres itself and lose
committed transactions -:(
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Puchong | 1999-01-19 02:41:29 | (no subject) |
Previous Message | Taral | 1999-01-19 02:26:40 | Prepared statements (was: Postgres Speed or lack thereof) |