Re: Fetching multiple rows in single round trip - Mailing list pgsql-general

From Jon Smark
Subject Re: Fetching multiple rows in single round trip
Date
Msg-id 1337375163.42256.YahooMailNeo@web112813.mail.gq1.yahoo.com
Whole thread Raw
In response to Re: Fetching multiple rows in single round trip  (David Johnston <polobo@yahoo.com>)
Responses Re: Fetching multiple rows in single round trip
List 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
filteringone. 


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

Cheers,
Jon


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: varchar for loops possible?
Next
From: Bosco Rama
Date:
Subject: Re: Why are pg_restore taking that long ?