On Wed, Mar 12, 2008 at 9:55 PM, Craig James <[EMAIL PROTECTED]> wrote: > I just received a new server and thought benchmarks would be interesting. I > think this looks pretty good, but maybe there are some suggestions about the > configuration file. This is a web app, a mix of read/write, where writes > tend to be "insert into ... (select ...)" where the resulting insert is on > the order of 100 to 10K rows of two integers. An external process also uses > a LOT of CPU power along with each query.
Have you been inserting each insert individually, or as part of a larger transaction. Wrapping a few thousand up in a begin;end; pair can really help. You can reasonably wrap 100k or more inserts into a single transaction. if any one insert fails the whole insert sequence fails. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance