Re: vacuumdb --analyze-only does not need to issue VACUUM (ONLY_DATABASE_STATS) ?

2025-09-22 Thread Mircea Cadariu
Hi, On Tue, Sep 16, 2025 at 5:36 PM Fujii Masao wrote: > Attached is the updated version of the patch. > Thanks for the updated version! LGTM. Kind regards, Mircea Cadariu

Re: [BUG] temporary file usage report with extended protocol and unnamed portals

2025-09-19 Thread Mircea Cadariu
Desc->sourceText; I tried it out and the tests in v12-0002 pass. Kind regards, Mircea Cadariu

Re: [BUG] temporary file usage report with extended protocol and unnamed portals

2025-09-19 Thread Mircea Cadariu
aking the connection not obvious. For example, they will come in handy when simplifying CreatePortal in a separate patch as discussed. Kind regards, Mircea Cadariu

Re: vacuumdb --analyze-only does not need to issue VACUUM (ONLY_DATABASE_STATS) ?

2025-09-16 Thread Mircea Cadariu
, 'vacuumdb --analyze-only skips vacuum'); Kind regards, Mircea Cadariu The new status of this patch is: Waiting on Author

Re: [BUG] temporary file usage report with extended protocol and unnamed portals

2025-09-12 Thread Mircea Cadariu
y for committer in the app. Kind regards, Mircea Cadariu From 268e2a5bac002ed32db4b2b8ab5dc4bb4f64c290 Mon Sep 17 00:00:00 2001 From: "Sami Imseih (AWS)" Date: Fri, 29 Aug 2025 17:19:34 + Subject: [PATCH v10] =?UTF-8?q?Fix=20incorrect=20query=20attribution=20in?= =?UTF-8?q?=20tempora

Re: [BUG] temporary file usage report with extended protocol and unnamed portals

2025-09-08 Thread Mircea Cadariu
he extra portal hashtable lookup as well, or leave that for a separate patch. I gave it a go anyways, see attached v9, let me know what you think. Kind regards, Mircea Cadariu From b2bc429dd0fb4f01920a3bf70a9756cf912f0c56 Mon Sep 17 00:00:00 2001 From: "Sami Imseih (AWS)" Date: Fri,

Re: Add os_page_num to pg_buffercache

2025-08-21 Thread Mircea Cadariu
? Kind regards, Mircea Cadariu [1] https://www.postgresql.org/message-id/flat/CAHg%2BQDcejeLx7WunFT3DX6XKh1KshvGKa8F5au8xVhqVvvQPRw%40mail.gmail.com

Re: Request for Guidance on Reducing PostgreSQL DB Restoration Time

2025-08-10 Thread Mircea Cadariu
/Guide_to_reporting_problems Just off the cuff, you have to find the actual bottleneck first. In case you already have evidence to rule out everything else, you can have a look on this page for some options: https://www.postgresql.org/docs/current/populate.html. Kind regards, Mircea Cadariu

Re: analyze-in-stages post upgrade questions

2025-08-05 Thread Mircea Cadariu
_table/s, + '--analyze_only updates statistics for partitioned tables'); A plain space might be sufficient instead of \s+. Also, I don't think the backslash before ".parent_table" is necessary. Good catch! Indeed let's simplify that to contain strictly only what's necessary. Kind regards, Mircea Cadariu

Re: Add os_page_num to pg_buffercache

2025-07-28 Thread Mircea Cadariu
Hi, Thanks! As the most recent changes are only docs and tests, I did not try out v6 anymore, but just checked the CI result; all green. I've set the status to Ready for Committer. Kind regards, Mircea Cadariu

Re: Add os_page_num to pg_buffercache

2025-07-24 Thread Mircea Cadariu
bove new SELECTs there, instead of in the new pg_buffercache_os_pages.sql? Kind regards, Mircea Cadariu

Re: Metadata and record block access stats for indexes

2025-07-22 Thread Mircea Cadariu
arted a new session? Yes, that's my understanding too. Thanks! Kind regards, Mircea Cadariu

Re: Returning nbtree posting list TIDs in DESC order during backwards scans

2025-07-19 Thread Mircea Cadariu
;ll need to think about issues around adding the new kitem->itemDead bitfield. It's probably not a concern here, but got reminded of this ABI break: https://www.postgresql.org/message-id/flat/CABOikdNmVBC1LL6pY26dyxAS2f%2BgLZvTsNt%3D2XbcyG7WxXVBBQ%40mail.gmail.com Kind regards, Mircea Cadariu

Re: Returning nbtree posting list TIDs in DESC order during backwards scans

2025-07-16 Thread Mircea Cadariu
Kind regards, Mircea Cadariu

Re: Saving stack space in nbtree's _bt_first function

2025-07-16 Thread Mircea Cadariu
/task/5781246762024960 Kind regards, Mircea Cadariu

Re: Saving stack space in nbtree's _bt_first function

2025-07-15 Thread Mircea Cadariu
n once. Kind regards, Mircea Cadariu

Re: analyze-in-stages post upgrade questions

2025-07-11 Thread Mircea Cadariu
On 11/07/2025 10:51, Laurenz Albe wrote: Good idea; done in the attached version 2 of the patch. Thanks! Looks good. I have set the status of the Commitfest entry to "Ready for Committer". Kind regards, Mircea Cadariu

Re: Add os_page_num to pg_buffercache

2025-07-09 Thread Mircea Cadariu
* memory page size 2. Calculate how many OS pages are used by all +* buffer blocks 3. Calculate how many OS pages are contained within +* each database block. +*/ For step number 3 - should it be the other way around: database blocks are contained within OS pages? Kind regards, Mircea Cadariu

Re: Add os_page_num to pg_buffercache

2025-07-08 Thread Mircea Cadariu
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: tested, passed Documentation:tested, passed Hi Bertrand, Just tried out your patch, nice work, thought

Re: analyze-in-stages post upgrade questions

2025-07-07 Thread Mircea Cadariu
rent_table FOR VALUES IN (1);\n" . "INSERT INTO parent_table VALUES (1);\n"); $node->issues_sql_like( [ 'vacuumdb', '--analyze-only', 'postgres' ], qr/statement:\s+ANALYZE\s+public\.parent_table/s, '--analyze_only up

Re: Metadata and record block access stats for indexes

2025-07-04 Thread Mircea Cadariu
. Looking forward to your feedback. Thanks, MirceaFrom d99d1d4d1f39c0068be34fa5c9d0f6efa6c70d2c Mon Sep 17 00:00:00 2001 From: Mircea Cadariu Date: Mon, 30 Jun 2025 08:28:37 +0100 Subject: [PATCH v2] Add metadata (non-leaf) index block statistics to pg_stat functions and system views. This commit co

Metadata and record block access stats for indexes

2025-02-28 Thread Mircea Cadariu
ge-id/flat/CAH2-WzmdZqxCS1widYzjDAM%2BZ-Jz%3DejJoaWXDVw9Qy1UsK0tLA%40mail.gmail.com From a540a042ffb0b348254afdfdce39199900f9c7ec Mon Sep 17 00:00:00 2001 From: Mircea Cadariu Date: Thu, 20 Feb 2025 13:45:12 + Subject: [PATCH v1] Preliminary work to capture and expose separate record (leaf page) an