Skip site navigation (1) Skip section navigation (2)

Re: does wal archiving block the current client connection?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: does wal archiving block the current client connection?
Date: 2006-05-18 13:45:54
Message-ID: 13179.1147959954@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
Jeff Frost <jeff(at)frostconsultingllc(dot)com> writes:
> Hrmmm...my pgbench died with an integer out of range error:

That's normal, if you run it long enough without re-creating the tables.
It keeps adding small values to the balances, and eventually they
overflow.  (Possibly someone should fix it so that the deltas are
uniformly distributed around zero, instead of being always positive.)

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2006-05-18 14:26:46
Subject: Re: PL/pgSQL 'i = i + 1' Syntax
Previous:From: Martijn van OosterhoutDate: 2006-05-18 11:42:01
Subject: Re: [PATCH] Compression and on-disk sorting

pgsql-admin by date

Next:From: Jeff FrostDate: 2006-05-18 14:54:51
Subject: Re: does wal archiving block the current client connection?
Previous:From: Alvaro HerreraDate: 2006-05-18 13:10:30
Subject: Re: install_driver(Pg) failed: Can't load Pg.so

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group