[PERFORM] Please Help: PostgreSQL performance Optimization

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. CREATE TABLE cookies ( domain varchar

Re: [PERFORM] Please Help: PostgreSQL performance Optimization

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

Re: [PERFORM] Please Help: PostgreSQL performance Optimization

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

[PERFORM] The trigger can be specified to fire on time condition?

Hi All, I ' m using the postgresql datbase to stores cookies. Theses cookies become invalid after 30 mn and have to be deleted. i have defined a procedure that will delete all invalid cookies, but i don't know how to call it in loop way (for example each hour). I think that it possible becau

[PERFORM] Unsubscribe

---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster