Received: from smtp-1.attica.net.nz (pop3-1.attica.net.nz [202.180.66.199]) by postgresql.org (8.11.3/8.11.4) with SMTP id g1J8blE64666 for ; Tue, 19 Feb 2002 03:37:48 -0500 (EST) (envelope-from markir@slingshot.co.nz) Received: (qmail 41793 invoked from network); 19 Feb 2002 08:37:45 -0000 Received: from 202-180-68-131.nas1.wlg.attica.net.nz (202.180.68.131) by pop3-1.attica.net.nz with SMTP; 19 Feb 2002 08:37:45 -0000 Subject: Transient Disk Usage Higher In 7.2 ? From: Mark kirkwood To: pgsql-sql Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/0.13 (Preview Release) Date: 19 Feb 2002 21:37:45 +1300 Message-Id: <1014107866.1916.41.camel@spikey.slithery.org> Mime-Version: 1.0 X-Archive-Number: 200202/225 X-Sequence-Number: 6649 Dear list, I have a customer who is testing 7.2 before upgrading (from 7.1.3) They are getting errors like : cannot extend tablename - No space left on device check free disk space or write to hashjoin temp file failed However when they attempt the same query with a 7.1.3 installation (On the same machine), they do not get these. (I dont know how different the query plans are between the 7.1 and 7.2 tests... see below) I am informed that there is "quite a bit" of free disk on the machine.(no numbers I am afraid... I am going in to have a look on Thursday). Is there an "expectation" that 7.2 will use temp space more aggressively than 7.1 ? (They are using a vanilla Mandrake Linux - either 8.0 or 8.1...) regards and apologies about the lack of specifics :-(.... Mark