Re: [PERFORM] Please Help: PostgreSQL performance Optimization

2006-01-13 Thread Frank Wiles
On Thu, 12 Jan 2006 01:32:10 +0100 Jamal Ghaffour <[EMAIL PROTECTED]> wrote: > I'm using the default configuration file, and i m asking if i have to > change some paramters to have a good performance. In general the answer is yes. The default is a pretty good best guess at what sorts of valu

Re: [PERFORM] Please Help: PostgreSQL performance Optimization

2006-01-13 Thread Jamal Ghaffour
Andrew Lazarus a écrit : Jamal Ghaffour wrote: CREATE TABLE cookies ( domain varchar(50) NOT NULL, path varchar(50) NOT NULL, name varchar(50) NOT NULL, principalid varchar(50) NOT NULL, host text NOT NULL, value text NOT NULL, secure bool NOT NULL, timestamp timestamp

Re: [PERFORM] Please Help: PostgreSQL performance Optimization

2006-01-12 Thread Jaime Casanova
On 1/12/06, Jamal Ghaffour <[EMAIL PROTECTED]> wrote: > Jamal Ghaffour a écrit : > Hi, I'm working on a project, whose implementation deals with PostgreSQL. A > brief description of our application is given below. I'm running version > 8.0 on a dedicated server 1Gb of RAM. my database isn't compl

Re: [PERFORM] Please Help: PostgreSQL performance Optimization

2006-01-12 Thread Andrew Lazarus
Jamal Ghaffour wrote: CREATE TABLE cookies ( domain varchar(50) NOT NULL, path varchar(50) NOT NULL, name varchar(50) NOT NULL, principalid varchar(50) NOT NULL, host text NOT NULL, value text NOT NULL, secure bool NOT NULL, timestamp timestamp with time zone NOT NULL DEF

Re: [PERFORM] Please Help: PostgreSQL performance Optimization

2006-01-12 Thread Jamal Ghaffour
Jamal Ghaffour a écrit : Hi, I'm working on a project, whose implementation deals with PostgreSQL. A brief description of our application is given below. I'm running version 8.0 on a dedicated server 1Gb of RAM. my database isn't complex, it contains just 2 simple tables. CREA