Skip site navigation (1) Skip section navigation (2)

Increasing row size beyond 8k

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Increasing row size beyond 8k
Date: 2000-05-28 14:50:41
Message-ID: 00db01bfc8b4$18f2d860$ (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
    There was some talk a while back of changing the blocksize to 32k in
order to increase possible row size, I need to do this (and don't want to
screw anything up) but am unsure about how to go about it.. Is BLKSZ (if
that's even correct) simply a PG variable somewhere?

I see this in my LINT kernel configuration file (I'm using FreeBSD 4.0)

# BLKDEV_IOSIZE sets the default block size used in user block
# device I/O.  Note that this value will be overriden by the label
# when specifying a block device from a label with a non-0
# partition blocksize.  The default is PAGE_SIZE.
options         BLKDEV_IOSIZE=8192

That sounds like what I'm looking for and since it's set to 8k, looks like
what I'm looking for -- so would I be correct in changing this value and
re-compiling my kernel?




pgsql-hackers by date

Next:From: Olivier PRENANTDate: 2000-05-28 17:01:57
Subject: Re: Perl 5.6.0
Previous:From: Andreas ZeugswetterDate: 2000-05-28 08:12:23
Subject: Re: Proposal for enhancements of privilege system

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group