Re: TAP output format in pg_regress

2023-01-03 Thread vignesh C
On Tue, 29 Nov 2022 at 00:57, Daniel Gustafsson wrote: > > > On 28 Nov 2022, at 20:02, Nikolay Shaplov wrote: > > > From my reviewer's point of view patch is ready for commit. > > > > Thank you for your patience :-) > > Thanks for review. > > The attached tweaks a few comments and attempts to add

Re: Add BufFileRead variants with short read and EOF detection

2023-01-03 Thread vignesh C
On Wed, 28 Dec 2022 at 16:17, Peter Eisentraut wrote: > > Most callers of BufFileRead() want to check whether they read the full > specified length. Checking this at every call site is very tedious. > This patch provides additional variants BufFileReadExact() and > BufFileReadMaybeEOF() that incl

Re: Add SHELL_EXIT_CODE to psql

2023-01-03 Thread vignesh C
On Wed, 21 Dec 2022 at 11:04, Corey Huinker wrote: > > I've rebased and updated the patch to include documentation. > > Regression tests have been moved to a separate patchfile because error > messages will vary by OS and configuration, so we probably can't do a stable > regression test, but hav

Re: [Proposal] Add foreign-server health checks infrastructure

2023-01-03 Thread vignesh C
On Tue, 20 Dec 2022 at 07:22, Hayato Kuroda (Fujitsu) wrote: > > Dear hackers, > > PSA rebased patches. The patch does not apply on top of HEAD as in [1], please post a rebased patch: === Applying patches on top of PostgreSQL commit ID 92957ed98c5c565362ce665266132a7f08f6b0c0 === === applying pa

Re: Add last_vacuum_index_scans in pg_stat_all_tables

2023-01-03 Thread vignesh C
On Tue, 4 Oct 2022 at 10:20, Ken Kato wrote: > > > The problem is that you're not closing the > > Thank you for the reviews and comments. > I closed the so that the problem should be fixed now. The patch does not apply on top of HEAD as in [1], please post a rebased patch: === Applying patches

Re: Add index scan progress to pg_stat_progress_vacuum

2023-01-03 Thread vignesh C
On Mon, 2 Jan 2023 at 10:04, Imseih (AWS), Sami wrote: > > >cfbot is complaining that this patch no longer applies. Sami, would you > >mind rebasing it? > > Rebased patch attached. CFBot shows some compilation errors as in [1], please post an updated version for the same: [07:01:58.889]

Re: Add the ability to limit the amount of memory that can be allocated to backends.

2023-01-03 Thread vignesh C
On Fri, 9 Dec 2022 at 20:41, Reid Thompson wrote: > > On Tue, 2022-12-06 at 10:32 -0800, Andres Freund wrote: > > Hi, > > > > On 2022-11-26 22:22:15 -0500, Reid Thompson wrote: > > > rebased/patched to current master && current pg-stat-activity- > > > backend-memory-allocated > > > > This version

Re: Add tracking of backend memory allocated to pg_stat_activity

2023-01-03 Thread vignesh C
On Thu, 8 Dec 2022 at 19:44, Reid Thompson wrote: > > On Sun, 2022-11-27 at 09:40 -0600, Justin Pryzby wrote: > > > BTW, these should have some kind of prefix, like PG_ALLOC_* to > > > avoid causing the same kind of problem for someone else that > > > another header caused for you by defining some

Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions

2023-01-03 Thread vignesh C
On Tue, 20 Dec 2022 at 04:27, Corey Huinker wrote: > > > Attached is my work in progress to implement the changes to the CAST() > function as proposed by Vik Fearing. > > This work builds upon the Error-safe User Functions work currently ongoing. > > The proposed changes are as follows: > > CAST(

Re: [PATCH] CF app: add "Returned: Needs more interest"

2023-01-03 Thread vignesh C
On Wed, 26 Oct 2022 at 04:25, Jacob Champion wrote: > > On Mon, Aug 8, 2022 at 8:45 AM Andres Freund wrote: > > On 2022-08-08 08:37:41 -0700, Jacob Champion wrote: > > > Agreed. This probably bleeds over into the other documentation thread > > > a bit -- how do we want to communicate the subtle p

Re: CI and test improvements

2023-01-03 Thread vignesh C
On Fri, 30 Dec 2022 at 09:29, Thomas Munro wrote: > > On Wed, Nov 23, 2022 at 11:57 AM Justin Pryzby wrote: > > [PATCH 02/10] cirrus/macos: switch to "macos_instance" / M1.. > > Duelling patches. > > Bilal's patch[1] uses the matrix feature to run the tests on both > Intel and ARM, which made sen

Re: Cygwin cleanup

2023-01-03 Thread vignesh C
On Wed, 9 Nov 2022 at 06:34, Justin Pryzby wrote: > > On Thu, Oct 20, 2022 at 10:40:40PM -0500, Justin Pryzby wrote: > > On Thu, Aug 04, 2022 at 04:16:06PM +1200, Thomas Munro wrote: > > > On Thu, Aug 4, 2022 at 3:38 PM Justin Pryzby wrote: > > > > [train wreck] > > > > > > Oh my, so I'm getting

Re: [PATCH] Expand character set for ltree labels

2023-01-03 Thread vignesh C
On Thu, 6 Oct 2022 at 03:35, Garen Torikian wrote: > > After digging into it, you are completely correct. I had to do a bit more > reading to understand the relationships between UTF-8 and wchar, but > ultimately the existing locale support works for my use case. > > Therefore I have updated the

Re: [PATCH]Feature improvement for MERGE tab completion

2023-01-03 Thread vignesh C
On Wed, 21 Sept 2022 at 10:55, Fujii Masao wrote: > > > > On 2022/09/21 0:51, Alvaro Herrera wrote: > > The rules starting at line 4111 make me a bit nervous, since nowhere > > we're restricting them to operating only on MERGE lines. I don't think > > it's a real problem since USING is not terrib

Re: MultiXact\SLRU buffers configuration

2023-01-03 Thread vignesh C
On Fri, 19 Aug 2022 at 21:18, wrote: > > Andrey Borodin wrote 2022-08-18 06:35: > > > > I like the idea of one knob instead of one per each SLRU. Maybe we > > even could deduce sane value from NBuffers? That would effectively > > lead to 0 knobs :) > > > > Your patch have a prefix "v22-0006", does

