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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greeting, Lutz!

Please don't top-post on the PG mailing lists, our style is to relpy
in-line.

* Lutz Fischer (l.fischer@xxxxxxxx) 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

Attachment: signature.asc
Description: Digital signature


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux