Re: [PERFORM] High CPU usage / load average after upgrading to Ubuntu 12.04

2013-02-13 Thread Dan Kogan
Just to be clear - I was describing the current situation in our production. We were running pgbench on different Ununtu versions today. I don’t have 12.04 setup at the moment, but I do have 12.10, which seems to be performing about the same as 12.04 in our tests with pgbench. Running pgbench w

Re: [PERFORM] High CPU usage / load average after upgrading to Ubuntu 12.04

2013-02-13 Thread Josh Berkus
On 02/13/2013 11:24 AM, Josh Berkus wrote: > On 02/12/2013 05:28 PM, Dan Kogan wrote: >> Hi Will, >> >> Yes, I think we've seen some discussions on that. Our servers our hosted on >> Amazon Ec2 and upgrading the kernel does not seem so straight forward. >> We did a benchmark using pgbench on 3.5

Re: [PERFORM] High CPU usage / load average after upgrading to Ubuntu 12.04

2013-02-13 Thread Josh Berkus
On 02/12/2013 05:28 PM, Dan Kogan wrote: > Hi Will, > > Yes, I think we've seen some discussions on that. Our servers our hosted on > Amazon Ec2 and upgrading the kernel does not seem so straight forward. > We did a benchmark using pgbench on 3.5 vs 3.2 and saw an improvement. > Unfortunately

Re: [PERFORM] connection poolers' db connections

2013-02-13 Thread Yetkin Öztürk
Hi Kevin, thanks for responding. I understand its a world of bottlenecks, different combinations of producer-consumer problems, Beyond a certain point, starting the query sooner will cause it to > finish later. Really. but I think in our situation our Postgres server can consume more connect

Re: [PERFORM] connection poolers' db connections

2013-02-13 Thread Kevin Grittner
Yetkin Öztürk wrote: > Which key should i set for changing the limit of connection > between pgbouncer <-> posgres8.4? The options which end in _pool_size.  max_client_conn specifies how many application connections can be made to pgbouncer. It's generally best to use pool_mode of transaction i

[PERFORM] connection poolers' db connections

2013-02-13 Thread Yetkin Öztürk
Hello, tweaking our connection pooler (*pgbouncer*) and *posgres 8.4 *seemed a bit confusing to us. Which key should i set for changing the limit of connection between *pgbouncer <->posgres8.4?* i think configurations such as *max_client_conn, default_pool_size, ** default_pool_size* etc of *pg

Re: [PERFORM] Partition insert trigger using C language

2013-02-13 Thread Matheus de Oliveira
On Mon, Feb 11, 2013 at 1:24 PM, Ali Pouya wrote: > Hi Matheus, > I try to use your partition_insert_trigger_spi.c code for testing SPI > partitionning. > But at execution time the *trigdata->tg_trigger->tgargs* pointer is null. > Do you know why ? > Thanks a lot > Best Reagrds > Ali Pouya > > >