| From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgresql limits |
| Date: | 2000-09-23 15:34:12 |
| Message-ID: | 39CCCD73.4080008@klamath.dyndns.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hans-Jürgen Schönig wrote:
> When doing multiple insert, please consider the following: PostgreSQL
> uses fsync (I think) after every insert. This is extremely slow when
> inserting large amounts of data at once. On the other hand this helps
> you to protect the database if the systems crashes.
I would have thought fsync() would be slowest when inserting lots of
little pieces of data, not big ones. But I'm just guessing.
You can disable fsync() with the '-o -F' flag to postmaster. This speeds
everything up, but if your system crashes you may lose some data.
Regards,
Neil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jarmo Paavilainen | 2000-09-23 16:13:45 | About OID and the commands/operators STRING( ... ) ..AS and + |
| Previous Message | Louis-David Mitterrand | 2000-09-23 15:26:47 | running maintenance tasks on DB |