Re: vacuum, performance, and MVCC - Mailing list pgsql-hackers

From Rick Gigger
Subject Re: vacuum, performance, and MVCC
Date
Msg-id E7EC710D-4D7E-4E6B-9164-004D0E7B1006@alpinenetworking.com
Whole thread Raw
In response to Re: vacuum, performance, and MVCC  ("Mark Woodward" <pgsql@mohawksoft.com>)
List pgsql-hackers
On Jun 22, 2006, at 2:36 PM, Mark Woodward wrote:

>>
>>> What you seem not to grasp at this point is a large web-farm,  
>>> about 10
>>> or
>>> more servers running PHP, Java, ASP, or even perl. The database is
>>> usually
>>> the most convenient and, aside from the particular issue we are  
>>> talking
>>> about, best suited.
>>
>>     The answer is sticky sessions : each user is assigned to one and  
>> only one
>> webserver in the cluster and his session is maintained locally, in  
>> RAM. No
>> locks, no need to manage distributed session...
>>
>>> I actually have a good number of years of experience in this  
>>> topic, and
>>> memcached or file system files are NOT the best solutions for a  
>>> server
>>> farm.
>>
>>     If sessions are distributed, certainly, but if sessions are  
>> sticky to
>> their own server ?
>
> And what if a particulr server goes down? or gets too high a  
> percentage of
> the load?

Yes, I don't think that sticky sessions are the answer.  But phps  
session handling behavior could be greatly improved on.


pgsql-hackers by date:

Previous
From: Rick Gigger
Date:
Subject: Re: vacuum, performance, and MVCC
Next
From: mark@mark.mielke.cc
Date:
Subject: Re: vacuum, performance, and MVCC