Re: [PERFORM] session servers in ram

2009-09-22 Thread Scott Marlowe
On Tue, Sep 22, 2009 at 12:01 PM, Ron Mayer wrote: > Alan Hodgson wrote: >> On Monday 21 September 2009, Scott Marlowe wrote: >>> I'm looking at running session servers in ram. >> >> Use memcached for session data. > > IMHO postgres is more appropriate for some types of session data. > > One of t

Re: [PERFORM] session servers in ram

2009-09-22 Thread Ron Mayer
Alan Hodgson wrote: > On Monday 21 September 2009, Scott Marlowe wrote: >> I'm looking at running session servers in ram. > > Use memcached for session data. IMHO postgres is more appropriate for some types of session data. One of the apps I work on involves session data that consists of geospa

Re: [PERFORM] session servers in ram

2009-09-22 Thread Alan Hodgson
On Monday 21 September 2009, Scott Marlowe wrote: > I'm looking at running session servers in ram. > Does anybody any real world experience here or any words of sage > advice before I go off and start testing this? Use memcached for session data. -- "No animals were harmed in the recording of t

Re: [PERFORM] session servers in ram

2009-09-22 Thread Aidan Van Dyk
* Scott Marlowe [090921 19:39]: > I'm looking at running session servers in ram. All the data is > throw-away data, so my plan is to have a copy of the empty db on the > hard drive ready to go, and have a script that just copies it into ram > and starts the db there. We're currently IO write bou

Re: [PERFORM] session servers in ram

2009-09-22 Thread Pavel Stehule
Hello this is maybe off topic. Do you know memcached? We use it without postgresql six or seven months for short-live data with big success. regards Pavel Stehule 2009/9/22 Greg Spiegelberg : > On Mon, Sep 21, 2009 at 5:39 PM, Scott Marlowe > wrote: >> >> I'm looking at running session servers

Re: [PERFORM] session servers in ram

2009-09-22 Thread Greg Spiegelberg
On Mon, Sep 21, 2009 at 5:39 PM, Scott Marlowe wrote: > I'm looking at running session servers in ram. All the data is > throw-away data, so my plan is to have a copy of the empty db on the > hard drive ready to go, and have a script that just copies it into ram > and starts the db there. We're

[PERFORM] session servers in ram

2009-09-21 Thread Scott Marlowe
I'm looking at running session servers in ram. All the data is throw-away data, so my plan is to have a copy of the empty db on the hard drive ready to go, and have a script that just copies it into ram and starts the db there. We're currently IO write bound with fsync=off using a 15k5 seagate SA