Re: SLRUs in the main buffer pool - Page Header definitions

2023-01-03 Thread vignesh C
On Fri, 16 Dec 2022 at 04:47, Bagga, Rishu wrote: > Rebased and updated a new patch addressing the critical section issue in > RecordNewMultliXact.In GetNewMultiXactId, we now make our ReadBuffer > calls before starting the critical section, but while holding the > MultiXactGenLock, so we always f

Re: moving extraUpdatedCols out of RangeTblEntry (into ModifyTable)

2023-01-03 Thread vignesh C
On Thu, 8 Dec 2022 at 08:17, Amit Langote wrote: > > On Wed, Dec 7, 2022 at 8:54 PM Amit Langote wrote: > > Per Alvaro's advice, forking this from [1]. > > > > In that thread, Tom had asked if it wouldn't be better to find a new > > place to put extraUpdatedCols [2] instead of RangeTblEntry, alon

Re: [PATCH] New [relation] option engine

2023-01-03 Thread vignesh C
On Sun, 20 Nov 2022 at 11:42, Nikolay Shaplov wrote: > > В письме от воскресенье, 6 ноября 2022 г. 19:22:09 MSK пользователь Nikolay > Shaplov написал: > > > > > > cfbot reports the patch no longer applies. As CommitFest 2022-11 is > > > > > currently underway, this would be an excellent time to

Re: Optimizing Node Files Support

2023-01-03 Thread vignesh C
On Fri, 2 Dec 2022 at 19:06, Ranier Vilela wrote: > > Hi, thanks for reviewing this. > > Em sex., 2 de dez. de 2022 às 09:24, John Naylor > escreveu: >> >> >> On Thu, Dec 1, 2022 at 8:02 PM Ranier Vilela wrote: >> > >> > Hi, >> > >> > I believe that has room for improving generation node files.

Re: [PATCH] CF app: add "Returned: Needs more interest"

2023-01-03 Thread vignesh C
On Tue, 3 Jan 2023 at 22:01, Jacob Champion wrote: > > On Tue, Jan 3, 2023 at 4:14 AM vignesh C wrote: > > The patch does not apply on top of HEAD as in [1], please post a rebased > > patch: > > Hi Vignesh -- this is a patch for the CF app, not the Postgres repo, >

Re: [DOCS] Stats views and functions not in order?

2023-01-03 Thread vignesh C
On Mon, 2 Jan 2023 at 13:47, Peter Eisentraut wrote: > > On 08.12.22 03:30, Peter Smith wrote: > > PSA patches for v9* > > > > v9-0001 - Now the table rows are ordered per PeterE's suggestions [1] > > committed > > > v9-0002 - All the review comments from DavidJ [2] are addressed > > I'm not sure

Re: POC: Lock updated tuples in tuple_update() and tuple_delete()

2023-01-04 Thread vignesh C
On Fri, 1 Jul 2022 at 16:49, Alexander Korotkov wrote: > > Hackers, > > When working in the read committed transaction isolation mode > (default), we have the following sequence of actions when > tuple_update() or tuple_delete() find concurrently updated tuple. > > 1. tuple_update()/tuple_delete()

Re: Parallelize correlated subqueries that execute within each worker

2023-01-04 Thread vignesh C
On Tue, 27 Sept 2022 at 08:26, James Coleman wrote: > > On Mon, Mar 21, 2022 at 8:48 PM Andres Freund wrote: > > > > Hi, > > > > On 2022-01-22 20:25:19 -0500, James Coleman wrote: > > > On the other hand this is a dramatically simpler patch series. > > > Assuming the approach is sound, it should

Re: Pluggable toaster

2023-01-04 Thread vignesh C
On Tue, 27 Dec 2022 at 02:32, Nikita Malakhov wrote: > > Hi hackers! > > Pluggable TOAST API with catalog control table PG_TOASTREL - pre-patch. > > Pluggable TOAST - TOAST API rework - introduce PG_TOASTREL catalog > relation containing TOAST dependencies. NOTE: here is a pre-patch, n

Re: Prefetch the next tuple's memory during seqscans

2023-01-04 Thread vignesh C
On Wed, 23 Nov 2022 at 03:28, David Rowley wrote: > > On Thu, 3 Nov 2022 at 06:25, Andres Freund wrote: > > Attached is an experimental patch/hack for that. It ended up being more > > beneficial to make the access ordering more optimal than prefetching the > > tuple > > contents, but I'm not at

Re: WIP: Aggregation push-down - take2

