| From: | John Holland <jholland(at)isr(dot)umd(dot)edu> |
|---|---|
| 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 16:29:35 |
| Message-ID: | Pine.GSO.4.02.9901191129120.14949-100000@ganymede.isr.umd.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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
> 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pawel Pierscionek | 1999-01-19 18:57:35 | Temporary tables |
| Previous Message | Roberto Joao Lopes Garcia | 1999-01-19 15:43:43 | Re: [HACKERS] Postgres Speed or lack thereof |