[no subject]

Hi everyone, I just installed Postgres and pg_tle extension as I was looking to contribute to pg_tle. Somehow, I am unable to update the shared_preload_libraries. It feels like ALTER has happened but the SPL value is not updated: > test=# show shared_preload_libraries; >

[no subject]

Peter Eisentraut writes: > Initially, that chapter did not document any system views. Maybe we could make the system views a separate chapter? regards, tom lane

[no subject]

Hi hackers, Recently when looking at the "System Catalogs" Tables of Contents [1], I was wondering why are those headings "Overview" and "System Views" at the same section level as the catalogs/views within them. ~~~ e.g.1. Current: Chapter 53. "System Catalogs" == 53.1. Overview 53.2.

[no subject]

to Dear Hackers, I decided to we need basic e-mail sender in command line when coding somethings and asking one-line questions. Ali KocaFrom 21be4e168fae83bfcd67b219d6e4234a48f0f4f9 Mon Sep 17 00:00:00 2001 From: Ali Koca Date: Fri, 7 Jan 2022 15:28:12 +0300 Subject: [PATCH] sending plain

[no subject]

Hi, hackers I find that ALTER TABLE xxx FORCE/NO FORCE ROW LEVEL SECURITY cannot support tab complete. The attached add the tab complete for rls. diff --git a/src/bin/psql/tab-complete.c b/src/bin/psql/tab-complete.c index 561fe1dff9..b2b4f1fd4d 100644 --- a/src/bin/psql/tab-complete.c +++

[no subject]

We want to export data from PG to Kafka, We can't rely on extension which we have written as there could be any problems which we are not aware of and PG might break. We don't want our master to go down because of the extension we have written. So, we are okay with having a new PG instance whose

[no subject]

Hello, I hear that not recommended to set pg_resetwal with --wal-segsize for wal increasing. Are any more detailed information exists about it? What an effects could be? Does it possible change it due full offline? Regards, Paul

[no subject]

Hello. On 2019/07/29 4:17, Dmitry Dolgov wrote:>> On Thu, Jul 25, 2019 at 1:21 PM Kyotaro Horiguchi wrote: > Yeah, will change both (hopefully soon) Thanks. >> + /* >> + * XXX: In case of index scan quals evaluation happens after >> + * ExecScanFetch, which means

[no subject]

Hi, A system monitoring tool like "nc -vz localhost 5432" to monitor the database server is causing the warning, any way way to filter or ignore messages in postgresql log file LOG: incomplete startup packet Many thanks in advance, Adelino.

[no subject]

Why can not those shared catalog tables take lock via fast path if eligible？ User tables and local catalog tables can take lock via fast path .

[no subject]

G'day all, what is the recommended method to dump the steps[] array of EvalSteps for a compiled expression, showing the opcodes themselves as well as details/arguments for the various opcodes? (I am asking out of curiosity and for teaching purposes.) This must have been done plenty of time

[no subject]

Hi, Compiling with CFLAGS="-ggdb -Og -g3 -fno-omit-frame-pointer" as recommended in https://wiki.postgresql.org/wiki/Developer_FAQ#Compile-time My compiler gives me this message """ logtape.c: In function ‘ltsConcatWorkerTapes’: logtape.c:462:48: warning: ‘tapeblocks’ may be used uninitialized

[no subject]

Walter Cai writes: > Sorry about not including a title at first, I completely forgot! > And thanks for the help, Tom. With respect to the Var: I'm really just > hoping to access the column name Well, you could look that up from the catalogs, or maybe better pull it out of the

[no subject]

Hi, I (a graduate student) am currently trying to modify a postgres instance slightly to incorporate my modified cardinality estimates. In order to run these experiments I'm hoping to access the raw values for selections predicates from within the calc_joinrel_size_estimate method (in