Re: Problem with files size in /var/lib/postgres/data/global on Debian Woody - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with files size in /var/lib/postgres/data/global on Debian Woody
Date
Msg-id 23206.1044586224@sss.pgh.pa.us
Whole thread Raw
In response to Problem with files size in /var/lib/postgres/data/global on Debian Woody  (Picrate <picrate@ibelgique.com>)
List pgsql-general
Picrate <picrate@ibelgique.com> writes:
> Here is a listing of my /var/lib/postgres/data/global directory:

> total 465076
> drwx------    2 postgres postgres     4096 f�v  3 15:43 .
> drwx------    6 postgres postgres     4096 f�v  3 15:43 ..
> -rw-------    1 postgres postgres     8192 jan 29 15:41 1260
> -rw-------    1 postgres postgres     8192 jan 29 15:41 1261
> -rw-------    1 postgres postgres     8192 f�v  3 04:02 1262
> -rw-------    1 postgres postgres    16384 oct 28 11:05 16430
> -rw-------    1 postgres postgres    16384 oct 28 11:05 16431
> -rw-------    1 postgres postgres    16384 oct 29 04:00 16433
> -rw-------    1 postgres postgres    16384 oct 29 04:00 16434
> -rw-------    1 postgres postgres    16384 oct 29 04:00 16450
> -rw-------    1 postgres postgres    16384 oct 29 04:00 16451
> -rw-------    1 postgres postgres     8192 f�v  3 15:43 pg_control
> -rw-------    1 postgres postgres       35 oct 28 11:18 pg_pwd
> -rw-------    1 postgres postgres        6 f�v  3 15:43 pgstat.stat
> -rw-------    1 postgres postgres        0 d�c 17 14:41 pgstat.tmp.32209

That's really bizarre.  The only hidden overhead I can think of is
indirect blocks, but there's no reason for any of these files to
have *any* indirect blocks, let alone hundreds of meg worth.

What's the filesystem being used, exactly?  What do you get with
"ls -lsa .../global" ?

            regards, tom lane

pgsql-general by date:

Previous
From: Ben
Date:
Subject: Re: PostgreSQL v MSSQL
Next
From: Tom Lane
Date:
Subject: Re: Dealing with complex queries