Re: Mounting a data dir read only

On 1/16/07, Thorsten Körner <t(dot)koerner(at)cappuccinosoft(dot)de> wrote:
>
> The projects Website is a very high traffic site, with about 500 Pi /
> sec. we
> are facing performance trouble, when using just one server.
> Searches etc. we have implemented using lucene on our backend servers, to
> keep
> the database alive, but since content is very dynamic, there is need to
> update lucene indexes very often.
> Another problem are some logs, like counters how often users have seen the
> pages with contents or userprofiles etc.
> All those things, seems to me very difficulty to implement with slony.
> Do you have a hint, which way we can go?
>

Perhaps you need to look at a different solution. It is apparent you want
to reduce I/O and activity on the database, have you looked at distributed
caches like memcached (http://www.danga.com/memcached/) ?

Many popular high volume websites are using memcached (Wikipedia, Slashdot,
Live Journal, etc.).

--
Chad
http://www.postgresqlforums.com/