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

Re: Opteron/FreeBSD/PostgreSQL performance poor

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: andy rost <andy(dot)rost(at)noaa(dot)gov>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org, Bill(dot)Sites(at)noaa(dot)gov
Subject: Re: Opteron/FreeBSD/PostgreSQL performance poor
Date: 2006-07-07 22:05:31
Message-ID: Pine.LNX.4.64.0607071500540.3599@glacier.frostconsultingllc.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, 7 Jul 2006, andy rost wrote:

>> is that 100k context switches over 10 seconds or one second? that
>> might be something to check out.  pg 8.1 is regarded as the solution
>> to any cs problem, though.
>
> According to man top, that's 100K per second. I'm interested in your 
> recommendation but am not sure what "pg 8.1" references

pg 8.1 means PostgreSQL 8.1.x (preferably 8.1.4) which is said to resolve many 
context switch issues.

>> 
>> can you please approximate roughly how many transactions per second
>> your server is handling while you are getting the 20 load condition
>> (and, if possible, broken down into read and write transactions)?
>
> Do you have any suggestions on how I might obtain these metrics?
>

Every five minutes do:

select sum(xact_commit) + sum(xact_rollback) as transactions from pg_stat_database;

and then divide the difference by 300 and that's your transactions per second:

select sum(xact_commit) + sum(xact_rollback) as transactions from 
pg_stat_database;

  transactions
--------------
     231894522
(1 row)


<wait 300 seconds>

select sum(xact_commit) + sum(xact_rollback) as transactions from 
pg_stat_database;

  transactions
--------------
     231907346
(1 row)

(231907346-231894522)/300 = 42.74666666666666666666 TPS


-- 
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954

In response to

pgsql-performance by date

Next:From: William Scott JordanDate: 2006-07-07 22:29:19
Subject: VACUUM vs. REINDEX
Previous:From: K-Bob bodyDate: 2006-07-07 21:59:07
Subject: Delete is very slow; PG not using existing index to check foreign keys

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