[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

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

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

[BUGS] BUG #4097: can join + where query be optimized?

2008-04-07 Thread Adriaan van Kekem
The following bug has been logged online: Bug reference: 4097 Logged by: Adriaan van Kekem Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Ubuntu 7.04 Description:can join + where query be optimized? Details: In the following query you see

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 legacy application with PG 8.3.1

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 Also check "df -i" This might be an

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
OK. So why did this not occur when I was running 8.2.6 ? To avoid any ambiguity, here we go estp-intranet:~ # su - postgres [EMAIL PROTECTED]:~> cd /var/lib/pgsql [EMAIL PROTECTED]:~> cd data [EMAIL PROTECTED]:~/data> ls base pg_hba.confpg_multixact pg_twophase postgresql.conf global

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 J6M
debugreiserfs /dev/sdb1 debugreiserfs 3.6.19 (2003 www.namesys.com) Filesystem state: consistency is not checked after last mounting Reiserfs super block in block 16 on 0x811 of format 3.6 with standard journal Count of blocks on the device: 9769520 Number of bitmaps: 299 Blocksize: 4096 Free

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

[BUGS] BUG #4098: Encoding problems

2008-04-07 Thread Jan-Peter Seifert
The following bug has been logged online: Bug reference: 4098 Logged by: Jan-Peter Seifert Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows xp Description:Encoding problems Details: The encoding of the source db/server is LATIN1. Th

Re: [BUGS] BUG #4098: Encoding problems

2008-04-07 Thread Heikki Linnakangas
Jan-Peter Seifert wrote: The following bug has been logged online: Bug reference: 4098 Logged by: Jan-Peter Seifert Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows xp Description:Encoding problems Details: The encoding of the sou

[BUGS] BUG #4099: backup error

2008-04-07 Thread felipe macedo
The following bug has been logged online: Bug reference: 4099 Logged by: felipe macedo Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: windows 2003 server Description:backup error Details: This is urgent, I would like to know if there is a

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