2023-01-04 Thread vignesh C
On Thu, 17 Nov 2022 at 16:34, Antonin Houska wrote: > > Tomas Vondra wrote: > > > Hi, > > > > I did a quick initial review of the v20 patch series. I plan to do a > > more thorough review over the next couple days, if time permits. In > > general I think the patch is in pretty good shape. > > Tha

Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?

2023-01-04 Thread vignesh C
On Tue, 3 Jan 2023 at 14:08, David Geier wrote: > > Hi Lukas, > > On 1/2/23 20:50, Lukas Fittl wrote: > > Thanks for continuing to work on this patch, and my apologies for > > silence on the patch. > > It would be great if you could review it. > Please also share your thoughts around exposing the

Re: on placeholder entries in view rule action query's range table

2023-01-04 Thread vignesh C
On Fri, 9 Dec 2022 at 12:20, Amit Langote wrote: > > On Fri, Dec 9, 2022 at 3:07 PM Amit Langote wrote: > > On Thu, Dec 8, 2022 at 6:12 PM Alvaro Herrera > > wrote: > > > On 2022-Dec-07, Amit Langote wrote: > > > > However, this > > > > approach of not storing the placeholder in the stored rule

Re: Understanding, testing and improving our Windows filesystem code

2023-01-04 Thread vignesh C
On Tue, 25 Oct 2022 at 09:42, Thomas Munro wrote: > > I pushed the bug fixes from this series, without their accompanying > tests. Here's a rebase of the test suite, with all those tests now > squashed into the main test patch, and also the > tell-Windows-to-be-more-like-Unix patch. Registered i

Re: Using AF_UNIX sockets always for tests on Windows

2023-01-04 Thread vignesh C
On Fri, 2 Dec 2022 at 18:08, Andrew Dunstan wrote: > > > On 2022-12-01 Th 21:10, Andres Freund wrote: > > Hi, > > > > On 2022-12-01 20:56:18 -0500, Tom Lane wrote: > >> Andres Freund writes: > >>> On 2022-12-01 20:30:36 -0500, Tom Lane wrote: > If we remove that, won't we have a whole lot of

Re: making relfilenodes 56 bits

2023-01-04 Thread vignesh C
On Fri, 21 Oct 2022 at 11:31, Michael Paquier wrote: > > On Thu, Sep 29, 2022 at 09:23:38PM -0400, Tom Lane wrote: > > Hmmm ... I'd tend to do SELECT COUNT(*) FROM. But can't we provide > > any actual checks on the sanity of the output? I realize that the > > output's far from static, but still

Re: postgres_fdw: commit remote (sub)transactions in parallel during pre-commit

2023-01-04 Thread vignesh C
On Tue, 1 Nov 2022 at 15:54, Etsuro Fujita wrote: > > Hi David, > > On Sat, Oct 1, 2022 at 5:54 AM David Zhang wrote: > > After rebase the file `postgres_fdw.out` and applied to master branch, > > make and make check are all ok for postgres_fdw. > > Thanks for testing! Attached is a rebased vers

Re: Logical replication - schema change not invalidating the relation cache

2023-01-05 Thread vignesh C
On Thu, 5 Jan 2023 at 03:17, Tom Lane wrote: > > vignesh C writes: > > [ v3-0001-Fix-for-invalidating-logical-replication-relation.patch ] > > (btw, please don't send multiple patch versions with the same number, > it's very confusing.) Since it was just reb

Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE

