2010/11/16 Louis-David Mitterrand <vindex+lists-pgsql-performance@xxxxxxxxxxx>: > On Tue, Nov 16, 2010 at 12:03:29PM +0100, Pavel Stehule wrote: >> Hello >> >> my opinion: >> >> @1 can be faster for access to last items with index >> @2 can be more effective about data files length allocation > > Hi Pavel, > > What is "data files length allocation" ? size of data files on disc :) pg needs a some bytes for head on every row - so if you use a array, then you share its. Next varlena types (like array) can be compressed. Pavel > > -- > Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
