I think there's something not-so-good with your system... and it looks like
it is the memory...
What kind of system do you have? (processor, diskspace, memory etc...)
How much of the memory is taken before you begin your transaction, and how
much during the transaction...
"Greg Spiegelberg" <gs2@twotone.org> schreef in bericht
news:32919e3a.0211010633.7e6bc68c@posting.google.com...
> Hello,
>
> I have a Redhat 7.3 system with PostgreSQL 7.2.3 and when I run some
> jobs I have to add data to the databases running the system slows,
> the file system where PGDATA resides fills up and all of memory and
> disk swap gets used up... then panic.
>
> There is nothing in any of the log files, we're using syslog at the
> moment which logs to a file on a different file system, and I don't
> know quite where to start to begin debugging to see where the problem
> is.
>
> Any helpful tips & tricks would be wonderful.
>
> TIA,
> Greg