Re: Sparse Data - Mailing list pgsql-novice

From Tom Lane
Subject Re: Sparse Data
Date
Msg-id 3772.1116954819@sss.pgh.pa.us
Whole thread Raw
In response to Sparse Data  ("Walker, Jed S" <Jed_Walker@cable.comcast.com>)
List pgsql-novice
"Walker, Jed S" <Jed_Walker@cable.comcast.com> writes:
> Does sparse data cause significant space wastage or performance issues
> in PostgreSQL?

What do you mean by "sparse data" exactly?  If you're thinking of a
table in which many fields are null, no, there's no penalty for that.

            regards, tom lane

pgsql-novice by date:

Previous
From: Miguel que te importa
Date:
Subject: Re: Trigger unhappy (Correction)
Next
From: Bruno Wolff III
Date:
Subject: Re: "NOT NULL"