Re: Big array speed issues

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Merkel Marcel (CR/AEM4)" <Marcel(dot)Merkel(at)de(dot)bosch(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Big array speed issues
Date: 2006-06-21 02:56:32
Message-ID: b42b73150606201956k7b366d1j5a420a423891be4e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 6/20/06, Merkel Marcel (CR/AEM4) <Marcel(dot)Merkel(at)de(dot)bosch(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Eric Lauzon 2006-06-21 04:27:23 ACL cleanup
Previous Message Meetesh Karia 2006-06-20 17:25:19 Re: Query hanging/not finishing inconsistently