Re: Very large tables - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Very large tables
Date
Msg-id 20081128165736.GE8993@alvh.no-ip.org
Whole thread Raw
In response to Re: Very large tables  ("William Temperley" <willtemperley@gmail.com>)
List pgsql-general
William Temperley escribió:

> 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?

An array that large would likely be compressed by Postgres internally
for storage; see
http://www.postgresql.org/docs/8.3/static/storage-toast.html

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Scara Maccai
Date:
Subject: Re: Very large tables
Next
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: Very large tables