From: | "Andres Olarte" <olarte(dot)andres(at)gmail(dot)com> |
---|---|
To: | mikael-aronsson <mikael-aronsson(at)telia(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: LISTEN question |
Date: | 2007-03-07 14:36:32 |
Message-ID: | 3fccaa690703070636h1b77ff78p3f6cf5a7e0bfee26@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Very little impact. My client uses about 30-60 LISTENS and it works
great. And most of my clients are Pentium 3 computers!
On 3/7/07, mikael-aronsson <mikael-aronsson(at)telia(dot)com> wrote:
> Hi !
>
> Does any one have any idea on the impact of using a large number of
> different LISTEN,
> say that I add 20 "LISTEN something;" statements will this slow down the
> client much ?
>
> The thing is that I have 20 different tables and I would like to be notified
> when something
> change in any of the tables, there are timestamps so I can use SELECT * FROM
> xxx
> WHERE timestamp>zzz to get the changed data but going to put out 20 SELECT
> queries all the time does not sound very smart so I thought I would use
> LISTEN/NOTIFY instead to improve performance.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
From | Date | Subject | |
---|---|---|---|
Next Message | Giuseppe Sacco | 2007-03-07 15:08:39 | Re: Transaction atomicity |
Previous Message | Dave Cramer | 2007-03-07 12:15:07 | Re: Transaction atomicity |