For example, a PostgreSQL integer column can now be read as follows: var array = reader.GetFieldValue(0) It is now possible to read PostgreSQL arrays as CLR arrays of nullable value types.

Support for arrays of nullable value types Full documentation will be available soon.Īll Npgsql APIs are now fully annotated for C# nullable references ( #3120), in line with the new annotations in System.Data released in. Multiplexing is disabled by default, is considered experimental and must be explicitly opted into. A potentially substantial performance boost on the TechEmpower benchmark (next round to be published).Continued uptime even when the maximum allowed connection count has been reached.Significant reduction to the number of required PostgreSQL physical connection requirements, and removing load from the server.This is a much more efficient use of connections, which can lead to: Multiplexing is an experimental new way for the driver to handle commands and connections: user code no longer receives an exclusive physical connection from Npgsql's internal pool, but rather submits commands to be executed on any available connection. Thanks to for all their valuable work on this! Previous support was inconsistent across cancellation and timeout, and async I/O was only partially supported. Npgsql forcibly closes the physical connection and raises an exception, making sure the application isn't blocked. If PostgreSQL cancellation isn't successful within a short time window, the network is likely down.In previous versions, queries were sometimes left running on the server. If successful, PostgreSQL immediately stops processing the command and is free to do other work. Contact PostgreSQL and attempt to cancel the running command.When the user requests cancellation (via a cancellation token or NpgsqlCommand.Cancel()), or when the Command Timeout expires, Npgsql now takes the following steps: Issue: #1520 Improved support for cancellation and timeout This major feature was developed by many thanks! It can be used for auditing purposes, continuously exporting certain (or all) changes to another database or format, or various other purposes. PostgreSQL replication creating programs which receive a continuous, live stream of all updates happening in a PostgreSQL database or set of tables. PostgreSQL logical and physical replication The full list of issues for this release is available here.

Xshell 5 multiplexing