Re: I: [GENERAL] arrays and block size

On Mon, Feb 02, 2009 at 09:48:37AM -0800, Scara Maccai wrote: I need to store a lot of int8 columns (2000-2500) in a table. I was thinking about using int8[] An array of ints sounds like the way to go here as you wouldn't be able to have that many columns. TOAST is one non-obvious

I: [GENERAL] arrays and block size

Anyone? - Messaggio inoltrato - Da: Scara Maccai m_li...@yahoo.it A: pgsql-general pgsql-general@postgresql.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

[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;