| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Thomas Holmgren" <thm(at)regnecentralen(dot)dk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Data in table changed? |
| Date: | 2004-03-02 15:23:23 |
| Message-ID: | 27632.1078241003@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Thomas Holmgren" <thm(at)regnecentralen(dot)dk> writes:
> I have a large number of clients synchronizing with a central database.
> The clients update their local data by polling the database for changes
> at fixed intervals. I need an efficient way of determining if data in a
> table has been changed (either updated, deleted or inserted). Can this
> be achieved without scanning the tables using expensive SQL?
Are the clients continuously connected to the database? If so you could
forget the whole polling concept and make it data-driven (the clients
listen for NOTIFY events sent out by updaters).
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2004-03-02 15:36:01 | Re: Setting up Postgresql on Linux |
| Previous Message | Tom Lane | 2004-03-02 15:10:10 | Re: Installing Postgresql in Irix |