RE: Extending to 32K row limit - Mailing list pgsql-hackers

From Darren King
Subject RE: Extending to 32K row limit
Date
Msg-id NDBBJNEIGLIPLCHCMANLMEAICFAA.darrenk@insightdist.com
Whole thread Raw
In response to Extending to 32K row limit  ("G. Anthony Reina" <reina@nsi.edu>)
List pgsql-hackers
> I know that I've seen this answer before but can't seem to find it for
> 7.0.2 in the archives. Which file(s) need to be changed to have Postgres
> default to 32K size row limits rather than 8K? Has anyone run into any
> horror stories after going to 32K?

Bumping it to 32K on AIX 4.1 broke the disk drivers here, so I would say it
depends on your platform.  Going to 16K worked fine, but after the jump to
32K, some fsck'ing was required to fix up our drives.

The problem was definitely in AIX since many other platforms have reported
no problems with the 32K setting.  If another use has bumped it up
successfully for the same platform as yours, then I'd feel confident in
doing it.  If you don't get a reply to that effect or can't find it in the
archives that someone has done it, I'd recommend putting it to 32K on a test
machine first.

Just my $.02 worth after trying it on AIX 4.1.

Darren



pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: Extending to 32K row limit
Next
From: Stephan Szabo
Date:
Subject: Re: Constraint stuff (fwd)