After further investigations, it seems the second hypothesis is correct.
This particular DB was created with "with OIDs" as default.
The script I was using had no SET for this option and it creates a few
temporary tables (which are quite small in size as they are created by
SELECT .. INTO TEMP TABLE .. FROM .. GROUP BY .., so they are smaller than
their origins).
Adding SET default_with_oids = true to the script seems to solve the
problem.
Also, when run with the former releases, AUTOVACUUMING was off. Now it is
on.
Regards
J6M
----- Original Message -----
From: "J6M" <[EMAIL PROTECTED]>
To: "Stefan Kaltenbrunner" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>; <pgsql-bugs@postgresql.org>
Sent: Tuesday, April 08, 2008 12:37 PM
Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space
The df was made while the error messages occured and the scripts were
running. So it is not a temporary 'mammothean' table.
When I thought of this, two possible elads came to my mind :
- A mistake when I tuned the postgresql.conf file (resource is scarce, as
this test machine is a PIII 700 with 256 MB RAM dating from Q4 2000)
- The default for this particular DB has been set to keep OIDs (I "pour"
several INSERTs sets arising from different files in an auxiliary table,
and keep the last entered entry for any relevant keys, Those entries then
go to a production table).
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
