read block size

From: Michael Stone <mstone+postgres(at)mathom(dot)us>
To: pgsql-performance(at)postgresql(dot)org
Subject: read block size
Date: 2005-06-28 15:27:50
Message-ID: 20050628152750.GV9591@mathom.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Is it possible to tweak the size of a block that postgres tries to read
when doing a sequential scan? It looks like it reads in fairly small
blocks, and I'd expect a fairly significant boost in i/o performance
when doing a large (multi-gig) sequential scan if larger blocks were
used.

Mike Stone

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2005-06-28 15:30:34 Re: tricky query
Previous Message Cosimo Streppone 2005-06-28 15:20:13 Re: tricky query