From: | Charley Tiggs <ctiggs(at)xpressdocs(dot)com> |
---|---|
To: | Agnes Bocchino <agnes(dot)bocchino(at)bull(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile |
Date: | 2005-12-12 13:51:53 |
Message-ID: | 0EA21325-C6B3-41BF-8E48-53E9AC75FCFD@xpressdocs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-12-12 15:13:41 | Re: Disk access with fsync on. |
Previous Message | Agnes Bocchino | 2005-12-12 11:00:37 | transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile |