Re: Weird disk/table space consumption problem

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Weird disk/table space consumption problem
Дата
Msg-id dcc563d10907120022q1ca7b22dv1eb1298aee0b74fa@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Weird disk/table space consumption problem  (Dirk Riehle <dirk@riehle.org>)
Список pgsql-general
On Sat, Jul 11, 2009 at 7:19 PM, Dirk Riehle<dirk@riehle.org> wrote:
> Tom Lane wrote:
>>
>> Dirk Riehle <dirk@riehle.org> writes:

>>> During boot, fsck (must have been fsck) gave me tons of freeing up inode
>>> messages.
>>
>> And this part is a filesystem bug; it cannot possibly be Postgres'
>> fault that the filesystem got corrupted.
>
> One would think so? But the reboot should have stopped PostgreSQL properly.

Doesn't matter whether or not pgsql was shut down properly, it
shouldn't result in file system corruption.  Now if the file wasn't
properly unmounted before power down, that could cause file system
corruption.  With a journaling file system the file system should come
right back up corruption free.

Are you running an older distro or something maybe?

В списке pgsql-general по дате отправления:

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: indexes on float8 vs integer
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Weird disk/table space consumption problem