Re: Fetching multiple rows in single round trip

Поиск
Список
Период
Сортировка
От Jon Smark
Тема Re: Fetching multiple rows in single round trip
Дата
Msg-id 1337375163.42256.YahooMailNeo@web112813.mail.gq1.yahoo.com
обсуждение исходный текст
Ответ на Re: Fetching multiple rows in single round trip  (David Johnston <polobo@yahoo.com>)
Ответы Re: Fetching multiple rows in single round trip  (David Johnston <polobo@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: varchar for loops possible?
Следующее
От: Bosco Rama
Дата:
Сообщение: Re: Why are pg_restore taking that long ?