From: | Scara Maccai <m_lists(at)yahoo(dot)it> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | arrays and block size |
Date: | 2009-01-30 12:59:09 |
Message-ID: | 229734.17982.qm@web24610.mail.ird.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I need to store a lot of int8 columns (2000-2500) in a table.
I was thinking about using int8[], and I would like to know:
1) is there a max size for arrays? I guess I could have 1 GB "worth" of values, but I would like a confirmation
2) there won't be any updates, only inserts and selects; since I will be using ZFS would there be any benefit in changing the block size (for example to 32K) in postgresql? Would it be better to use ZFS compression instead of postgresql's (TOAST)? That is: should I EXTERNAL for that array column and set compression=on for ZFS? I tried ZFS compression=on a 200 columns table and it worked faster than with compression=off...
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Markus | 2009-01-30 13:01:01 | Re: PGSQL and Javascript |
Previous Message | Miha D. Puc | 2009-01-30 12:52:11 | Re: [INTERFACES] PGSQL and Javascript |