Hi Tom,
> > I'm looking for a hint how array access performs in PostgreSQL in
> > respect to performance. Normally I would expect access of a
> > 1-dimensional Array at slot i (array[i]) to perform in constant time
> > (random access).
>
> > Is this also true for postgres' arrays?
>
> Only if th
Andreas Brandl writes:
> I'm looking for a hint how array access performs in PostgreSQL in respect to
> performance. Normally I would expect access of a 1-dimensional Array at slot
> i (array[i]) to perform in constant time (random access).
> Is this also true for postgres' arrays?
Only if the
> Is this also true for postgres' arrays?
Sorry, I'm using latest postgres 9.0.4 on debian squeeze/amd64.
Greetings
Andreas
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Hi,
I'm looking for a hint how array access performs in PostgreSQL in respect to
performance. Normally I would expect access of a 1-dimensional Array at slot i
(array[i]) to perform in constant time (random access).
Is this also true for postgres' arrays?
May concrete example is a 1-dimensiona
