Re: PostgreSQL Arrays and Performance - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL Arrays and Performance
Date
Msg-id 18853.1136313644@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL Arrays and Performance  (Marc Philipp <mail@marcphilipp.de>)
Responses Re: PostgreSQL Arrays and Performance  (Marc Philipp <mail@marcphilipp.de>)
List pgsql-general
Marc Philipp <mail@marcphilipp.de> writes:
> A few performance issues using PostgreSQL's arrays led us to the
> question how postgres actually stores variable length arrays. First,
> let me explain our situation.

> We have a rather large table containing a simple integer primary key
> and a couple more columns of fixed size. However, there is a dates
> column of type "timestamp without time zone[]" that is apparently
> causing some severe performance problems.

How large are the arrays?  PG is definitely not designed to do well with
very large arrays (say more than a couple hundred elements).  You should
reconsider your data design if you find yourself trying to do that.

            regards, tom lane

pgsql-general by date:

Previous
From: Albert Vernon Smith
Date:
Subject: Re: insert serial numbers
Next
From: Klein Balázs
Date:
Subject: Re: generic way to retrieve array as rowset