[PERFORM] Unsubscribe

2006-09-13 Thread Jamal Ghaffour
---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

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

2006-02-27 Thread Jamal Ghaffour
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

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 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

[PERFORM] Please Help: PostgreSQL performance Optimization

2006-01-11 Thread Jamal Ghaffour
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