Skip site navigation (1) Skip section navigation (2)

I: arrays and block size

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 (view raw or flat)
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....


      


Responses

pgsql-general by date

Next:From: wstrzalkaDate: 2009-02-02 17:56:28
Subject: Re: Pet Peeves?
Previous:From: Bruce MomjianDate: 2009-02-02 17:47:49
Subject: Re: Pet Peeves?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group