Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-10 Thread J6M
ot;J6M" <[EMAIL PROTECTED]> To: "Stefan Kaltenbrunner" <[EMAIL PROTECTED]> Cc: "Tom Lane" <[EMAIL PROTECTED]>; 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 e

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-08 Thread J6M
a production table). - Original Message - From: "Stefan Kaltenbrunner" <[EMAIL PROTECTED]> To: "J6M" <[EMAIL PROTECTED]> Cc: "Tom Lane" <[EMAIL PROTECTED]>; Sent: Monday, April 07, 2008 8:31 PM Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about re

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread Stefan Kaltenbrunner
J6M wrote: OK. So why did this not occur when I was running 8.2.6 ? I would advise to install some very detailed monitoring on your diskspace usage and look for spikes that correlate with your database errors -. I have seen this issue with bad queries that are resulting in enormous on-disk

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread J6M
20eae09295 LABEL: Set flags in SB: ATTRIBUTES CLEAN - Original Message - From: "J6M" <[EMAIL PROTECTED]> To: "Gregory Stark" <[EMAIL PROTECTED]> Cc: "Tom Lane" <[EMAIL PROTECTED]>; Sent: Monday, April 07, 2008 5:50 PM Subject: Re: [BUGS

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread J6M
Linux estp-intranet 2.6.22.5-31-default #1 SMP 2007/09/21 22:29:00 UTC i686 i686 i386 GNU/Linux How can I precisely answer to the reiserfs version question ? (Although I presume the 2005 fix mentioned in the link you provided has been applied, as OpenSuSE 10.3 was published on the 4th of Octob

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread Gregory Stark
Sorry, this is the URL I meant to send: http://www.mail-archive.com/[EMAIL PROTECTED]/msg19905.html -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread Gregory Stark
What version of linux and reiserfs? see also: http://osdir.com/ml/file-systems.reiserfs.general/2004-01/msg00116.html -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-bugs mailing list (pgsql-bugs@p

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread J6M
PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Sent: Monday, April 07, 2008 4:09 PM Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space "" <[EMAIL PROTECTED]> writes: A lot of messages like these do appear wich tend to indicate PG 8.3.1 is confused. Th

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread Tom Lane
"" <[EMAIL PROTECTED]> writes: > A lot of messages like these do appear wich tend to indicate PG 8.3.1 is > confused. This set of SQL scripts used to run from PG 7.0.3 to PG 8.2.6 with > no problem. > WARNING: could not create relation-cache initialization file > "base/19693/pg_internal.init.293

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread J6M
- Original Message - From: "Gregory Stark" <[EMAIL PROTECTED]> To: "Zdenek Kotala" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; Sent: Monday, April 07, 2008 1:14 PM Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread J6M
- Original Message - From: "Zdenek Kotala" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Sent: Monday, April 07, 2008 12:51 PM Subject: Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space [EMAIL PROTECTED] napsal(a): I ran today a lega

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread Gregory Stark
"Zdenek Kotala" <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] napsal(a): >> relation 1663/19693/634162: No space left on device ... >> Disk saturation, you think ? No at all, as in the meantime : >> >> FilesystemSize Used Avail Use% Mounted on >> /dev/sda3 9.9G 8.5G 87

Re: [BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread Zdenek Kotala
[EMAIL PROTECTED] napsal(a): I ran today a legacy application with PG 8.3.1 on a test machine. The DB is some ~30 MB. Default tables do have OIDs and BLCKSZ is set system-wide to 16384 (because of another DB). Can you tried your application with standard BLKSZ? Or Can you send testcase? A

[BUGS] BUG #4096: PG 8.3.1. confused about remaining disk space

2008-04-07 Thread
The following bug has been logged online: Bug reference: 4096 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Linux Description:PG 8.3.1. confused about remaining disk space Details: I ran today a legacy application with PG 8