2023-01-05 Thread vignesh C
On Thu, 5 Jan 2023 at 18:22, Dean Rasheed wrote: > > On Tue, 6 Dec 2022 at 19:12, vignesh C wrote: > > > > On Tue, 6 Dec 2022 at 20:42, Melih Mutlu wrote: > > > > > > Also one little suggestion: > > > > > >> + if (ends_with(prev_wd, '

Re: Logical replication - schema change not invalidating the relation cache

2023-01-05 Thread vignesh C
On Fri, 6 Jan 2023 at 04:32, Tom Lane wrote: > > vignesh C writes: > > On Thu, 5 Jan 2023 at 03:17, Tom Lane wrote: > >> The bigger picture here though is that in examples such as the one > >> you gave at the top of the thread, it's not very clear to me

Re: TAP output format in pg_regress

2023-01-05 Thread vignesh C
On Tue, 3 Jan 2023 at 16:01, vignesh C wrote: > > On Tue, 29 Nov 2022 at 00:57, Daniel Gustafsson wrote: > > > > > On 28 Nov 2022, at 20:02, Nikolay Shaplov wrote: > > > > > From my reviewer's point of view patch is ready for commit. > > > &g

Re: [PATCH] Expand character set for ltree labels

2023-01-05 Thread vignesh C
On Wed, 4 Jan 2023 at 00:27, Garen Torikian wrote: > > Sure. Rebased onto HEAD. > There is one more merge conflict, please post a rebased patch: === Applying patches on top of PostgreSQL commit ID eb5ad4ff05fd382ac98cab60b82f7fd6ce4cfeb8 === === applying patch ./0003-Expand-character-set-for-ltr

Re: Add a new pg_walinspect function to extract FPIs from WAL records

2023-01-05 Thread vignesh C
On Thu, 5 Jan 2023 at 18:52, Bharath Rupireddy wrote: > > On Wed, Jan 4, 2023 at 8:19 PM Drouvot, Bertrand > wrote: > > > > I think it makes sense to somehow align the pg_walinspect functions with > > the pg_waldump "features". > > And since [1] added FPI "extraction" then +1 for the proposed pa

Re: Force streaming every change in logical decoding

2023-01-05 Thread vignesh C
On Mon, 26 Dec 2022 at 14:04, Amit Kapila wrote: > > On Sat, Dec 24, 2022 at 3:28 PM Dilip Kumar wrote: > > > > On Sat, Dec 24, 2022 at 8:56 AM Amit Kapila wrote: > > > > > > > > > > > > > OK, I removed the modification in 022_twophase_cascade.pl and combine > > > > > the two patches. > > > > >

Re: Generating code for query jumbling through gen_node_support.pl

2023-01-05 Thread vignesh C
On Wed, 7 Dec 2022 at 13:27, Michael Paquier wrote: > > Hi all, > > This thread is a follow-up of the recent discussion about query > jumbling with DDL statements, where the conclusion was that we'd want > to generate all this code automatically for all the nodes: > https://www.postgresql.org/mess

Re: A new strategy for pull-up correlated ANY_SUBLINK

2023-01-05 Thread vignesh C
On Sun, 13 Nov 2022 at 04:15, Tom Lane wrote: > > Andy Fan writes: > > In the past we pull-up the ANY-sublink with 2 steps, the first step is to > > pull up the sublink as a subquery, and the next step is to pull up the > > subquery if it is allowed. The benefits of this method are obvious, > >

Re: refactoring relation extension and BufferAlloc(), faster COPY

2023-01-05 Thread vignesh C
On Sat, 29 Oct 2022 at 08:24, Andres Freund wrote: > > The patches here aren't fully polished (as will be evident). But they should > be more than good enough to discuss whether this is a sane direction. The patch does not apply on top of HEAD as in [1], please post a rebased patch: === Applying

Re: Moving forward with TDE

2023-01-05 Thread vignesh C
On Fri, 4 Nov 2022 at 03:36, David Christensen wrote: > > > Unless somebody in the community remembers open questions/issues with > > TDE that were never addressed I suggest simply iterating with our > > usual testing/reviewing process. For now I'm going to change the > > status of the CF entry [1

Re: [PATCH] psql: Add tab-complete for optional view parameters

2023-01-06 Thread vignesh C
On Fri, 9 Dec 2022 at 16:01, Christoph Heiss wrote: > > Thanks for the review! > > On 12/8/22 12:19, Melih Mutlu wrote: > > Hi Christoph, > > > > I just took a quick look at your patch. > > Some suggestions: > > > > + else if (Matches("ALTER", "VIEW", MatchAny, "SET", "(")) > > + C

Re: [PATCH] Add function to_oct

2023-01-07 Thread vignesh C
On Thu, 22 Dec 2022 at 23:11, Eric Radman wrote: > > On Thu, Dec 22, 2022 at 10:08:17AM +, Dag Lem wrote: > > > > The calculation of quotient and remainder can be replaced by less costly > > masking and shifting. > > > > Defining > > > > #define OCT_DIGIT_BITS 3 > > #define OCT_DIGIT_BITMASK

Re: Improve tab completion for ALTER FUNCTION/PROCEDURE/ROUTINE

2023-01-07 Thread vignesh C
On Fri, 6 Jan 2023 at 15:33, Dean Rasheed wrote: > > On Fri, 6 Jan 2023 at 02:38, vignesh C wrote: > > > > On Thu, 5 Jan 2023 at 18:22, Dean Rasheed wrote: > > > > > > That leads to the attached, which barring objections, I'll push shortly. > >

Re: [BUG] Logical replica crash if there was an error in a function.

2023-01-07 Thread vignesh C
On Sun, 11 Dec 2022 at 09:21, Anton A. Melnikov wrote: > > > On 07.12.2022 21:03, Andres Freund wrote: > > > > > This CF entry causes tests to fail on all platforms: > > https://cirrus-ci.com/build/5755408111894528 > > > > E.g. > > https://api.cirrus-ci.com/v1/artifact/task/5298457144459264/testru

Re: [Commitfest 2023-01] has started

2023-01-08 Thread vignesh C
On Tue, 3 Jan 2023 at 13:13, vignesh C wrote: > > Hi All, > > Just a reminder that Commitfest 2023-01 has started. > There are many patches based on the latest run from [1] which require > a) Rebased on top of head b) Fix compilation failures c) Fix test > failure, please h

Re: doc: add missing "id" attributes to extension packaging page

2023-01-08 Thread vignesh C
On Wed, 4 Jan 2023 at 04:13, Karl O. Pinc wrote: > > On Tue, 3 Jan 2023 21:35:09 +0100 > Brar Piening wrote: > > > On 02.01.2023 at 21:53, Karl O. Pinc wrote: > > > If the author will look over my version of the patch I believe it > > > can be approved and sent on to the committers. > > > > LGTM.

Re: doc: add missing "id" attributes to extension packaging page

2023-01-08 Thread vignesh C
On Mon, 9 Jan 2023 at 08:01, vignesh C wrote: > > On Wed, 4 Jan 2023 at 04:13, Karl O. Pinc wrote: > > > > On Tue, 3 Jan 2023 21:35:09 +0100 > > Brar Piening wrote: > > > > > On 02.01.2023 at 21:53, Karl O. Pinc wrote: > > > > If the author

Re: Allow tailoring of ICU locales with custom rules

