From: | Scara Maccai <m_lists(at)yahoo(dot)it> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | I: arrays and block size |
Date: | 2009-02-02 17:48:37 |
Message-ID: | 890362.3397.qm@web24605.mail.ird.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Anyone?
----- Messaggio inoltrato -----
> Da: Scara Maccai <m_lists(at)yahoo(dot)it>
> A: pgsql-general <pgsql-general(at)postgresql(dot)org>
> Inviato: Venerdì 30 gennaio 2009, 13:59:09
> Oggetto: [GENERAL] arrays and block size
>
> 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 | wstrzalka | 2009-02-02 17:56:28 | Re: Pet Peeves? |
Previous Message | Bruce Momjian | 2009-02-02 17:47:49 | Re: Pet Peeves? |