Re: FAQ (disk space) - Mailing list pgsql-general

From Einar Indridason
Subject Re: FAQ (disk space)
Date
Msg-id 20040126104855.GB31868@f-prot.com
Whole thread Raw
In response to Re: FAQ (disk space)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: FAQ (disk space)
List pgsql-general
On Sat, Jan 24, 2004 at 09:29:12PM -0500, Bruce Momjian wrote:
> Clarence Gardner wrote:
> > >> Could you please tell me if there's a limit in the amount of records that
> > >> the database can handle?
> >
> > >See the FAQ: http://www.postgresql.org/docs/faqs/FAQ.html#4.5
> >
> > Speaking of the FAQ, in the next question (#4.6), should
> > "NULLs are stored in bitmaps" say "NULL indicators are stored in bitmaps"?
>
> I changed it to:
>
>     NULLs are stored _as_ bitmaps

Eh... good morning folks.  I have been lurking on the postgreSQL lists
for a while.  Now when I read this, a question arise.

Does postgres calculate some sort of a "checksum" over a row?

I mean... storing whether a field is NULL or not inside a single bit,
seems slightly risky (especially when we consider how much of the
hardware out there, is of marginal quality).

Would it be worth it to calculate some sort of a checksum over a row, and
store that checksum along with the row?

Cheers,
--
Einar Indridason
einari@f-prot.com

pgsql-general by date:

Previous
From: "Fred Moyer"
Date:
Subject: Re: Object Relational features in PostgreSQL
Next
From: Martijn van Oosterhout
Date:
Subject: Re: FAQ (disk space)