Re: Very large tables - Mailing list pgsql-general

From Scara Maccai
Subject Re: Very large tables
Date
Msg-id 493021F8.4000308@yahoo.it
Whole thread Raw
In response to Re: Very large tables  ("William Temperley" <willtemperley@gmail.com>)
List 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...




pgsql-general by date:

Previous
From: Vishal Arora
Date:
Subject: Re: [ADMIN] PgAgent Job Scehduler is NOT running
Next
From: Alvaro Herrera
Date:
Subject: Re: Very large tables