[PATCH] pg_receivewal skip WAL file size checking

2024-01-19 Thread Sergey Sergey
We have a huge amount of WAL files at backup site. A listing of the directory takes several seconds. During startup pg_receivewal checks size of all theus files. It does not check file integrity or gaps between files. It takes several hours for our setup. I have add an options that skip this file

Re: [PATCH] fastpacth-locks compile time options

2023-09-18 Thread Sergey Sergey
Thank you for response. On Tue, Sep 19, 2023 at 2:52 AM Michael Paquier wrote: > On Mon, Sep 18, 2023 at 05:49:51PM +0300, Sergey Sergey wrote: > > Hope this patch will be usefull/ > > -uint64 fpLockBits;/* lock modes held for each fast-path > sl

Re: [PATCH] fastpacth-locks compile time options

2023-09-18 Thread Sergey Sergey
Hope this patch will be usefull/ On Mon, Sep 18, 2023 at 5:47 PM Sergey Sergey wrote: > While replaying our production workload we have found Postgres spending a > lot of time inside TimescaleDB planner. The planner itself need an > information about whether a table involved is a Ti

[PATCH] fastpacth-locks compile time options

2023-09-18 Thread Sergey Sergey
While replaying our production workload we have found Postgres spending a lot of time inside TimescaleDB planner. The planner itself need an information about whether a table involved is a TimescaleDB hypertable. So planner need an access to TimescaleDB internal metainformation tables. This planner