Re: using postgresql for session - Mailing list pgsql-general

From Jim Nasby
Subject Re: using postgresql for session
Date
Msg-id 56203E29.7010705@BlueTreble.com
Whole thread Raw
In response to Re: using postgresql for session  (Tiger Nassau <john.tigernassau@gmail.com>)
List 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 by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: pgpool ssl handshake failure
Next
From: Jim Nasby
Date:
Subject: Re: ID column naming convention