Re: Megabytes of stats saved after every connection

Поиск
Список
Период
Сортировка
От Phil Endecott
Тема Re: Megabytes of stats saved after every connection
Дата
Msg-id 42E960DF.6080009@chezphil.org
обсуждение исходный текст
Ответ на Megabytes of stats saved after every connection  (Phil Endecott <spam_from_postgresql_general@chezphil.org>)
Список pgsql-general
 >> This is Linux 2.4.26 and an ext3 filesystem.
 > With the dir_index feature or without?

With, I believe.  It is enabled in the superblock (tune2fs -O dir_index)
but this was not done when the filesystem was created so only new
directories are indexed I think.  I don't think there's a way to index
an existing directory on a mounted filesystem, or to tell if a
particular directory is indexed.  I created new directories for my
postgres data and moved the files into them in the hope that they would
then have indexes, but am not sure how to check.

In any case, this does not seem to be a bottleneck.

--Phil.



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

Предыдущее
От: "Peter L. Berghold"
Дата:
Сообщение: ecpg and C++
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Megabytes of stats saved after every connection