Re: list rewrite committed - Mailing list pgsql-hackers

From Neil Conway
Subject Re: list rewrite committed
Date
Msg-id 40B64355.1020907@samurai.com
Whole thread Raw
In response to Re: list rewrite committed  (Jeff <threshar@torgo.978.org>)
Responses Re: list rewrite committed  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Jeff wrote:
> Do we have any numbers as to how much this will help things?

No, I haven't done any benchmarking yet (I might do some before I 
leave for the summer, but it's not a priority...)

FWIW, the performance improvement from this patch won't be as large 
as it might be, since Tom already replaced some lappend() hot spots 
with the "FastList" code. The new list API makes that optimization 
global, so we'll fix anywhere that fell through the cracks.

> If not, would something like a pg_bench exercise the new code enough to 
> see the results?

Something like TPC-H would be better, I'd think.

-Neil



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SELECT * FROM LIMIT 1; is really slow
Next
From: Manfred Koizar
Date:
Subject: Re: SELECT * FROM
LIMIT 1; is really slow