Thread: transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile
transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile
From
Agnes Bocchino
Date:
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
Re: transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile
From
Charley Tiggs
Date:
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
Re: transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile
From
Tom Lane
Date:
Agnes Bocchino <agnes.bocchino@bull.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.bocchino@bull.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