Re: [PERFORM] Using array instead of sub table (storage and speed)

2017-06-16 Thread Stephen Frost
Greeting, Lutz! Please don't top-post on the PG mailing lists, our style is to relpy in-line. * Lutz Fischer (l.fisc...@ed.ac.uk) wrote: > I often need some data from [s] where I don't care about [sp]. So in > how far does having these arrays a part of [s] would make these > queries slower. Or wo

Re: [PERFORM] Using array instead of sub table (storage and speed)

2017-06-16 Thread Lutz Fischer
Hi Stephen, Thanks for your reply. The data in the sub table (sp) are only read in as a block. Meaning I will always read in all entries in [sp] that belong to one entry in [s]. Meaning I would not lose much in terms of what I could do with the data in [sp] and I could be saving around 2.8K