Daniel Schuchardt <daniel_schuchardt(at)web(dot)de> 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