Daniel Schuchardt <[EMAIL PROTECTED]> writes: > is it is known that postgres 8.0 (beta1 and beta2 both same behavoir) > will eat tons of memory on Windows under heavy load?
No. I tried setting up a test case with a 64K-row master table, a slave table with the same 64K rows and an ON DELETE CASCADE reference to the master, and a third table with the same 64K values and an ON DELETE CASCADE reference to the second. It took a little bit of time to delete all the master rows, but memory usage was perfectly steady. Can you provide a concrete test case? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend