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

Re: [HACKERS] performance tests, initial results

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: David Gould <dg(at)illustra(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] performance tests, initial results
Date: 1998-06-15 01:09:18
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
First, thanks for fixing, David (I'm not so cool perl
programmer as I would like to be -:)

>  - Assertion checking seems to cost about 7% except for create index where
>    it costs 90%

Wow! This should be discovered!

>  - Something is very wrong with our buffer cache implementation. Going from
>    256 buffers to 2048 buffers costs an average of 25%. In the 8K txn case
>    it costs about 70%. I see looking at the code and profiling that in the 8K
>    txn case this is in BufferSync() which examines all the buffers at commit
>    time. I don't quite understand why it is so costly for the single 8K row
>    txn (35%) though.

This one is in my plans for 1 - 1.5 year :)


In response to

pgsql-hackers by date

Next:From: Vassilis PapadimosDate: 1998-06-15 10:11:22
Subject: subscribe
Previous:From: David GouldDate: 1998-06-14 22:35:13
Subject: performance tests, initial results

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