Re: Postgres 9.2.13 on AIX 7.1 - Mailing list pgsql-bugs

From Rainer Tammer
Subject Re: Postgres 9.2.13 on AIX 7.1
Date
Msg-id 20217971-0a12-6a39-2b54-c13008afc3f0@spg.schulergroup.com
Whole thread Raw
In response to Re: Postgres 9.2.13 on AIX 7.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Postgres 9.2.13 on AIX 7.1  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Hello,
Could this really be related to the auto vacuum?
I have disabled auto vacuum and the instance is now running for ~ 3h.
I have imported ~ 500MB data and executed some queries via psql.

Any idea is appreciated!

This is the current config for 9.2.13:

max_connections = 100
shared_buffers = 32MB
log_min_messages = debug5
log_line_prefix = '%t %h %u'
log_timezone = 'Europe/Berlin'
autovacuum = off
datestyle = 'iso, mdy'
timezone = 'Europe/Berlin'
lc_messages = 'en_US'
lc_monetary = 'en_US'
lc_numeric = 'en_US'
lc_time = 'en_US'
default_text_search_config = 'pg_catalog.english'


I have set debug to 5, so that we get some additional information is the DB goes down unintended.

Bye
  Rainer

pgsql-bugs by date:

Previous
From: Ashutosh Kumar
Date:
Subject: RE: BUG #17156: pg_restore: [custom archiver] WARNING: ftell mismatch with expected position -- ftell used
Next
From: Tom Lane
Date:
Subject: Re: BUG #17158: Distinct ROW fails with Postgres 14