2023-01-10 Thread vignesh C
On Thu, 5 Jan 2023 at 20:45, Peter Eisentraut wrote: > > Patch needed a rebase; no functionality changes. The patch does not apply on top of HEAD as in [1], please post a rebased patch: === Applying patches on top of PostgreSQL commit ID d952373a987bad331c0e499463159dd142ced1ef === === applying

Re: Add SHELL_EXIT_CODE to psql

2023-01-10 Thread vignesh C
On Tue, 10 Jan 2023 at 00:06, Corey Huinker wrote: > > On Mon, Jan 9, 2023 at 10:01 AM Maxim Orlov wrote: >> >> Hi! >> >> In overall, I think we move in the right direction. But we could make code >> better, should we? >> >> + /* Capture exit code for SHELL_EXIT_CODE */ >> +

Re: Time delayed LR (WAS Re: logical replication restrictions)

2023-01-11 Thread vignesh C
On Tue, 10 Jan 2023 at 19:41, Takamichi Osumi (Fujitsu) wrote: > > On Tuesday, January 3, 2023 4:01 PM vignesh C wrote: > Hi, thanks for your review ! > > Please have a look at the updated patch. Thanks for the updated patch, few comments: 1) Comment inconsistency across c

Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)

2023-01-11 Thread vignesh C
On Tue, 10 Jan 2023 at 02:41, Melanie Plageman wrote: > > Attached is v45 of the patchset. I've done some additional code cleanup > and changes. The most significant change, however, is the docs. I've > separated the docs into its own patch for ease of review. > > The docs patch here was edited an

Re: Allow logical replication to copy tables in binary format

2023-01-11 Thread vignesh C
On Wed, 11 Jan 2023 at 16:14, Melih Mutlu wrote: > > Hi, > > Thanks for your review. > > shiy.f...@fujitsu.com , 11 Oca 2023 Çar, 11:56 > tarihinde şunu yazdı: >> >> On Mon, Nov 14, 2022 8:08 PM Melih Mutlu wrote: >> 1. >> +# Binary enabled subscription should fail >> +$node_subscriber_binary->w

Re: Rework of collation code, extensibility

2023-01-11 Thread vignesh C
On Thu, 22 Dec 2022 at 11:11, Jeff Davis wrote: > > On Sat, 2022-12-17 at 19:14 -0800, Jeff Davis wrote: > > Attached is a new patch series. I think there are enough changes that > > this has become more of a "rework" of the collation code rather than > > just a refactoring. This is a continuation

Re: GUC for temporarily disabling event triggers

2023-01-11 Thread vignesh C
On Tue, 29 Nov 2022 at 18:16, Daniel Gustafsson wrote: > > > On 3 Nov 2022, at 21:47, Daniel Gustafsson wrote: > > > The patch adds a new GUC, ignore_event_trigger with two option values, 'all' > > and 'none' (the login event patch had 'login' as well). > > The attached v2 fixes a small bug which

Re: Transparent column encryption

2023-01-11 Thread vignesh C
On Sat, 31 Dec 2022 at 19:47, Peter Eisentraut wrote: > > On 21.12.22 06:46, Peter Eisentraut wrote: > > And another update. The main changes are that I added an 'unspecified' > > CMK algorithm, which indicates that the external KMS knows what it is > > but the database system doesn't. This was

Re: [PATCH] pgbench: add multiconnect option

2023-01-11 Thread vignesh C
On Tue, 8 Nov 2022 at 02:16, Fabien COELHO wrote: > > > Hello Ian, > > > cfbot reports the patch no longer applies. As CommitFest 2022-11 is > > currently underway, this would be an excellent time to update the patch. > > Attached a v5 which is just a rebase. The patch does not apply on top of H

Re: [PATCH] psql: Add tab-complete for optional view parameters

2023-01-11 Thread vignesh C
On Fri, 9 Dec 2022 at 16:01, Christoph Heiss wrote: > > Thanks for the review! > > On 12/8/22 12:19, Melih Mutlu wrote: > > Hi Christoph, > > > > I just took a quick look at your patch. > > Some suggestions: > > > > + else if (Matches("ALTER", "VIEW", MatchAny, "SET", "(")) > > + C

Re: mprove tab completion for ALTER EXTENSION ADD/DROP

