On 12/8/18 8:21 PM, Jeremy Finzel wrote:
There are 2.1 million files in pg_replslot which I don't think is
normal? Any ideas as to where I should be looking or what could cause this?
Postgres spills changes on disk when you have a big transaction:
On Sat, Dec 8, 2018 at 1:21 PM Jeremy Finzel wrote:
> That doesn't indicate an error. You need to provide more details what
>> made you consider things wedged...
>>
>> Andres
>>
>
> Thank you very much for the reply. We typically see no visible
> replication delay over 5 minutes ever. Today
>
> That doesn't indicate an error. You need to provide more details what
> made you consider things wedged...
>
> Andres
>
Thank you very much for the reply. We typically see no visible replication
delay over 5 minutes ever. Today we saw a delay of over 3 hours, and no
obvious increase in
now even though replication appears
>to
>be working, strace shows these kinds of errors continually:
>open("pg_replslot/pgl_foo_providerb97b25d_foo336ddc1/xid-1248981532-lsn-C940-F400.snap",
>O_RDONLY) = -1 ENOENT (No such file or directory)
>open("pg_replslot/pgl_fo
lslot/pgl_foo_providerb97b25d_foo336ddc1/xid-1248981532-lsn-C940-F400.snap",
O_RDONLY) = -1 ENOENT (No such file or directory)
open("pg_replslot/pgl_foo_providerb97b25d_foo336ddc1/xid-1248981532-lsn-C940-F500.snap",
O_RDONLY) = -1 ENOENT (No such file or director