RE: Extending to 32K row limit

From: "Darren King" <darrenk(at)insightdist(dot)com>
To: <pgsql-hackers(at)hub(dot)org>
Subject: RE: Extending to 32K row limit
Date: 2000-08-08 18:14:50
Message-ID: NDBBJNEIGLIPLCHCMANLMEAICFAA.darrenk@insightdist.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message G. Anthony Reina 2000-08-08 18:17:19 Re: Extending to 32K row limit
Previous Message Don Baccus 2000-08-08 17:51:16 Re: Extending to 32K row limit