he temporary storage
and switch so that the "old" query is in the picture strictly as minimum
as necessary.
Kind regards,
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
Desc->sourceText;
I tried it out and the tests in v12-0002 pass.
Kind regards,
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
,
'vacuumdb --analyze-only skips vacuum');
Kind regards,
Mircea Cadariu
The new status of this patch is: Waiting on Author
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
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,
?
Kind regards,
Mircea Cadariu
[1]
https://www.postgresql.org/message-id/flat/CAHg%2BQDcejeLx7WunFT3DX6XKh1KshvGKa8F5au8xVhqVvvQPRw%40mail.gmail.com
/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
_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
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
bove new SELECTs there, instead of in the new pg_buffercache_os_pages.sql?
Kind regards,
Mircea Cadariu
arted a new session?
Yes, that's my understanding too.
Thanks!
Kind regards,
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
Kind regards,
Mircea Cadariu
/task/5781246762024960
Kind regards,
Mircea Cadariu
n once.
Kind regards,
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
* 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
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
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
.
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
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
23 matches
Mail list logo
