Skip site navigation (1) Skip section navigation (2)

Re: time to stop tuning?

From: Rod Taylor <rbt(at)sitesell(dot)com>
To: David Parker <dparker(at)tazznetworks(dot)com>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: time to stop tuning?
Date: 2004-11-26 21:48:40
Message-ID: 1101505720.13382.2.camel@home (view raw or flat)
Thread:
Lists: pgsql-performance
> On limiting the client side connections: we've been gradually pushing up
> the client-side connection pool and threads, and have seen steady
> improvement in our throughput up to the current barrier we have reached.

Very well.. Sometimes more simultaneous workers helps, other times it
hinders.

> I've attached the plans for the 4 queries that represent ~35% of our
> load. These are run against the same dataset, but without any other
> load. Another big query basically requires a test to be runnning because

Those aren't likely from your production system as there isn't any data
in those tables and the queries took less than 1ms.

-- 
Rod Taylor <rbt(at)sitesell(dot)com>


In response to

pgsql-performance by date

Next:From: Casey Allen ShobeDate: 2004-11-27 02:11:13
Subject: Re: [dspam-users] Postgres vs. MySQL
Previous:From: Clifton RoystonDate: 2004-11-26 20:35:31
Subject: Re: [dspam-users] Postgres vs. MySQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group