| From: | xliu19163(at)gmail(dot)com |
|---|---|
| To: | Jan Nidzwetzki <jan(at)planetscale(dot)com>, Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Many of psql's describe functions bloat cache / waste mem |
| Date: | 2026-09-03 02:30:23 |
| Message-ID: | CAPPb3ygskP3wMCw=Erk+rAztX52tC5RY0mpxUJ6MYZMQATuh6Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Jan,
Thanks for testing v2 and for the additional review.
Attached is v3. I split the changes into two patches:
1. Change the applicable object-to-pg_namespace joins from LEFT JOIN to JOIN.
2. Add appendSystemSchemaFilter() and use it in the affected describe queries.
I also wrapped both commit messages at around 75 characters.
I left the pg_toast optimization out of this series, as suggested, so it can
be handled separately without expanding the scope of this patch.
The series is rebased onto current master (792094a5ce8). make check-world
passes for all suites enabled in my local build. TAP tests were not enabled
because IPC::Run is unavailable locally.
Best regards,
Xiaoyu
| Attachment | Content-Type | Size |
|---|---|---|
| v3-0001-psql-use-inner-joins-for-object-namespaces.patch | text/x-patch | 6.4 KB |
| v3-0002-psql-filter-system-objects-before-visibility-chec.patch | text/x-patch | 10.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Guo | 2026-09-03 02:39:34 | Re: Wrong result from JSON constructor in a simple CASE |
| Previous Message | Bharath Rupireddy | 2026-09-03 02:23:00 | Re: Report index currently being vacuumed in pg_stat_progress_vacuum |