session servers in ram

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема session servers in ram
Дата
Msg-id dcc563d10909211639r6270da47h220a5061ae8fe9b4@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: statement stats extra load?
Следующее
От: Vincent de Phily
Дата:
Сообщение: Re: slow query : very simple delete, 100% cpu, nearly no disk activity