Re: [PERFORM] Postgres 9.1.4 - high stats collector IO usage

2012-08-12 Thread David Barton
Hi Jeff, Thanks for the detailed reply. On 13/08/12 05:23, Jeff Janes wrote: On Fri, Jul 27, 2012 at 9:33 PM, David Barton wrote: Hi, I have roughly 150 different databases, each of which is running in 1 of roughly 30 tablespaces. The databases are small (the dump of most is are under 100M

Re: [PERFORM] Deferred constraints performance impact ?

2012-08-12 Thread Jeff Davis
On Thu, 2012-07-19 at 20:27 -0600, mark wrote: > I understand a lot more may have to be tracked through a transaction and > there could be some impact from that. Similar to an after update trigger? Or > are the two not comparable in terms of impact from what is tracked and then > checked. They sh

Re: [PERFORM] Postgres 9.1.4 - high stats collector IO usage

2012-08-12 Thread Jeff Janes
On Fri, Jul 27, 2012 at 9:33 PM, David Barton wrote: > Hi, > > I am running postgres 9.1.4 on Ubuntu 12.04 and the stats collector is > generating very high IO usage even when nothing appears to be happening on > the system. > > I have roughly 150 different databases, each of which is running in 1