Re: where is my bottleneck? - Mailing list pgsql-general

From Jeff Fitzmyers
Subject Re: where is my bottleneck?
Date
Msg-id F03E9013-2DEB-11D6-896F-0003938387F4@yahoo.com
Whole thread Raw
In response to where is my bottleneck?  (Ben <bench@silentmedia.com>)
List pgsql-general
> getting through. Each client connection does ~1500 lookups in the
> control
> table and another ~1500 inserts into the data table.

Have you tried a timing 100,000 simple INSERTs / SELECTs / UPDATEs
locally? Then you would have an approximate number for raw capability.
Then add a client connection. Then multiple connections. Then build up
to the clients queries.

Interesting question, Jeff


pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: Aborting transaction on error
Next
From: Justin Clift
Date:
Subject: Re: PostgreSQL favicon.ico