| From: | Kevin Kempter <cs_dba(at)consistentstate(dot)com> |
|---|---|
| To: | bricklen <bricklen(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: slow DDL creation |
| Date: | 2010-08-31 15:35:14 |
| Message-ID: | 201008310935.14919.cs_dba@consistentstate.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Monday 30 August 2010 17:04, bricklen wrote:
> On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter
>
> <cs_dba(at)consistentstate(dot)com> wrote:
> > Hi all ;
> >
> > we have an automated partition creation process that includes the
> > creation of an FK constraint. we have a few other servers with similar
> > scenarios and this is the only server that stinks per when we create the
> > new partitions.
> >
> > Anyone have any thoughts on how to debug this? were running postgres
> > 8.4.4 on CentOS 5.5
> >
> > Thanks in advance
>
> Is the referenced column indexed?
no, but its for a new partition so there's no data as of yet in the partition
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2010-08-31 15:43:41 | Re: Performance on new 64bit server compared to my 32bit desktop |
| Previous Message | Yeb Havinga | 2010-08-31 12:41:42 | Re: Performance on new 64bit server compared to my 32bit desktop |