Re: Commitfest app release on Feb 17 with many improvements

2025-02-01 Thread Jelte Fennema-Nio
On Fri, 31 Jan 2025 at 15:23, Jelte Fennema-Nio wrote: > You can try out these changes on the staging environment It seems that someone tried it out, and found a 500 error when searching by Message-ID. That's fixed now. I also fixed some broken links to CirrusCI on the patch page.

Re: Proposal to CREATE FOREIGN TABLE LIKE

2025-02-01 Thread Álvaro Herrera
On 2025-Feb-01, Zhang Mingli wrote: > Our DBA team uses foreign tables for ETL processes in Greenplum and > Cloudberry, > and we often need to create foreign tables that match the column definitions > of local tables. > > When dealing with wide tables and lots of those foreign tables, it can ge

Cross-type index comparison support in contrib/btree_gin

2025-02-01 Thread Tom Lane
We've had multiple requests for $SUBJECT over the years ([1][2][3][4][5], and I'm sure my archive search missed some). I finally decided to look into what it'd take to make that happen. It's not as bad as I feared, and attached is a draft patch. The thing that makes this sticky is that GIN itself

Re: Add a function to get the version of installed extension

2025-02-01 Thread Tom Lane
Yugo Nagata writes: > This might be avoidable if the binary is made carefully to check the existing > of objects, but I think it is useful if an extension module function can check > the current extension version. So, I would like to propose a new function to > return the current extension version

Re: NOT ENFORCED constraint feature

2025-02-01 Thread jian he
hi. after applying the v11-0002 to v11-0006. there is a bug in ATExecAlterConstrRecurse, i think. in ATExecAlterConstrRecurse, after applying the patch, the code is if (currcon->condeferrable != cmdcon->deferrable || currcon->condeferred != cmdcon->initdeferred || currcon->conenforced !=

Re: hash_search_with_hash_value is high in "perf top" on a replica

2025-02-01 Thread Andres Freund
Hi, On 2025-02-01 03:46:33 -0800, Dmitry Koterov wrote: > > It'd be interesting to see what the paths towards > hash_search_with_hash_value > are. > > One of the popular paths is on the screenshot. They are all more or less > the same when recovery_prefetch=on (and when it's off, the replica beha

Re: hash_search_with_hash_value is high in "perf top" on a replica

2025-02-01 Thread Ants Aasma
On Fri, Jan 31, 2025, 15:43 Andres Freund wrote: > > Maybe it's a red herring though, but it looks pretty suspicious. > > It's unfortunately not too surprising - our buffer mapping table is a > pretty > big bottleneck. Both because a hash table is just not a good fit for the > buffer mapping tab

Re: Non-text mode for pg_dumpall

2025-02-01 Thread Srinath Reddy
Hi, i think we have to change the pg_dumpall "--help" message similar to pg_dump's specifying that now pg_dumpall dumps cluster into to other non-text formats. Need similar "--help" message change in pg_restore to specify that now pg_restore supports restoring whole cluster from archive created fro

Re: Proposal to CREATE FOREIGN TABLE LIKE

2025-02-01 Thread Zhang Mingli
Zhang Mingli www.hashdata.xyz On Feb 1, 2025 at 20:20 +0800, Álvaro Herrera , wrote: > > Sure. Did you consider IMPORT FOREIGN SCHEMA? Hi, Álvaro Thank you very much for your suggestion. I've looked into it, and it certainly can be beneficial, especially for  postgres_fdw. However, I believe th

Re: hash_search_with_hash_value is high in "perf top" on a replica

2025-02-01 Thread Andres Freund
Hi, On 2025-02-01 15:43:41 +0100, Ants Aasma wrote: > On Fri, Jan 31, 2025, 15:43 Andres Freund wrote: > > > > Maybe it's a red herring though, but it looks pretty suspicious. > > > > It's unfortunately not too surprising - our buffer mapping table is a > > pretty > > big bottleneck. Both becau

Re: Improving tracking/processing of buildfarm test failures

2025-02-01 Thread Alexander Lakhin
Hello hackers, Please take a look at the January report on buildfarm failures: # SELECT br, count(*) FROM failures WHERE dt >= '2025-01-01' AND  dt < '2025-02-01' GROUP BY br; REL_13_STABLE: 1 REL_14_STABLE: 1 REL_15_STABLE: 4 REL_16_STABLE: 12 REL_17_STABLE: 10 master: 64 -- Total: 92 (Counting

Re: more backtraces

2025-02-01 Thread Andrey Borodin
> On 5 Dec 2019, at 00:45, Peter Eisentraut > wrote: > > <0001-Print-backtrace-on-SIGABRT-SIGBUS-SIGSEGV.patch> Hello! I find this patch very useful when hacking, so let's have a rebased version in archives. And +1 for the feature. The backtrace could help collect diagnostics in case of p

[PATCH] Fix build on MINGW on ARM64

2025-02-01 Thread Lars Kanis
This patch limits the workaround of using __buildin_setjmp on the Windows MINGW platform. This workaround is only necessary for legacy MSVCRT based toolchain, but not for UCRT based. It is not available at all on clang on ARM64 resulting in the following compiler error: error: __builtin_longjmp

Re: Add trim_trailing_whitespace to editorconfig file

2025-02-01 Thread Peter Eisentraut
On 26.12.24 00:52, Jelte Fennema-Nio wrote: On Mon, 7 Oct 2024 at 22:21, Jelte Fennema-Nio wrote: Is this blocked on anything? I feel it's ready to merge at this point. I'd really like to not have this problem with trailing whitespace in sgml files anymore. I noticed Peter added some addition

Re: Make COPY format extendable: Extract COPY TO format implementations

2025-02-01 Thread Sutou Kouhei
Hi, In "Re: Make COPY format extendable: Extract COPY TO format implementations" on Fri, 31 Jan 2025 16:34:52 -0800, Masahiko Sawada wrote: > Again, what I'd like to avoid is that we end up adding everything > (including new fields we add in the future) related to copy operation > to copya