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
