On 5/4/20 4:56 AM, Peter wrote:
Hi all,
I have something that looks a bit insane:
# ps axl | grep 6145
UID PID PPID CPU PRI NI VSZ RSS MWCHAN STAT TT TIME
COMMAND
770 6145 1 0 20 0 241756 868 select SsJ - 0:24.62
/usr/local/bin/postgres -D
770 6147 6145 0 23 0 243804 109784 select IsJ - 3:18.52
postgres: checkpointer (
770 6148 6145 0 20 0 241756 21348 select SsJ - 2:02.83
postgres: background writer
770 6149 6145 0 20 0 241756 7240 select SsJ - 16:36.80
postgres: walwriter (pos
770 6150 6145 0 20 0 21980 876 select SsJ - 0:13.92
postgres: archiver last w
770 6151 6145 0 20 0 21980 980 select SsJ - 0:58.45
postgres: stats collector
770 6152 6145 0 20 0 241756 1268 select IsJ - 0:02.07
postgres: logical replicati
770 43315 6145 0 21 0 251844 7520 select IsJ - 1:07.74
postgres: admin postgres 19
770 43317 6145 0 25 0 251764 8684 select IsJ - 1:28.89
postgres: admin bareos 192.
770 43596 6145 0 20 0 245620 4476 select IsJ - 0:00.12
postgres: admin bareos 192.
770 43761 6145 0 20 0 245620 4476 select IsJ - 0:00.15
postgres: admin bareos 192.
770 90206 6145 0 52 0 1331256 219720 racct DsJ - 563:45.41
postgres: bareos bareos 192
The 90206 is continuously growing. It is the unspecific, all-purpose
worker for the www.bareos.com backup tool, so it is a bit difficult to
figure what precisely it does - but it tends to be rather simple
straight-forward queries, so it is unlikely to have dozens of "internal sort
operations and hash tables".
Is there any relevant information in the bareos or Postgres logs?
OS is FreeBSD 11.3-RELEASE-p8 r360175M i386
PostgreSQL 12.2 on i386-portbld-freebsd11.3, compiled by gcc9 (FreeBSD Ports
Collection) 9.3.0, 32-bit
autovacuum is Disabled.
Any particular reason for above?
cheerio,
PMc
--
Adrian Klaver
adrian.kla...@aklaver.com
