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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-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

Browse pgsql-admin by date

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

Browse pgsql-hackers by date

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