"Peter T. Brown" <[EMAIL PROTECTED]> writes:
> Regarding the SQL: The query I showed there is built dynamically from a
> library of queries chosen by the application user (using a web gui). For
> now, I don't have any way to intelligently condense the often complex series
> of operations into a si
e files in pg_xlog should never be
used, right?
Thanks Again,
Peter T. Brown
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 12:02 PM
To: Peter T. Brown
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] performance tuning on inserts
"Peter T. Bro
"Peter T. Brown" <[EMAIL PROTECTED]> writes:
> All of my queries rely heavily on doing INSERT INTO. So is there some
> special behavior with insert's, where they are flushed to disk one by one?
> If I simply increase checkpoint_segments to 50 or so would this cause
> inserts to occur only in memor
Check this
http://candle.pha.pa.us/main/writings/pgsql/hw_performance/index.html
I would think that you would see *some* increase in performance by turning
fsync off I see huge increases in performance of INSERT/UPDATE with
fsync off.
-Mitch
- Original Message -
From: "Peter T. Brow
