From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: High load on commit after important schema changes |
Date: | 2009-08-28 19:19:09 |
Message-ID: | 20090828191909.GA4864@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Aug 28, 2009 at 12:47:15PM -0400, Tom Lane wrote:
> hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> > On Fri, Aug 28, 2009 at 12:28:06PM -0400, Tom Lane wrote:
> >> Hm, do you have forty or so idle backends hanging around while this
> >> happens? The only thing I can think of that might be causing this is
> >> shared cache invalidation messages being broadcast to all the other
> >> sessions.
> > I have about 1000 backends running.
> Ouch. You need to update to 8.4 --- the SI messaging stuff will
> definitely be hurting you with that many backends. Or consider
> using connection pooling or something to cut the number of backends.
Do you have any idea on how (easily) to test if this is the cause of the
situation?
Will running 1000 connections to db, making each of them run query on
some table, keep the connection open, and then in another connection
doing the rename thing on it - work?
Best regards,
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
From | Date | Subject | |
---|---|---|---|
Next Message | Sergey Samokhin | 2009-08-28 19:44:21 | Re: A safe way to upgrade table definitions by using ALTER's |
Previous Message | Steven Lembark | 2009-08-28 19:13:47 | Question on round-robin partitioning |