Append to stream is limited to 7,281 events

[slashdotdash]

Events are appended to a stream using a single INSERT statement. This is to ensure they are inserted with contiguous event ids and for performance reasons. Each event uses nine parameters, and there are an additional three parameters for event id, stream id and stream version. PostgreSQL can support a maximum of 65,535 parameters in a single query. Therefore you are limited to 7,281 events in a single INSERT statement (7,281 * 9 + 3 = 65,532).

Attempting to insert too many events results in the following error:

Postgrex.Protocol (#PID<0.17104.79>) disconnected: ** (RuntimeError) postgresql protocol can not handle 104268 parameters, the maximum is 65535

The events should be inserted in batches (e.g. 1,000 events at a time) within a single database transaction to ensure they are contiguous. This would allow an unlimited number of events to be atomically appended to a single stream in one request.