[ic] Newb Postgres Session Setup

[Mike Heins]

Quoting Jason Lee (jason.lee at mac.com):
> Hello all,
> 
> During my past two weeks of using Interchange, I've been really  
> resisting sending a question to the list. However, I think I've run out  
> of options.
> 
> OS: RH 7.3 (latest updates)
> Db: Postgres 7.3
> I: 4.9.8-1 (via rpms)
> 
> I've followed the instructions via these two posts:
> 
> http://www.icdevgroup.org/pipermail/interchange-users/2001-April/007636.html
> 
> and have adapted it to Postgres vs. MySql. My db structure is as  
> follows:
> 
> - - - [31/July/2003:13:08:49 -0400] - - table user_sessions created:  
> create table user_sessions (
> > code varchar(64) NOT NULL PRIMARY KEY,
> > session text,

I don't believe Pg text types handle binary values well. To use it,
you will have to disable Storable for sessions. (That is usually 
just removing the _session_storable file in the Interchange root.)

It has been my experience that the write speed of Postgres is a
great deal slower than MySQL, so IMHO it is better to use MySQL For
that purpose.

(Note that is NOT a condemnation of Pg, so please everyone, don't try
and start something. 8-)

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike at perusion.com>

Software axiom: Lack of speed kills.