Re: SSI patch version 14

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: simon(at)2ndQuadrant(dot)com, markus(at)bluegap(dot)ch, drkp(at)csail(dot)mit(dot)edu, pgsql-hackers(at)postgresql(dot)org
Subject: Re: SSI patch version 14
Date: 2011-02-08 09:25:34
Message-ID: 4D510C0E.5080500@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 08.02.2011 10:43, Kevin Grittner wrote:
> Heikki Linnakangas wrote:
>
>> Ok, committed.
>
> I see that at least three BuildFarm critters don't have UINT64_MAX
> defined.

I guess we'll have to just #define it ourselves. Or could we just pick
another magic value, do we actually rely on InvalidSerCommitSeqno being
higher than all other values anywhere?

> Not sure why coypu is running out of connections.

Hmm, it seems to choose a smaller max_connections value now, 20 instead
of 30. Looks like our shared memory usage went up by just enough to pass
that threshold.

Looks like our shared memory footprint grew by about 2MB with default
configuration, from 37MB to 39MB. That's quite significant. Should we
dial down the default of max_predicate_locks_per_transaction? Or tweak
the sizing of the hash tables somehow?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2011-02-08 09:26:55 Re: exposing COPY API
Previous Message Itagaki Takahiro 2011-02-08 09:22:18 Re: [HACKERS] Issues with generate_series using integer boundaries