Re: Very large tables

From: Scara Maccai <m_lists(at)yahoo(dot)it>
To: William Temperley <willtemperley(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Very large tables
Date: 2008-11-28 16:53:12
Message-ID: 493021F8.4000308@yahoo.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Really I'm worried about reducing storage space and network overhead
> - therefore a nicely compressed chunk of binary would be perfect for
> the 500 values - wouldn't it?
>

For storage space you might want to look at ZFS with compression on in
case you are using FreeBSD or Solaris.
That would speed up query time as well since you would be
writing/reading less I guess...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-11-28 16:57:36 Re: Very large tables
Previous Message Vishal Arora 2008-11-28 16:46:03 Re: PgAgent Job Scehduler is NOT running