Re: Strange behaviour: create database hangs (v 8.4.4) - Mailing list pgsql-admin

From Dale Gallagher
Subject Re: Strange behaviour: create database hangs (v 8.4.4)
Date
Msg-id AANLkTilsKP5ik1vMKHApdE4J7_CF7XLR4eqGTPN6sRPC@mail.gmail.com
Whole thread Raw
In response to Re: Strange behaviour: create database hangs (v 8.4.4)  (Dale Gallagher <dale.gallagher@gmail.com>)
Responses Re: Strange behaviour: create database hangs (v 8.4.4)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On 31 May 2010 13:10, Dale Gallagher <dale.gallagher@gmail.com> wrote:
> I am now using strace on postgres startup and watching the filesystem
> during the creation of the database. So far, it seems that files in
> PGHOME/base/1234/ are appearing, but VERY slowly. Thus far it's taken
> 7 minutes and 92 files have been created. The command has not
> completed within psql....
>
> Could this be a filesystem corruption issue? The host is using ext4.

The command finally completed. It took a VERY long time. Something is
wrong, but I have no clue what.

pgsql-admin by date:

Previous
From: Dale Gallagher
Date:
Subject: Re: Strange behaviour: create database hangs (v 8.4.4)
Next
From: Dimitri Fontaine
Date:
Subject: Re: Advice on HA/LB setup for small installation