Re: BLCKSZ fun facts - Mailing list pgsql-hackers

From Tom Lane
Subject Re: BLCKSZ fun facts
Date
Msg-id 17186.1164733739@sss.pgh.pa.us
Whole thread Raw
In response to BLCKSZ fun facts  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: BLCKSZ fun facts  (Kenneth Marshall <ktm@it.is.rice.edu>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Aside from that my pgbench testing clearly shows that block sizes larger 
> than 2048 become progressively slower.  Go figure.

I believe that pgbench only stresses the "small writes" case, so
perhaps this result isn't too surprising.  You'd want to look at a mix
of small and bulk updates before drawing any final conclusions.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Short writes
Next
From: Jeff Davis
Date:
Subject: Re: Integrating Replication into Core