arrays and block size

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

Browse pgsql-general by date

  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