Home > mailing lists

Max message size / constraints? - Mailing list psycopg

From	Tony Shelver
Subject	Max message size / constraints?
Date	October 31, 2018 09:35:55
Msg-id	CAG0dhZAZkq9LM_8GVrzk63FGKgsJ_+cb7nFA=OzJX8C6oQRQCA@mail.gmail.com Whole thread Raw
List	psycopg

I am calling postgresql functions / stored procedures to insert / update data, passing the data in jsonb format.

To avoid roundtripping for each record to be inserted / updated, I would like to compose multiple records in a single jsonb parameter.

Is there a limit in psycopg2 as to the size of the parameter?

Thanks

Tony

psycopg by date:

From: Daniele Varrazzo
Date: 30 October 2018, 19:07:25
Subject: Re: psycopg2 conn.poll() hangs when used with sshtunnel

From: Christophe Pettus
Date: 03 November 2018, 04:28:51
Subject: Multiple message delivery on logical replication