Re: Problem with files size in /var/lib/postgres/data/global on Debian Woody

Picrate <picrate(at)ibelgique(dot)com> writes:
> Here is a listing of my /var/lib/postgres/data/global directory:

> total 465076
> drwx------ 2 postgres postgres 4096 fv 3 15:43 .
> drwx------ 6 postgres postgres 4096 fv 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 fv 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 fv 3 15:43 pg_control
> -rw------- 1 postgres postgres 35 oct 28 11:18 pg_pwd
> -rw------- 1 postgres postgres 6 fv 3 15:43 pgstat.stat
> -rw------- 1 postgres postgres 0 dc 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