Re: Why age (datfrozenxid) in postgres becomes 1073742202 not zero after each vacuum of database.

Brahma Prakash Tiwari escribió:
>
> *Hi all*
>
> *Why age (datfrozenxid) in postgres becomes 1073742202 not zero after
> vacuum of database.*
>
> *Thanks in advance *
>
>
>
> **Brahma Prakash Tiwari**** **
>
> DBA
>
> ------------------------------------------------------------------------
>
> **Think before you print.|Go green**
>
>
>
This is not the right list for that.
Send the message to pgsql-users(at)postgresql(dot)org or another.
This list is for the related jobs with PostgreSQL.

Regards

--
--
"For me, the purpose is, at least partly, to have joy. Programmers often
feel joy when they can concentrate on the creative side of programming,
so Ruby is designed to make programmers happy."
Yukihiro Matsumoto (Matz), Creator of the Ruby Language

Ing. Marcos Luís Ortíz Valmaseda
System DBA && Rails New User
Centro de Tecnologías de Almacenamiento y Anális de Datos (CENTALAD)
Universidad de las Ciencias Informáticas

Linux User # 418229

http://www.freebsd.org
http://www.postgresql-es.org
http://www.postgresql.org
http://www.planetpostgresql.org
http://www.rubyonrails.org
http://www.ruby-lang.org

Hi all

Why age (datfrozenxid) in postgres becomes 1073742202 not zero after vacuum
of database.

Thanks in advance

Brahma Prakash Tiwari

DBA

_____

Think before you print.|Go green

I am recruiting for a contract Web Architect to work for our client in
Portland, Oregon.

This Web Architect will start as a contract opportunity with the possibility
of leading into a full time job. The Web Architect will be working with the
outsource providers and internal team members to complete this engagement's
deliverables. The project will be involved with moving from a Windows based
system to an Open Source based, web system. This will involve:

. Create Infrastructure Design Document as well as oversight, approval and
creation of design configuration guides. The IDD should have sections on
different environments such as Quality Assurance, Performance Testing, Beta
and Production.
. Technical oversight of Deployment through Beta test environment being
ready for start of Beta Test.

The ideal candidate for this position will have experience designing,
building and maintaining IT infrastructures for web based applications. The
position will mostly involve architecting web solutions with .Net and Open
Source technologies such as Linux, Java, Geronimo and PostgreSQL.

If you are interested in an opportunity such as this, please feel free to
send a copy of your resume to me as soon as possible.

Kirk

Kirk Baillie
Principle
Makena Technical Resources
k(dot)baillie(at)comcast(dot)net

[ removing -jobs from cc list as it is not appropriate for this posting ]

On Thu, Nov 12, 2009 at 3:18 AM, Brahma Prakash Tiwari
<brahma(dot)tiwari(at)inventum(dot)cc> wrote:
> Hi all
>
> Why age (datfrozenxid) in postgres becomes 1073742202 not zero after vacuum
> of database.
>
> Thanks in advance

I think you're misunderstanding the meaning of the column. As the
fine manual explains:

"Similarly, the datfrozenxid column of a database's pg_database row is
a lower bound on the normal XIDs appearing in that database — it is
just the minimum of the per-table relfrozenxid values within the
database."

http://www.postgresql.org/docs/current/static/routine-vacuuming.html

...Robert