Re: [GENERAL] foreign keys and memory consumption

2007-10-09 Thread Simon Riggs
On Tue, 2007-10-09 at 11:28 +0200, Jan Poslusny wrote: > pg 8.2.4 on Fedora Core 6 x86-64, mostly default postgres.conf just > shared memory buffers increased to 256M. 1GB RAM. > I attempt to insert ~200k rows into table in one transaction from psql > console, calling stored function of plperlu

[GENERAL] foreign keys and memory consumption

2007-10-09 Thread Jan Poslusny
Hi all, pg 8.2.4 on Fedora Core 6 x86-64, mostly default postgres.conf just shared memory buffers increased to 256M. 1GB RAM. I attempt to insert ~200k rows into table in one transaction from psql console, calling stored function of plperlu language, which inserts row by row via spi_exec_prepar