| From: | Dimitri Maziuk <dmaziuk(at)bmrb(dot)wisc(dot)edu> |
|---|---|
| To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | logical replication snapshots |
| Date: | 2018-07-23 20:23:04 |
| Message-ID: | 3bf34856-efb9-01e8-3147-1e0dff1f7131@bmrb.wisc.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi everyone,
I'm playing with logical replication in postgres-10 and I got it to hang
on startup with
> 2018-07-23 13:15:06.577 CDT [18624] FATAL: the database system is starting up
> 2018-07-23 13:15:06.577 CDT [18624] DEBUG: shmem_exit(1): 0 before_shmem_exit callbacks to make
> 2018-07-23 13:15:06.577 CDT [18624] DEBUG: shmem_exit(1): 0 on_shmem_exit callbacks to make
> 2018-07-23 13:15:06.577 CDT [18624] DEBUG: proc_exit(1): 1 callbacks to make
> 2018-07-23 13:15:06.577 CDT [18624] DEBUG: exit(1)
> 2018-07-23 13:15:06.577 CDT [18624] DEBUG: shmem_exit(-1): 0 before_shmem_exit callbacks to make
> 2018-07-23 13:15:06.577 CDT [18624] DEBUG: shmem_exit(-1): 0 on_shmem_exit callbacks to make
> 2018-07-23 13:15:06.577 CDT [18624] DEBUG: proc_exit(-1): 0 callbacks to make
... forever ...
After poking around:
# find /var/lib/pgsql/10/data/pg_logical/snapshots -printf . | wc -c
12727975
It looks like ZFS simply can't handle this many files: `ls` etc. hang
forever.
So my question is, does it have to be that many? And if not, is there a
knob to keep the number down?
TIA
--
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Brannen | 2018-07-23 21:54:07 | RE: Improving pg_dump performance |
| Previous Message | Adrian Klaver | 2018-07-23 19:58:17 | Re: Connections on cluster not being logged |