Re: Sparse Data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Sparse Data
Date: 2005-05-24 17:13:39
Message-ID: 3772.1116954819@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)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

In response to

  • Sparse Data at 2005-05-24 15:57:58 from Walker, Jed S

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-05-24 17:20:20 Re: "NOT NULL"
Previous Message Miguel que te importa 2005-05-24 16:08:25 Re: Trigger unhappy (Correction)