Greeting, Lutz!
Please don't top-post on the PG mailing lists, our style is to relpy
in-line.
* Lutz Fischer (l(dot)fischer(at)ed(dot)ac(dot)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 would be better to store the array data in a
> separate table e.g. have [s] as it is now but turn [sp] into an
> array aggregated table.
If that's the case then you would probably be better off putting the
arrays into an independent table, yes.
Thanks!
Stephen