Re: [ADMIN] [SQL] View consistency

2001-11-01 Thread Stephan Szabo
On Thu, 1 Nov 2001, David M. Richter wrote: > Hello! > > Im using several views for the Usermanagment of a database. > My question is: > > How does postgres keep the views consistent to the according tables( if > the original table has been changed)? AFAIK it's a select rule on the view that rew

[ADMIN] CH mirror ?!?!?

2001-11-01 Thread Philippe Rochat
I'm the administrator of lbdpc15.epfl.ch and mirroring postgresql for switzerland since now 4 years. Why has been ch.postgresql.org and ftp.ch.postgresql.org been removed from your DNS and www.ch.postgresql.org been redirected to a commercial enterprise ??? I'm also no more able to rsync from lb

Re: [ADMIN] CH mirror ?!?!?

2001-11-01 Thread Tom Lane
"Philippe Rochat" <[EMAIL PROTECTED]> writes: > I'm the administrator of lbdpc15.epfl.ch and mirroring postgresql for > switzerland since now 4 years. You're complaining to the wrong people; Marc Fournier <[EMAIL PROTECTED]> is in charge of the mirroring network. But AFAIK, any mirrors that are

[ADMIN] View consistency

2001-11-01 Thread David M. Richter
Hello! Im using several views for the Usermanagment of a database. My question is: How does postgres keep the views consistent to the according tables( if the original table has been changed)? Is there a Rule? and how is the Rule invoked. With ON DELETE UPDATE INSERT of the original table? I d

[ADMIN] details

2001-11-01 Thread maha lakshmi
I'm not sure whether you have done this but try 'vacuum analyze' and also dropping and recreating index. good luck - Original Message - From: "Wiecha, Martin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 31, 2001 4:57 PM Subject: [ADMIN] performnce problem > Hi

Re: [ADMIN] serious performance problem

2001-11-01 Thread Stefan Huber
On 0, mwi <[EMAIL PROTECTED]> wrote: > PostgreSQL is installed on a RedHat 7.1 with Kernel 2.4.2-2. The > hardware is a PIII-500 with 256MB RAM and 10GB HD (IDE). Does running =# VACUUM ANALYZE help? Stefan -- Q: Could you please describe a bovril sandwich? Douglas Adams: Not on a family show

[ADMIN] serious performance problem

2001-11-01 Thread mwi
Hi everybody, I'm having a serious performance problem. We're using PostgreSQL (7.1.3) for data collection (appr. 3 000 000 new records per day). Every night all records older than 3 days are deleted, after that a vacuumdb is done. The table has about 7-8 M records and is about 2,5GB size on the