On 09/26/11 6:59 AM, Jov wrote:
Hi all,
We are going to use pg as data warehouse,but after some test,we found
that plain text with csv format is 3 times bigger when load to pg.we
use copy to load data.we try some optimize and it reduce to 2.5 times
bigger.other db can avarage compress to 1/3 of the plain text.bigger
data means heavy io.
So my question is how to make data compressed in pg?is some fs such
as zfs,berfs with compression feature can work well with pg?
your source data is CSV, what data types are the fields in the table(s)
? do you have a lot of indexes on this table(s)?
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
