Search code examples
.netamazon-redshiftnpgsql

Npgsql Pooled Connection Reset With Redshift

In the npgsql docs (https://www.npgsql.org/doc/performance.html?q=DISCARD%20ALL), it says that:-

Connection reset happens via the PostgreSQL DISCARD ALL command

I don't think Redshift has this command so what happens under the covers for a Redshift connection?

Does it simply not work and the pooled connection doesn't get its state reset?

Does it do something else, maybe Redshift-specific?

(I have run with verbose logging and have not seen any logs talking about connection state failing to be reset or errors like "DISCARD statement not found" or something like that)

Solution

  • If I remember correctly, for Redshift Npgsql does not reset the state, since there's no way to do that.