Re: using postgresql for session

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: using postgresql for session
Дата
Msg-id 56203E29.7010705@BlueTreble.com
обсуждение исходный текст
Ответ на Re: using postgresql for session  (Tiger Nassau <john.tigernassau@gmail.com>)
Список pgsql-general
On 10/14/15 8:57 PM, Tiger Nassau wrote:
> maybe we will just use beaker with our bottle framework - thought it was
> duplicative to have redis since we have postgres and lookup speed should
> be  trivial since session only has a couple of small fields like account
> id and role

The problem with sessions in Postgres tends to be the update rate, since
every update results in a new table tuple, and possible new index
tuples. That gets painful really fast for high-update workloads.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: pgpool ssl handshake failure
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: ID column naming convention