2023-01-11 Thread vignesh C
On Wed, 11 Jan 2023 at 12:19, Michael Paquier wrote: > > On Wed, Jan 11, 2023 at 12:10:33PM +0900, Kyotaro Horiguchi wrote: > > It suggests the *kinds* of objects that are part of the extension, but > > lists the objects of that kind regardless of dependency. I read > > Michael suggested (and I a

Re: mprove tab completion for ALTER EXTENSION ADD/DROP

2023-01-12 Thread vignesh C
On Thu, 12 Jan 2023 at 05:22, Michael Paquier wrote: > > On Wed, Jan 11, 2023 at 10:29:25PM +0530, vignesh C wrote: > > I too felt keeping it simpler is better. How about using the simple > > first version of patch itself? > > Okay, I have just done that, then, after chec

Re: Time delayed LR (WAS Re: logical replication restrictions)

2023-01-13 Thread vignesh C
On Thu, 12 Jan 2023 at 21:09, Takamichi Osumi (Fujitsu) wrote: > > On Thursday, January 12, 2023 12:04 PM Kyotaro Horiguchi > wrote: > > At Wed, 11 Jan 2023 12:46:24 +, "Hayato Kuroda (Fujitsu)" > > wrote in > > > them. Which version is better? > > > > > > Some comments by a quick loock, di

Re: Operation log for major operations

2023-01-13 Thread vignesh C
On Mon, 5 Dec 2022 at 13:42, Dmitry Koval wrote: > > Hi! > > >I think storing this in pg_control is a bad idea. That file is > >extremely critical and if you break it, you're pretty much SOL on > >recovering your data. I suggest that this should use a separate file. > > Thanks. Operation log

Re: Pluggable toaster

2023-01-13 Thread vignesh C
On Sun, 8 Jan 2023 at 01:40, Nikita Malakhov wrote: > > Hi! > > Thank you for your attention. > I've rebased the patchset onto the latest master (from 07.01), but the second > part is still > in pre-patch shape - it is working, but tests are failing due to changes in > TOAST relations > logic -

Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?

2023-01-13 Thread vignesh C
On Wed, 4 Jan 2023 at 17:32, David Geier wrote: > > I fixed the compilation error on CFBot. > I missed adding instr_time.c to the Meson makefile. > New patch set attached. The patch does not apply on top of HEAD as in [1], please post a rebased patch: === Applying patches on top of PostgreSQL com

Re: Removing redundant grouping columns

2023-01-13 Thread vignesh C
On Sat, 31 Dec 2022 at 02:32, Tom Lane wrote: > > I wrote: > > Richard Guo writes: > >> While we are here, I wonder if we can do the same trick for > >> distinctClause, to cope with cases like > >> select distinct a.x, b.y from a, b where a.x = b.y; > > > We do that already, no? > > Oh, wait, I s

Re: fixing CREATEROLE

2023-01-13 Thread vignesh C
On Tue, 10 Jan 2023 at 23:16, Robert Haas wrote: > > On Thu, Jan 5, 2023 at 2:53 PM Robert Haas wrote: > > On Tue, Jan 3, 2023 at 3:11 PM Robert Haas wrote: > > > Committed and back-patched 0001 with fixes for the issues that you > > > pointed out. > > > > > > Here's a trivial rebase of the res

Re: fixing CREATEROLE

2023-01-14 Thread vignesh C
On Sun, 15 Jan 2023 at 06:02, Robert Haas wrote: > > On Sat, Jan 14, 2023 at 2:26 AM vignesh C wrote: > > I'm not sure if any work is left here, if there is nothing more to do, > > can we close this? > > There's a discussion on another thread about some follow-u

Re: [Commitfest 2023-01] has started

2023-01-15 Thread vignesh C
On Sun, 8 Jan 2023 at 21:00, vignesh C wrote: > > On Tue, 3 Jan 2023 at 13:13, vignesh C wrote: > > > > Hi All, > > > > Just a reminder that Commitfest 2023-01 has started. > > There are many patches based on the latest run from [1] which require > > a)

Re: Support logical replication of DDLs

2023-01-15 Thread vignesh C
On Sun, 15 Jan 2023 at 09:39, Ajin Cherian wrote: > > On Fri, Jan 13, 2023 at 5:33 PM vignesh C wrote: > > Adding support for CREATE/ALTER/DROP Publication ddl deparsing. > > The attached v61 patch has the changes for the same. > > > > Hi Vignesh, > this does

Re: Adding CommandID to heap xlog records

2023-01-16 Thread vignesh C
On Thu, 3 Nov 2022 at 15:06, Ian Lawrence Barwick wrote: > > 2022年9月30日(金) 1:04 Matthias van de Meent : > > > > On Wed, 28 Sept 2022 at 19:40, Bruce Momjian wrote: > > > > > > On Thu, Sep 22, 2022 at 11:12:32PM +0200, Matthias van de Meent wrote: > > > > On Thu, 8 Sept 2022 at 23:24, Tom Lane wr

Re: Allow parallel plan for referential integrity checks?

2023-01-16 Thread vignesh C
On Mon, 12 Dec 2022 at 22:06, Frédéric Yhuel wrote: > > > > On 12/11/22 06:29, Ian Lawrence Barwick wrote: > > 2022年7月26日(火) 20:58 Frédéric Yhuel : > >> > >> > >> > >> On 4/14/22 14:25, Frédéric Yhuel wrote: > >>> > >>> > >>> On 3/19/22 01:57, Imseih (AWS), Sami wrote: > I looked at your patc

Re: [PATCH] Completed unaccent dictionary with many missing characters

2023-01-16 Thread vignesh C
On Fri, 4 Nov 2022 at 04:59, Ian Lawrence Barwick wrote: > > 2022年7月13日(水) 19:13 Przemysław Sztoch : > > > > Dear Michael P., > > > > 3. The matter is not that simple. When I change priorities (ie > > Latin-ASCII.xml is less important than Unicode decomposition), > > then "U + 33D7" changes not t

Re: [PATCH] Fix alter subscription concurrency errors

2023-01-16 Thread vignesh C
On Wed, 12 Oct 2022 at 10:48, Michael Paquier wrote: > > On Fri, Sep 09, 2022 at 06:37:07PM +0200, Alvaro Herrera wrote: > > Would it work to use get_object_address() instead? That would save > > having to write a lookup-and-lock function with a retry loop for each > > object type. > > Jeite, thi

Re: xml2: add test for coverage

2023-01-17 Thread vignesh C
On Fri, 25 Nov 2022 at 18:08, Peter Eisentraut wrote: > > On 23.08.22 03:38, Dong Wook Lee wrote: > > I made a small patch for xml2 to improve test coverage. > > However, there was a problem using the functions below. > > > > - xpath_number > > - xpath_bool > > - xpath_nodeset > > - xpath_list > >

