[GENERAL] Using postgresql in a HA/load balancing environment?

2006-03-21 Thread Rasmus Resen Amossen
Consider a service based on several terabytes of data, suffering from a very high load. Can postgresql be used as database backend in a cluster system in which both of the following is achieved? a) Load balancing among a (large) number of cluster nodes b) High availability (if any node in the

[GENERAL] subselects in check clauses

2001-06-04 Thread Rasmus Resen Amossen
01','2001-12-12'); ERROR: ExecEvalExpr: unknown expression type 108 What can I do? -- Rasmus Resen Amossen | stud.mat.dat at the University of Copenhagen Jagtvej 120, -244| http://www.math.ku.dk/muh 2200 Kbh. N | http://w1.1444.telia.com/~u14441

[GENERAL] Updating views

2001-06-04 Thread Rasmus Resen Amossen
e appropriate rule? -- Rasmus Resen Amossen | stud.mat.dat at the University of Copenhagen Jagtvej 120, -244| http://www.math.ku.dk/muh 2200 Kbh. N | http://w1.1444.telia.com/~u14441 ---(end of broadcast)--- TIP 5: Have you checked our ex

[GENERAL] Re: Updating views

2001-06-04 Thread Rasmus Resen Amossen
owing updates: update exview set b=10, c=0 where d=11; update exview set b=0 where c > d; update exview set d=123 where b=c and c=d; In other words: I want to make the update of 'exview' transparent to 'extable'. -- Rasmus Resen Amossen | stud.mat.dat at the Univers