[ic] Newb Postgres Session Setup

Mike Heins mike at perusion.com
Thu Jul 31 15:37:51 EDT 2003

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.

More information about the interchange-users mailing list