We have released Psycopg 2.8.3, which includes a slight change to the
logical replication.
Choosing the right frequency to send replication feedback messages
from the client to the server was previously the developer's
responsibility, with too many feedback messages being a waste of
bandwidth and server resources, too few slowing down WAL cleanup and
possibly preventing a server graceful shutdown.
Psycopg will now make sure that feedback is only sent after a certain
period of time from the previous one, so that the client can simply
call send_feedback() at each message without the fear of overwhelming
the server.
Further details are available in the MR #913 by Alexander Kukushkin and
Oleksandr Shulgin. Thank you very much!
For completeness, the changes included in the release are:
- Added interval_status parameter to start_replication() method and
other facilities to send automatic replication keepalives at periodic
intervals (ticket #913).
- Fixed namedtuples caching introduced in 2.8 (ticket #928).
You can install psycopg2 from PyPI or grab the new code from:
- source package:
http://initd.org/psycopg/tarballs/PSYCOPG-2-8/psycopg2-2.8.3.tar.gz
- signature
http://initd.org/psycopg/tarballs/PSYCOPG-2-8/psycopg2-2.8.3.tar.gz.asc
----
Psycopg is the most popular PostgreSQL adapter for the Python
programming language. At its core it fully implements the Python DB
API 2.0 specifications. Several extensions allow access to many of the
features offered by PostgreSQL.