From: | "Loredana Curugiu" <loredana(dot)curugiu(at)gmail(dot)com> |
---|---|
To: | "Guy Rouillier" <guyr-ml1(at)burntmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Replace usage of a table in query with its array values |
Date: | 2007-07-02 16:49:54 |
Message-ID: | 1c23c8e70707020949l3f6112dfra9e89467080b136e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc pgsql-novice pgsql-sql |
On 7/2/07, Guy Rouillier <guyr-ml1(at)burntmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | thomas.risberg | 2007-07-02 17:29:55 | Re: getProcedureColumns |
Previous Message | Guy Rouillier | 2007-07-02 15:38:16 | Re: Replace usage of a table in query with its array values |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Maclean | 2007-07-03 03:58:02 | Re: [NOVICE] Recursive relationship - preventing cross-index entries. |
Previous Message | Guy Rouillier | 2007-07-02 15:38:16 | Re: Replace usage of a table in query with its array values |
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Lambert | 2007-07-02 22:45:20 | Using escape strings in an insert statement. |
Previous Message | Guy Rouillier | 2007-07-02 15:38:16 | Re: Replace usage of a table in query with its array values |