Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group