Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group