session servers in ram - Mailing list pgsql-performance

From Scott Marlowe
Subject session servers in ram
Date
Msg-id dcc563d10909211639r6270da47h220a5061ae8fe9b4@mail.gmail.com
Whole thread Raw
Responses Re: session servers in ram  (Greg Spiegelberg <gspiegelberg@gmail.com>)
Re: session servers in ram  (Aidan Van Dyk <aidan@highrise.ca>)
Re: session servers in ram  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-performance
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 SAS drive, so I'm hoping that moving
the db into /dev/shm will help quite a bit here.

Does anybody any real world experience here or any words of sage
advice before I go off and start testing this?

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: statement stats extra load?
Next
From: Vincent de Phily
Date:
Subject: Re: slow query : very simple delete, 100% cpu, nearly no disk activity