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
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
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
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
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
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
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
>
>
>