Re: transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile

Hi,
we are new-new on PostgreSQL,
we are making a benchmark on a Database of 300GB, and postgresql 8.1 on
AIX 5.3
after having loading the Database, creating indexes , executing the
analyze commands
we have launched a select query, the elapsed time for this query was 13
hours,
after this execution we fech the logfile and we have found the following
message :
transaction ID wrap limit is 2147484146, limited by database "postgres"

these parameters are set
export PGDATA=/INST/PG81
export PGUSER=pg_810
export pg_810=/INST/TMP

We have 3GB of memory and put these settings :

shared_buffers = 12288 # min 16 or max_connections*2,
8KB each
work_mem = 12288 # min 64, size in KB
#maintenance_work_mem = 49152 # min 1024, size in KB
maintenance_work_mem = 262144 # min 1024, size in KB, 256M

We stopped the instance and started again and the message still appears:

We don't know if it is an informatio message or an error message .
We don't understand why the message is like we will be on another PGDATA
"postgres" ,
but we are on the right one.

Someone can help us ?
Thanks
regards

See:

<http://www.postgresql.org/docs/8.0/interactive/
maintenance.html#VACUUM-FOR-WRAPAROUND>

Charley

On Dec 12, 2005, at 5:00 AM, Agnes Bocchino wrote:

> Hi,
> we are new-new on PostgreSQL,
> we are making a benchmark on a Database of 300GB, and postgresql
> 8.1 on AIX 5.3
> after having loading the Database, creating indexes , executing the
> analyze commands
> we have launched a select query, the elapsed time for this query
> was 13 hours,
> after this execution we fech the logfile and we have found the
> following message :
> transaction ID wrap limit is 2147484146, limited by database
> "postgres"
>
> these parameters are set
> export PGDATA=/INST/PG81
> export PGUSER=pg_810
> export pg_810=/INST/TMP
>
> We have 3GB of memory and put these settings :
>
> shared_buffers = 12288 # min 16 or
> max_connections*2, 8KB each
> work_mem = 12288 # min 64, size in KB
> #maintenance_work_mem = 49152 # min 1024, size in KB
> maintenance_work_mem = 262144 # min 1024, size in KB, 256M
>
> We stopped the instance and started again and the message still
> appears:
>
> We don't know if it is an informatio message or an error message .
> We don't understand why the message is like we will be on another
> PGDATA "postgres" ,
> but we are on the right one.
>
> Someone can help us ?
> Thanks
> regards
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

Agnes Bocchino <agnes(dot)bocchino(at)bull(dot)net> writes:
> transaction ID wrap limit is 2147484146, limited by database "postgres"

This is just an informational log message, it has nothing to do with any
performance problems you may be having.

regards, tom lane

Tom Lane wrote:

>Agnes Bocchino <agnes(dot)bocchino(at)bull(dot)net> writes:
>
>
>>transaction ID wrap limit is 2147484146, limited by database "postgres"
>>
>>
>
>This is just an informational log message, it has nothing to do with any
>performance problems you may be having.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend
>
>
>
Thanks, I'll don't care anymore for this message