Re: Sparse Data

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

Yes, that is what I'm referring to. Thanks!

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, May 24, 2005 11:14 AM
To: Walker, Jed S
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Sparse Data

"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

Browse pgsql-novice by date

  From Date Subject
Next Message Jeff Eckermann 2005-05-24 19:28:26 Re: Trigger unhappy (Correction)
Previous Message Tom Lane 2005-05-24 18:26:21 Re: UPDATE with JOIN