Re: understanding postgres issues/bottlenecks

From: "Stefano Nichele" <stefano(dot)nichele(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: understanding postgres issues/bottlenecks
Date: 2009-01-11 15:09:58
Message-ID: bdb13b210901110709t68b85b0di4989a5cc934ea267@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Here some number from a mine old pgfouine report:
> - query peak: 378 queries/s
> - select: 53,1%, insert 3,8%, update 2,2 %, delete 2,8 %
>
>
Actually the percentages are wrong (I think pgfouine counts also other types
of query like ET SESSION CHARACTERISTICS AS TRANSACTION READ WRITE;):
These are the right ones:

SELECT num: 658,5 perc: 85,7 %
INSERT num: 47,66 perc: 6,2 %
UPDATE num: 27,49 perc: 3,6 %
DELETE num: 34,56 perc: 4,5 %

ste

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2009-01-11 18:07:19 Re: understanding postgres issues/bottlenecks
Previous Message Stefano Nichele 2009-01-11 15:00:10 Re: understanding postgres issues/bottlenecks