Re: Any risk in increasing BLCKSZ to get larger tuples? - Mailing list pgsql-general

From Philip Hallstrom
Subject Re: Any risk in increasing BLCKSZ to get larger tuples?
Date
Msg-id Pine.BSF.4.21.0010191541380.50734-100000@oddjob.adhesivemedia.com
Whole thread Raw
In response to Re: Any risk in increasing BLCKSZ to get larger tuples?  (Joseph Shraibman <jks@selectacast.net>)
List 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


pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: rules *very* slow?
Next
From: "Edmar Wiggers"
Date:
Subject: RE: prefer (+) oracle notation