Re: Any risk in increasing BLCKSZ to get larger tuples?

From: Philip Hallstrom <philip(at)adhesivemedia(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Any risk in increasing BLCKSZ to get larger tuples?
Date: 2000-10-19 22:44:57
Message-ID: Pine.BSF.4.21.0010191541380.50734-100000@oddjob.adhesivemedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[stuff about why 7.1 isn't out and the 8K limit and TOAST AND WAL snipped]

> And do you really think that WAL is more important that TOAST? I
> imagine a good percentage of users bump up against the 8K limit and end
> up with corrupted data (like I did) but much fewer think that WAL is a
> critical feature.

If I had to pick I would rather have WAL over TOAST. I originally asked
the question about BLCKSZ and this is the first app that I am worried
about hitting that limit. It's actually never even crossed my mind before
this since usually if it's big it's an image and I just store it on disk
with a filename in the database. And I would say for a lot of web uses 8K
(or the 32K max) is way more than adequate.
WAL on the other hand would be really nice because even if my data
is small, it sure would be nice to reproduce it in the case of a monstrous
crash.

just my 2 cents.

-philip

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edmar Wiggers 2000-10-19 23:00:58 RE: prefer (+) oracle notation
Previous Message Neil Conway 2000-10-19 22:37:14 Re: rules *very* slow?