| From: | Rainer Tammer <pgsql(at)spg(dot)schulergroup(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Postgres 9.2.13 on AIX 7.1 |
| Date: | 2021-08-24 11:55:11 |
| Message-ID: | 20217971-0a12-6a39-2b54-c13008afc3f0@spg.schulergroup.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-08-24 14:03:26 | Re: BUG #17158: Distinct ROW fails with Postgres 14 |
| Previous Message | Ashutosh Kumar | 2021-08-24 10:01:52 | RE: BUG #17156: pg_restore: [custom archiver] WARNING: ftell mismatch with expected position -- ftell used |