Hi,

I'm working with a retail site with tens of millions of products in several languages.

For the detail pages, we try to cache in memcached. We also have quite a bit of keyword translation lookups (for international queries to solr).

We're thinking of adding a nosql layer that takes the big beating with the mundane reads. I don't fancy manually adding code to every possible place in the php code that touches the related tables.

What fast trigger solution would you use for this? I'm thinking of something that would just push (via fdw?) data to a queue; table name and item id. Naturally it should not slow down pg noticable and have stellar uptime.

Is the whole concept a stupid idea?

Thanks,
Marcus



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to