Re: Big array speed issues - Mailing list pgsql-performance

From Merkel Marcel (CR/AEM4)
Subject Re: Big array speed issues
Date
Msg-id EA04C6394A303A4CADF281DE22F232A41D4359@si-mail48.de.bosch.com
Whole thread Raw
In response to Re: Big array speed issues  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: Big array speed issues
Re: Big array speed issues
List pgsql-performance

Von: Merlin Moncure [mailto:mmoncure@gmail.com]
An: Merkel Marcel (CR/AEM4)
Cc: pgsql-performance@postgresql.org
Betreff: Re: [PERFORM] Big array speed issues

On 6/20/06, Merkel Marcel (CR/AEM4) <Marcel.Merkel@de.bosch.com> wrote:

> I use libpqxx to access the database. This might be another
bottleneck, but
> I assume my query and table setup is the bigger bottleneck. Would it
make
> sense to fetch the whole array ? (Select map from table where ...  and
parse
> the array manually)

have you tried similar approach without using arrays?

Merlin


Not yet. I would first like to know what is the time consuming part and
what is a work around. If you are sure individual columns for every
entry of the array solve the issue I will joyfully implement it. The
downsize of this approch is that the array dimensions are not always the
same in my scenario. But I have a workaround in mind for this issue.

Cheers

Marcel




pgsql-performance by date:

Previous
From: Markus Schaber
Date:
Subject: Re: scaling up postgres
Next
From: Markus Schaber
Date:
Subject: Re: scaling up postgres