| From: | Anthonin Bonnefoy <anthonin(dot)bonnefoy(at)datadoghq(dot)com> |
|---|---|
| To: | Jelte Fennema-Nio <postgres(at)jeltef(dot)nl> |
| Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Add Pipelining support in psql |
| Date: | 2024-12-10 10:43:50 |
| Message-ID: | CAO6_XqrDPpaHqvKA0r8kfuHBE8BZ5ZqWLwucu30cXobeGtvBMA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
An improved version with simplifications and refinements.
num_queries (2nd element in the pipeline status prompt) is now used to
track queued queries that were not flushed (with a flush request or
sync) to the server. It used to count both unflushed queries and
flushed queries.
Code in ExecQueryAndProcessResults should be simpler now.
- DiscardAbortedPipelineResults function handles both discarding of
results until a synchronisation point is reached or discarding of
results until there's no more pending results.
- The logic to process the pipeline's results and getting the next
results fit more with the existing flow.
- Tests didn't cover chunk results so I've added additional tests to
cover use of pipelining + FETCH_COUNT
| Attachment | Content-Type | Size |
|---|---|---|
| v04-0001-Add-pipelining-support-in-psql.patch | application/octet-stream | 48.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Victor Yegorov | 2024-12-10 10:59:33 | Re: Proposal to add a new URL data type. |
| Previous Message | Bernd Helmle | 2024-12-10 10:20:00 | Re: [PATCH] Add sortsupport for range types and btree_gist |