pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedslow DDL creation
5+ messages / 4 participants
[nested] [flat]
* slow DDL creation
@ 2010-08-30 22:28 Kevin Kempter <cs_dba@consistentstate.com>
2010-08-30 23:04 ` Re: slow DDL creation bricklen <bricklen@gmail.com>
2010-08-31 00:31 ` Re: slow DDL creation David Fetter <david@fetter.org>
0 siblings, 2 replies; 5+ messages in thread
From: Kevin Kempter @ 2010-08-30 22:28 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: slow DDL creation
2010-08-30 22:28 slow DDL creation Kevin Kempter <cs_dba@consistentstate.com>
@ 2010-08-30 23:04 ` bricklen <bricklen@gmail.com>
2010-08-31 15:35 ` Re: slow DDL creation Kevin Kempter <cs_dba@consistentstate.com>
1 sibling, 1 reply; 5+ messages in thread
From: bricklen @ 2010-08-30 23:04 UTC (permalink / raw)
To: Kevin Kempter <cs_dba@consistentstate.com>; +Cc: pgsql-performance
On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter
<cs_dba@consistentstate.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?
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: slow DDL creation
2010-08-30 22:28 slow DDL creation Kevin Kempter <cs_dba@consistentstate.com>
2010-08-30 23:04 ` Re: slow DDL creation bricklen <bricklen@gmail.com>
@ 2010-08-31 15:35 ` Kevin Kempter <cs_dba@consistentstate.com>
2010-09-21 19:38 ` Re: slow DDL creation Robert Haas <robertmhaas@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Kevin Kempter @ 2010-08-31 15:35 UTC (permalink / raw)
To: bricklen <bricklen@gmail.com>; +Cc: pgsql-performance
On Monday 30 August 2010 17:04, bricklen wrote:
> On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter
>
> <cs_dba@consistentstate.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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: slow DDL creation
2010-08-30 22:28 slow DDL creation Kevin Kempter <cs_dba@consistentstate.com>
2010-08-30 23:04 ` Re: slow DDL creation bricklen <bricklen@gmail.com>
2010-08-31 15:35 ` Re: slow DDL creation Kevin Kempter <cs_dba@consistentstate.com>
@ 2010-09-21 19:38 ` Robert Haas <robertmhaas@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Robert Haas @ 2010-09-21 19:38 UTC (permalink / raw)
To: Kevin Kempter <cs_dba@consistentstate.com>; +Cc: bricklen <bricklen@gmail.com>; pgsql-performance
On Tue, Aug 31, 2010 at 11:35 AM, Kevin Kempter
<cs_dba@consistentstate.com> wrote:
> On Monday 30 August 2010 17:04, bricklen wrote:
>> On Mon, Aug 30, 2010 at 3:28 PM, Kevin Kempter
>>
>> <cs_dba@consistentstate.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
What exactly does "stinks" mean?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: slow DDL creation
2010-08-30 22:28 slow DDL creation Kevin Kempter <cs_dba@consistentstate.com>
@ 2010-08-31 00:31 ` David Fetter <david@fetter.org>
1 sibling, 0 replies; 5+ messages in thread
From: David Fetter @ 2010-08-31 00:31 UTC (permalink / raw)
To: Kevin Kempter <cs_dba@consistentstate.com>; +Cc: pgsql-performance
On Mon, Aug 30, 2010 at 04:28:25PM -0600, Kevin Kempter 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
If you're doing the partitions on demand, you could be getting
deadlocks. Any reason not to pre-create a big bunch of them in
advance?
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-09-21 19:38 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-08-30 22:28 slow DDL creation Kevin Kempter <cs_dba@consistentstate.com>
2010-08-30 23:04 ` bricklen <bricklen@gmail.com>
2010-08-31 15:35 ` Kevin Kempter <cs_dba@consistentstate.com>
2010-09-21 19:38 ` Robert Haas <robertmhaas@gmail.com>
2010-08-31 00:31 ` David Fetter <david@fetter.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox