Re: Problem with files size in /var/lib/postgres/data/global on Debian Woody
От | Tom Lane |
---|---|
Тема | Re: Problem with files size in /var/lib/postgres/data/global on Debian Woody |
Дата | |
Msg-id | 23206.1044586224@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Problem with files size in /var/lib/postgres/data/global on Debian Woody (Picrate <picrate@ibelgique.com>) |
Список | 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 по дате отправления: