On May 29, 2008, at 1:57 AM, Hannu Krosing wrote:
> On Wed, 2008-05-28 at 19:11 -0400, Mike wrote:
>> Can somebody point to the most logical place in the code to intercept
>> the WAL writes? (just a rough direction would be enough)- or if this
>> doesn’t make sense at all, another suggestion on where to get the
> I don't think that intercepting (and then decoding ) WAL is very
> productive. It is too low level to be of much help.
> The way I'd do it would be using pgQ from SkyTools package where
> events can be queued when happening and then moved in bulk to
> with not too much effort.
Actually, you might look one step further and see about adding
memcached as a subscriber type to londiste; it might be easier than
just using PgQ... not that using PgQ would be all that hard.
Also, keep in mind that no matter what you do you'll always have a
race condition between data in the database and in memcached.
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
In response to
pgsql-hackers by date
|Next:||From: Decibel!||Date: 2008-06-04 12:36:41|
|Subject: Re: DISTINCT -> GROUP BY|
|Previous:||From: Heikki Linnakangas||Date: 2008-06-04 12:22:58|
|Subject: Re: cannot use result of (insert..returning)|