From: Loredana Curugiu <loredana.curugiu@gmail.com>
To: 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, 2 Jul 2007 19:49:54 +0300
Message-ID: <1c23c8e70707020949l3f6112dfra9e89467080b136e@mail.gmail.com> (raw)
In-Reply-To: <46891BE8.60209@burntmail.com>
References: <1c23c8e70707020123o5a8b6512i2d2ad8888cb921cc@mail.gmail.com>
<46891BE8.60209@burntmail.com>
On 7/2/07, Guy Rouillier <guyr-ml1@burntmail.com> wrote:
>
> 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.
Thank you for informations.
Best,
Loredana
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: loredana.curugiu@gmail.com, guyr-ml1@burntmail.com, pgsql-jdbc@postgresql.org
Subject: Re: Replace usage of a table in query with its array values
In-Reply-To: <1c23c8e70707020949l3f6112dfra9e89467080b136e@mail.gmail.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