On 02/04/2014 01:52 PM, AlexK wrote:
> Every row of my table has a double[] array of approximately 30K numbers. I
> have ran a few tests, and so far everything looks good.
>
> I am not pushing the limits here, right? It should be perfectly fine to
> store arrays of 30k double numbers, correct?
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Is-it-reasonable-to-store-double-arrays-of-30K-elements-tp5790562.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
What sorts of tests and what sorts of results?
Each record has something like 30000*16 + 30000*(per cell overhead,
which could be zero) but that is definitely spilling over to toast.
Have you done any large scale deletes?