unregister On Mon, May 31, 2010 at 9:59 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Dale Gallagher <dale.gallagher@xxxxxxxxx> writes: >> On 31 May 2010 13:10, Dale Gallagher <dale.gallagher@xxxxxxxxx> 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. > > Seems like you must have a kernel/filesystem issue, but I don't know > what either. CREATE DATABASE just copies the contents of template1 > using some absolutely straightforward code (look into src/port/copydir.c) > so it's entirely filesystem-limited. > > You could try tracing the backend that's doing the command with > "strace -r -p <pid>" to try to get an idea of which system calls > are eating all the time. > > regards, tom lane > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
