Raimon Fernandez <coder@xxxxxxxxx> writes: > Quoted from the documentation: > "The cancellation signal might or might not have any effect â?? for > example, if it arrives after the > backend has ï¬?nished processing the query, then it will have no > effect. > Here I understand that maybe it will have NO effect, so postgresql > will still sending rows and rows and rows ... If you're too late, the backend has already sent all the rows. There's not much we can do about data that's already in flight. There probably won't be that much of it though, as TCP stacks don't buffer infinite amounts of data. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