Re: vacuumlo: add test to vacuumlo for test coverage

2023-01-17 Thread vignesh C
On Wed, 16 Nov 2022 at 10:18, Ian Lawrence Barwick wrote: > > 2022年9月3日(土) 17:28 Dong Wook Lee : > > > > Hi hackers, > > I write a tiny patch about vacuumlo to improve test coverage. > > I hope my work is meaningful. > > Hi > > While reviewing the patch backlog, we have determined that this patch

Re: Fix database creation during installchecks for ICU cluster

2023-01-17 Thread vignesh C
On Tue, 29 Nov 2022 at 20:24, Nazir Bilal Yavuz wrote: > > Hi, > > Thanks for the patch! > > > On 10/29/22 12:54, Marina Polyakova wrote: > > > > 1) The ECPG tests fail because they use the SQL_ASCII encoding [2], > > the database template0 uses the ICU locale provider and SQL_ASCII is > > not sup

Re: Time delayed LR (WAS Re: logical replication restrictions)

2023-01-19 Thread vignesh C
On Thu, 19 Jan 2023 at 12:06, Takamichi Osumi (Fujitsu) wrote: > > Updated the comment and the function call. > > Kindly have a look at the updated patch v17. Thanks for the updated patch, few comments: 1) min_apply_delay was accepting values like '600 m s h', I was not sure if we should allow th

Re: TAP output format in pg_regress

2023-01-19 Thread vignesh C
On Fri, 6 Jan 2023 at 11:20, vignesh C wrote: > > On Tue, 3 Jan 2023 at 16:01, vignesh C wrote: > > > > On Tue, 29 Nov 2022 at 00:57, Daniel Gustafsson wrote: > > > > > > > On 28 Nov 2022, at 20:02, Nikolay Shaplov wrote: > > > > > > >

Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?)

2023-01-19 Thread vignesh C
On Wed, 18 Jan 2023 at 03:30, Melanie Plageman wrote: > > v49 attached > > On Tue, Jan 17, 2023 at 2:12 PM Andres Freund wrote: > > On 2023-01-17 12:22:14 -0500, Melanie Plageman wrote: > > > > > > > +typedef struct PgStat_BackendIO > > > > > +{ > > > > > + PgStat_Counter > > > > > data[IOCO

Re: Add the ability to limit the amount of memory that can be allocated to backends.

2023-01-19 Thread vignesh C
On Fri, 6 Jan 2023 at 00:19, Reid Thompson wrote: > > On Tue, 2023-01-03 at 16:22 +0530, vignesh C wrote: > > > > The patch does not apply on top of HEAD as in [1], please post a > > rebased patch: > > ... > > Regards, > > Vignesh > > > >

Re: Operation log for major operations

2023-01-19 Thread vignesh C
On Sat, 14 Jan 2023 at 15:47, Dmitry Koval wrote: > > Hi! > > >The patch does not apply on top of HEAD ... > > Here is a fixed version. > Small additional fixes: > 1) added CRC calculation for empty 'pg_control_log' file; > 2) added saving 'errno' before calling LWLockRelease and restoring after

Re: Speed up transaction completion faster after many relations are accessed in a transaction

2023-01-19 Thread vignesh C
On Wed, 3 Aug 2022 at 09:04, David Rowley wrote: > > On Wed, 3 Aug 2022 at 07:04, Jacob Champion wrote: > > This entry has been waiting on author input for a while (our current > > threshold is roughly two weeks), so I've marked it Returned with > > Feedback. > > Thanks for taking care of this. Y

Re: Split index and table statistics into different types of stats

2023-01-19 Thread vignesh C
On Tue, 3 Jan 2023 at 19:49, Drouvot, Bertrand wrote: > > Hi, > > On 12/10/22 10:54 AM, Drouvot, Bertrand wrote: > > Hi, > > > > On 12/7/22 11:11 AM, Drouvot, Bertrand wrote: > >> Hi, > >> > >>> Hi, > >>> > >>> As [1] mentioned above has been committed (83a1a1b566), please find > >>> attached V5

Re: add PROCESS_MAIN to VACUUM

2023-01-19 Thread vignesh C
On Sat, 7 Jan 2023 at 10:37, Nathan Bossart wrote: > > rebased for cfbot The patch does not apply on top of HEAD as in [1], please post a rebased patch: === Applying patches on top of PostgreSQL commit ID d540a02a724b9643205abce8c5644a0f0908f6e3 === === applying patch ./v2-0001-add-PROCESS_MAIN-t

Re: Time delayed LR (WAS Re: logical replication restrictions)

2023-01-19 Thread vignesh C
On Thu, 19 Jan 2023 at 18:29, Amit Kapila wrote: > > On Thu, Jan 19, 2023 at 4:25 PM vignesh C wrote: > > > > On Thu, 19 Jan 2023 at 12:06, Takamichi Osumi (Fujitsu) > > wrote: > > > > > > Updated the comment and the function call. > > >

Re: Support logical replication of DDLs

2023-03-26 Thread vignesh C
On Thu, 23 Mar 2023 at 09:22, Ajin Cherian wrote: > > On Mon, Mar 20, 2023 at 8:17 PM houzj.f...@fujitsu.com > wrote: > > > > Attach the new patch set which addressed above comments. > > 0002,0003,0004 patch has been updated in this version. > > > > Best Regards, > > Hou zj > > Attached a patch-s

