create of partition table slow - Mailing list pgsql-admin

From Anj Adu
Subject create of partition table slow
Date
Msg-id f2fd819a0907271505m177463dfl2f099774e6b82cf7@mail.gmail.com
Whole thread Raw
List pgsql-admin
Why does the following statement take very long

create table child_table_2009_08_01(check (datefield >=  '2009-08-01
00:00:00' and datefield < '2009-08-02 00:00:00')) inherits
(parent_table)

Note that this is the first partition for the month of August.
Subsequent partitions are created very quickly.

There are about 15 existing partitions already present for the parent
table. I would expect create table to be lightning fast...is there
more to the create partitioned table than meets the eye.

There are no concurrent accesses to the table. I disable all remote
and local connections so that only the create partitions script runs.

Postgres version 8.1.2 running on Dell 2850 Raid 10(4x300G disks)
RHEL 3 2.4.21-37.ELsmp

pgsql-admin by date:

Previous
From: Carol Walter
Date:
Subject: Re: Cannot connect to postgresql - Problem solved - Why / How?
Next
From: Kevin Kempter
Date:
Subject: force varchar column to be lowercase