Re: Megabytes of stats saved after every connection

From: Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Megabytes of stats saved after every connection
Date: 2005-07-28 22:49:03
Message-ID: 42E960DF.6080009@chezphil.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-07-29 01:08:33 Re: Megabytes of stats saved after every connection
Previous Message Guy Rouillier 2005-07-28 22:48:21 Re: Megabytes of stats saved after every connection