Re: Support logical replication of DDLs

2023-03-26 Thread vignesh C
On Sun, 26 Mar 2023 at 18:08, vignesh C wrote: > > On Thu, 23 Mar 2023 at 09:22, Ajin Cherian wrote: > > > > On Mon, Mar 20, 2023 at 8:17 PM houzj.f...@fujitsu.com > > wrote: > > > > > > Attach the new patch set which addressed above comments. > >

Re: Support logical replication of DDLs

2023-03-30 Thread vignesh C
On Thu, 30 Mar 2023 at 13:29, houzj.f...@fujitsu.com wrote: > > > > > -Original Message- > > From: houzj.f...@fujitsu.com > > Sent: Thursday, March 30, 2023 2:37 PM > > > > On Tuesday, March 28, 2023 12:13 PM houzj.f...@fujitsu.com > > wrote: > > > > > > On Monday, March 27, 2023 8:08 PM

Re: Support logical replication of DDLs

2023-03-30 Thread vignesh C
On Thu, 30 Mar 2023 at 13:29, houzj.f...@fujitsu.com wrote: > > > > > -Original Message- > > From: houzj.f...@fujitsu.com > > Sent: Thursday, March 30, 2023 2:37 PM > > > > On Tuesday, March 28, 2023 12:13 PM houzj.f...@fujitsu.com > > wrote: > > > > > > On Monday, March 27, 2023 8:08 PM

Re: Support logical replication of DDLs

2023-04-14 Thread vignesh C
On Fri, 7 Apr 2023 at 08:52, houzj.f...@fujitsu.com wrote: > > On Friday, April 7, 2023 11:13 AM houzj.f...@fujitsu.com > > > > > On Tuesday, April 4, 2023 7:35 PM shveta malik > > wrote: > > > > > > On Tue, Apr 4, 2023 at 8:43 AM houzj.f...@fujitsu.com > > > wrote: > > > > > > > Attach the ne

Re: Support logical replication of DDLs

2023-04-14 Thread vignesh C
On Fri, 14 Apr 2023 at 13:06, vignesh C wrote: > > Few comments: Some more comments on 0001 patch: Few comments: 1) We could add a space after the 2nd parameter + * Note we don't have the luxury of sprintf-like compiler warnings for + * malformed argument lists. + */ +sta

Re: Support logical replication of DDLs

2023-04-17 Thread vignesh C
On Sat, 15 Apr 2023 at 06:38, vignesh C wrote: > > On Fri, 14 Apr 2023 at 13:06, vignesh C wrote: > > > > Few comments: Few more comments: 1) since missing_ok is passed as false, if there is an error the error will be handled in find_string_in_jsonbcontainer, "missing

Re: [PoC] pg_upgrade: allow to upgrade publisher node

2023-04-19 Thread vignesh C
On Fri, 14 Apr 2023 at 16:00, Hayato Kuroda (Fujitsu) wrote: > > Dear Julien, > > > Sorry for the delay, I didn't had time to come back to it until this > > afternoon. > > No issues, everyone is busy:-). > > > I don't think that your analysis is correct. Slots are guaranteed to be > > stopped af

Re: [PoC] pg_upgrade: allow to upgrade publisher node

2023-04-19 Thread vignesh C
On Fri, 14 Apr 2023 at 16:00, Hayato Kuroda (Fujitsu) wrote: > > Dear Julien, > > > Sorry for the delay, I didn't had time to come back to it until this > > afternoon. > > No issues, everyone is busy:-). > > > I don't think that your analysis is correct. Slots are guaranteed to be > > stopped af

Re: Logical replication failed with SSL SYSCALL error

2023-04-19 Thread vignesh C
On Wed, 19 Apr 2023 at 17:26, shaurya jain <12345shau...@gmail.com> wrote: > > Hi Team, > > Could you please help me with this, It's urgent for the production > environment. > > On Wed, Apr 19, 2023 at 3:44 PM shaurya jain <12345shau...@gmail.com> wrote: >> >> Hi Team, >> >> Could you please help,

Re: [PoC] pg_upgrade: allow to upgrade publisher node

2023-04-20 Thread vignesh C
On Thu, 20 Apr 2023 at 11:01, Hayato Kuroda (Fujitsu) wrote: > > Dear Vignesh, > > Thank you for reviewing! PSA new patchset. > > > > Additionally, I added a checking functions in 0003 > > > According to pg_resetwal and other functions, the length of > > CHECKPOINT_SHUTDOWN > > > record seems (Siz

Re: New committers: Nathan Bossart, Amit Langote, Masahiko Sawada

2023-04-20 Thread vignesh C
On Thu, 20 Apr 2023 at 23:10, Tom Lane wrote: > > The Core Team would like to extend our congratulations to > Nathan Bossart, Amit Langote, and Masahiko Sawada, who have > accepted invitations to become our newest Postgres committers. > > Please join me in wishing them much success and few reverts

Re: Non-superuser subscription owners

2023-04-21 Thread vignesh C
word_required is false, as all the existing tests were there only for password_required as true. Regards, Vignesh From d0379b915a449d5763bd7665a1ec32edad009bd3 Mon Sep 17 00:00:00 2001 From: Vignesh C Date: Fri, 21 Apr 2023 11:54:17 +0530 Subject: [PATCH] Display 'password_required' op

<    2   3   4   5   6   7   8   9   10   11   >