Re: [HACKERS] Postgres Speed or lack thereof - Mailing list pgsql-hackers

From John Holland
Subject Re: [HACKERS] Postgres Speed or lack thereof
Date
Msg-id Pine.GSO.4.02.9901191129120.14949-100000@ganymede.isr.umd.edu
Whole thread Raw
In response to Re: [HACKERS] Postgres Speed or lack thereof  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] Postgres Speed or lack thereof
List pgsql-hackers
can you explain the -F flag? when is it passed to what? Can this be done
in plpgsql? how?


john
On
Mon, 18 Jan 1999, Tom Lane wrote:

> Vadim Mikheev <vadim@krs.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
> fsync after every transaction, I'm sure my test would've been much
> slower.
> 
> However, with a UPS and an OS that only crashes about once every
> other year, I feel pretty secure using -F ...
> 
>             regards, tom lane
> 



pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: [HACKERS] performance test
Next
From: Roberto Joao Lopes Garcia
Date:
Subject: Re: [HACKERS] Postgres Speed or lack thereof