[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] [REVIEW] Prototype: In-place upgrade v02
From:       Zdenek Kotala <Zdenek.Kotala () Sun ! COM>
Date:       2008-09-30 7:08:14
Message-ID: 48E1D05E.7020807 () sun ! com
[Download RAW message or body]

Abbas napsal(a):
> On Mon, 2008-09-29 at 14:42 +0200, Zdenek Kotala wrote:
>>
>>> Do I have to perform performance tests too?
>> Yes, please. My colleague tested it and got 5% performance drop, but it was not 
>> complete version and I tested full patch on Friday and It was surprise for me 
>> ...  I got little bit better throughput (about 0,5%) with patch. I'm going to 
>> retest it again but it would be good to get result also from others.
> 
> 
> Are there defined ways of benchmarking the current performance of pg
> database on my system?
> Are there any guide lines on what type of data or table design should be
> used?

I think integer, numeric, text and some composite type should be enough.

> One option of getting the benchmarks could be to use the run time
> statistics logging with and without the patch.

Run time statistic should be same. Patch add extra wrapper around page and 
heaptuple processing. By my opinion pg_stat* output shouldn't show extra 
difference.

> And I have to test the performance of the 4 basic queries INSERT,
> UPDATE, DELETE and SELECT, right?
> 

Yes. It would be nice compare simple SELECT and complex SELECT too.

	Thanks Zdenek




Zdenek Kotala              Sun Microsystems
Prague, Czech Republic     http://sun.com/postgresql


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
[prev in list] [next in list] [prev in thread] [next in thread]