pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Plotkin <richard@richardplotkin.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Disk filling, CPU filling, renegade inserts and deletes?
Date: Sat, 23 Apr 2005 15:50:56 -0400
Message-ID: <14610.1114285856@sss.pgh.pa.us> (raw)
In-Reply-To: <31935aa56e9539c5648cb09e78152c03@richardplotkin.com>
References: <6f4567d4e64297b356e2d71ec392cdae@richardplotkin.com>
	<4574.1114030270@sss.pgh.pa.us>
	<9c5b2bf6a0f5a0bc0abeb6b6c5cf7973@richardplotkin.com>
	<2a9467bc6e6dab5d997427c4ef6158e3@richardplotkin.com>
	<12016.1114279585@sss.pgh.pa.us>
	<c4a45adf8fdcb550f487a1ca7f9cfff5@richardplotkin.com>
	<12135.1114280225@sss.pgh.pa.us>
	<31935aa56e9539c5648cb09e78152c03@richardplotkin.com>

Richard Plotkin <richard@richardplotkin.com> writes:
> Thanks for your responses this morning.  I did the select relname, and 
> it returned 0 rows.  I do have one function that creates a temp table 
> and fills it within the same transaction.  I'm pasting it below.  
> Perhaps the "ON COMMIT DROP" is causing problems, and I need to drop 
> the table at the end of the function instead of using ON COMMIT DROP?

Well, I think we can conclude that the function is pushing way more
data into the temp table than you expect.  I am wondering if that loop
in the middle of the function is turning into an infinite loop --- could
it be finding some sort of cycle in your page data?  You might want to
add some RAISE NOTICE commands to the loop so you can track what it's
doing.

			regards, tom lane



view thread (18+ messages)  latest in thread

Message-ID: <14610.1114285856@sss.pgh.pa.us>
Permalink:  ../14610.1114285856@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/14610.1114285856@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, richard@richardplotkin.com
  Subject: Re: Disk filling, CPU filling, renegade inserts and deletes?
  In-Reply-To: <14610.1114285856@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox