Generally you should use stored procedures when it will reduce the number
of round trips to the database. Wrapping simple SELECT statements in a
stored proc just adds friction for updating the application especially as
the number of developers grows.
On Wed, Aug 6, 2025, 8:04 AM Simon Connah wro
Thank you very much. I had a stale replication slot. I removed it and the
logs were cleaned up immediately.
--Justin
On Thu, Apr 10, 2025 at 8:48 AM Laurenz Albe
wrote:
> On Thu, 2025-04-10 at 08:28 -0400, Justin Swanhart wrote:
> > I have the following in my postgresql.conf fo
Hi,
I have the following in my postgresql.conf for archive logging:
archive_command='test ! -f /var/lib/postgresql/prod_archive_logs/%f && cp
%p /var/lib/postgresql/prod_archive_logs/%f'
This command is properly copying the log files to my archive directory but
they remain in the `pg_wal` directo
