Re: Question to transaction ID wraparound

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

 




Scott Marlowe wrote:
> -----Ursprüngliche Nachricht-----
> Von: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx] 
> Gesendet: Freitag, 27. Februar 2009 11:04
> An: Lentes, Bernd
> Cc: pgsql-admin@xxxxxxxxxxxxxx
> Betreff: Re:  Question to transaction ID wraparound
> 
> On Wed, Feb 25, 2009 at 3:05 AM, Lentes, Bernd 
> <bernd.lentes@xxxxxxxxxxxxxxxxxxxxx> wrote:
> > Hello ML,
> >
> > I'm very new to Postgres.
> > In the log, i got messages concerning transaction ID wraparound.
> > I red the documentation and made a vaccum on that database.
> > In the documentation i also found the hint to look in the database 
> > with "SELECT datname, age(datfrozenxid) FROM pg_database;", 
> which i did.
> > I did the command several times in a few seconds, and this 
> number is 
> > growing very quickly, although i'm not expecting 
> transactions in the database.
> 
> Please note that nearly EVERYTHING that happens in postgres 
> is a transaction.  if you type a single command, boom, it's a 
> transaction.
> You actually get fewer transaction events if you enclose a 
> bunch of stuff in begin; commit; pairs than if you run single 
> commands.
> 
Scott, why does the number increase ?
If it says how many transactions are still possible, the number should decrease, not increase.

Bernd

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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux