From: Guy Rouillier <guyr-ml1@burntmail.com>
To: pgsql-jdbc@postgresql.org
Subject: Re: Replace usage of a table in query with its array values
Date: Mon, 02 Jul 2007 11:38:16 -0400
Message-ID: <46891BE8.60209@burntmail.com> (raw)
In-Reply-To: <1c23c8e70707020123o5a8b6512i2d2ad8888cb921cc@mail.gmail.com>
References: <1c23c8e70707020123o5a8b6512i2d2ad8888cb921cc@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: guyr-ml1@burntmail.com, pgsql-jdbc@postgresql.org
Subject: Re: Replace usage of a table in query with its array values
In-Reply-To: <46891BE8.60209@burntmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox