Re: FSM patch - performance test - Mailing list pgsql-hackers

From Tom Lane
Subject Re: FSM patch - performance test
Date
Msg-id 21446.1221754752@sss.pgh.pa.us
Whole thread Raw
In response to Re: FSM patch - performance test  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: FSM patch - performance test  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> Zdenek Kotala wrote:
>> My conclusion is that new implementation is about 8% slower in OLTP 
>> workload.

> Thanks. That's very disappointing :-(

One thing that jumped out at me is that you call FreeSpaceMapExtendRel
every time a rel is extended by even one block.  I admit I've not
studied the data structure in any detail yet, but surely most such calls
end up being a no-op?  Seems like some attention to making a fast path
for that case would be helpful.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Do we really need a 7.4.22 release now?
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: Do we really need a 7.4.22 release now?