I sent this to pgsql-admin but didn't receive a response. Would this be
a WAL log performance/efficiency issue?
Thanks,
Keaton
Given these postgresql.conf settings:
#---
# WRITE AHEAD LOG
#
ks for the info,
-Keaton
On Thu, 2007-05-17 at 15:23 +0100, Heikki Linnakangas wrote:
> Keaton Adams wrote:
> > Using an 8K data page:
> >
> > 8K data page (8192 bytes)
> > Less page header and row overhead leaves ~8000 bytes
> > At 100 bytes per row = ~80 rows/pag
overhead leaves ~8000 bytes
> At 100 bytes per row = ~80 rows/page
> Rows loaded: 250,000 / 80 = 3125 data pages * 8192 = 25,600,000
> bytes / 1048576 = ~ 24.4 MB of data page space.
>
On Thu, 2007-05-17 at 08:04 -0600, Keaton Adams wrote:
> I sent this to pgsql-admin but didn'
