Search Postgresql Archives

Re: PostgreSQL 64 Bit XIDs - Transaction IDs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, 23 Mar 2012, Tom Lane wrote:

Merlin Moncure <mmoncure@xxxxxxxxx> writes:
On Fri, Mar 23, 2012 at 11:35 AM, Gerhard Wiesinger <lists@xxxxxxxxxxxxx> wrote:
So I think XID overflow should be planned for one of the next PostgreSQL
releases.

two mitigating factors:
1. read only transactions do not increment xid counter

Yes.  Ask your admin what his throughput of *data modifying*
transactions is.  I'll bet that number is a few orders of magnitude
smaller again.

That were all small writing transactions benchmarking the database (with the corrected values discussed).

Ciao,
Gerhard

--
http://www.wiesinger.com/

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux