| From: | shammat(at)gmx(dot)net |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Does export operation cancel SQLs? |
| Date: | 2025-02-19 11:10:13 |
| Message-ID: | 40fe637f-d3a1-4af5-b100-2e7fedca72bd@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Laurenz Albe schrieb am 19.02.2025 um 09:43:
>> We have PostgreSQL 16 running in GCP cloud SQL. When export job runs we
>> are noticing these messages excessively:
>>
>> db=postgres,user=postgres ERROR: canceling statement due to user request
>>
>> Does Export cancel the SQLs? If not, why are we noticing these messages
>> excessively during the export operation? The load on the instance is minimal.
>
> I am not sure what exactly you mean by "export". A pg_dump?
> But I am not aware of any operation that would cancel statements in other
> sessions. Perhaps someone or something in your application sends cancel
> requests when a statement is running too long, and the concurrent export
> slows down the system.
What if the "export" is done on a read-only replica?
Could this be a "canceling statement due to conflict with recovery" in disguise?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2025-02-19 11:18:42 | Re: Does export operation cancel SQLs? |
| Previous Message | Siraj G | 2025-02-19 10:55:18 | Re: Does export operation cancel SQLs? |