Re: Replace usage of a table in query with its array values

Поиск
Список
Период
Сортировка
От Guy Rouillier
Тема Re: Replace usage of a table in query with its array values
Дата
Msg-id 46891BE8.60209@burntmail.com
обсуждение исходный текст
Ответ на Replace usage of a table in query with its array values  ("Loredana Curugiu" <loredana.curugiu@gmail.com>)
Ответы Re: Replace usage of a table in query with its array values  ("Loredana Curugiu" <loredana.curugiu@gmail.com>)
Список pgsql-jdbc
Loredana Curugiu wrote:
> After database redesign it was decided that reminder_services table
> to be moved into another database. In production, reminder_services
> table will never have more than 100 of records, but sent_messages
> table it is a log table with a lot of records and the above query
> will be executed every minute.

Cross posting to multiple lists is frowned upon, so I'm reply only here.
  Have you considered using the dblink contrib module?  That seems a far
simpler solution than trying to do this with arrays.

--
Guy Rouillier

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Mario Splivalo
Дата:
Сообщение: Re: Log files cluttered with jdbc3/4 for pg8.2
Следующее
От: "Loredana Curugiu"
Дата:
Сообщение: Re: Replace usage of a table in query with its array values