[ADMIN] Need some help in psql Configuration

2008-01-01 Thread Suresh Gupta VG
Hi Team, I am using Postgresql 7.4 version. We are willing to update the version to the latest. Can you pls give some guidelines and provide the link to the software to download. Is it free downloadable or commercial, pls advice us. Secondly, we found there is very less performance with

Re: [ADMIN] Need some help in psql Configuration

2008-01-01 Thread Usama Dar
On Dec 31, 2007 11:21 AM, Suresh Gupta VG <[EMAIL PROTECTED]> wrote: > > > Hi Team, > > > > I am using Postgresql 7.4 version. We are willing to update the version to > the latest. Can you pls give some guidelines and provide the link to the > software to download. Is it free downloadable or comme

Re: [ADMIN] Need some help in psql Configuration

2008-01-01 Thread Julio Leyva
Subject: [ADMIN] Need some help in psql ConfigurationDate: Mon, 31 Dec 2007 11:51:38 +0530From: [EMAIL PROTECTED]: [EMAIL PROTECTED]; pgsql-admin@postgresql.org Hi Team, I am using Postgresql 7.4 version. We are willing to update the version to the latest. Can you p

Re: [ADMIN] What's the XID?

2008-01-01 Thread ivan.hou
how can i prove that the xid had been increased by 1? i do a test, step 1. SELECT datname, age(datfrozenxid) FROM pg_database; --> mydb age:33183 step 2. SELECT datname, age(datfrozenxid) FROM pg_database; --> mydb age:33188 step 3. SELECT datname, age(datfrozenxid) FROM pg_database; --> mydb

Re: [ADMIN] What's the XID?

2008-01-01 Thread Tom Lane
"ivan.hou" <[EMAIL PROTECTED]> writes: > step 1. SELECT datname, age(datfrozenxid) FROM pg_database; > --> mydb age:33183 > step 2. SELECT datname, age(datfrozenxid) FROM pg_database; > --> mydb age:33188 > why always increased by 5? If you do it directly in psql, it increases by 1. > Postgresql