Re: Is it reasonable to store double[] arrays of 30K elements
| От | Rob Sargent |
|---|---|
| Тема | Re: Is it reasonable to store double[] arrays of 30K elements |
| Дата | |
| Msg-id | 52F154B4.2090606@gmail.com обсуждение исходный текст |
| Ответ на | Is it reasonable to store double[] arrays of 30K elements (AlexK <alkuzo@gmail.com>) |
| Ответы |
Re: Is it reasonable to store double[] arrays of 30K elements
Re: Is it reasonable to store double[] arrays of 30K elements |
| Список | pgsql-general |
On 02/04/2014 01:52 PM, AlexK wrote:
What sorts of tests and what sorts of results?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.
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?
В списке pgsql-general по дате отправления: