Re: Replace usage of a table in query with its array values - Mailing list pgsql-jdbc

From Guy Rouillier
Subject Re: Replace usage of a table in query with its array values
Date
Msg-id 46891BE8.60209@burntmail.com
Whole thread Raw
In response to Replace usage of a table in query with its array values  ("Loredana Curugiu" <loredana.curugiu@gmail.com>)
Responses Re: Replace usage of a table in query with its array values  ("Loredana Curugiu" <loredana.curugiu@gmail.com>)
List 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 by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: Log files cluttered with jdbc3/4 for pg8.2
Next
From: "Loredana Curugiu"
Date:
Subject: Re: Replace usage of a table in query with its array values