Re: Fetching multiple rows in single round trip

From: Jon Smark <jon(dot)smark(at)yahoo(dot)com>
To: David Johnston <polobo(at)yahoo(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fetching multiple rows in single round trip
Date: 2012-05-18 21:06:03
Message-ID: 1337375163.42256.YahooMailNeo@web112813.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

> ...WHERE wid = ANY(string_to_array(?,';'))
>
> where the ? is a parameter that you replace with a semi-colon delimited listing of widget IDs
>
> Performance depends on specifics you have not provided, especially the expected number of widgets you are going to be filtering one.

Thanks for the reply.  The number of widgets is variable, but should not be higher than about 20 in the worst case, with 10 being
a more average number.  Which solution should I opt for in these circumstances?

Cheers,
Jon

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bosco Rama 2012-05-18 22:11:06 Re: Why are pg_restore taking that long ?
Previous Message Tom Lane 2012-05-18 20:40:07 Re: varchar for loops possible?