Messages by Date
-
2024/06/03
Re: pltcl crashes due to a syntax error
Erik Wienhold
-
2024/06/03
Re: POC: GROUP BY optimization
Pavel Borisov
-
2024/06/03
Re: Volatile write caches on macOS and Windows, redux
Nathan Bossart
-
2024/06/03
SQL/JSON query functions context_item doc entry and type requirement
jian he
-
2024/06/03
Re: An improved README experience for PostgreSQL
Nathan Bossart
-
2024/06/03
Re: Build with LTO / -flto on macOS
Wolfgang Walther
-
2024/06/03
Re: Optimizing COPY with SIMD
Nathan Bossart
-
2024/06/03
Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs)
Pavel Stehule
-
2024/06/03
Re: Build with LTO / -flto on macOS
Peter Eisentraut
-
2024/06/03
Build with LTO / -flto on macOS
Wolfgang Walther
-
2024/06/03
differential test coverage when working on a patch
Andy Fan
-
2024/06/03
Re: Optimizing COPY with SIMD
Neil Conway
-
2024/06/03
Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs)
Justin Pryzby
-
2024/06/03
Re: Optimizing COPY with SIMD
Joe Conway
-
2024/06/03
Re: CREATE DATABASE with filesystem cloning
Nazir Bilal Yavuz
-
2024/06/03
Re: Pgoutput not capturing the generated columns
Shlok Kyal
-
2024/06/03
Re: relfilenode statistics
Bertrand Drouvot
-
2024/06/03
Re: Pgoutput not capturing the generated columns
vignesh C
-
2024/06/03
Re: Pgoutput not capturing the generated columns
Shubham Khanna
-
2024/06/03
Re: Pgoutput not capturing the generated columns
Shubham Khanna
-
2024/06/03
Re: Pgoutput not capturing the generated columns
Shubham Khanna
-
2024/06/03
Re: Pgoutput not capturing the generated columns
Shubham Khanna
-
2024/06/03
Re: pgsql: Add more SQL/JSON constructor functions
Peter Eisentraut
-
2024/06/03
Re: allow sorted builds for btree_gist
Bernd Helmle
-
2024/06/03
Re: Pgoutput not capturing the generated columns
Shubham Khanna
-
2024/06/03
Re: Conflict Detection and Resolution
Amit Kapila
-
2024/06/03
Re: meson "experimental"?
Aleksander Alekseev
-
2024/06/02
Re: meson and check-tests
Nazir Bilal Yavuz
-
2024/06/02
walsender.c comment with no context is hard to understand
Peter Smith
-
2024/06/02
Re: cannot drop intarray extension
jian he
-
2024/06/02
Re: pgsql: Add more SQL/JSON constructor functions
Tom Lane
-
2024/06/02
Re: cannot drop intarray extension
Kashif Zeeshan
-
2024/06/02
cannot drop intarray extension
jian he
-
2024/06/02
Re: Improve the connection failure error messages
Peter Smith
-
2024/06/02
Re: Fix overflow hazard in interval rounding
Joseph Koshakow
-
2024/06/02
Re: pltcl crashes due to a syntax error
Tom Lane
-
2024/06/02
Re: Schema variables - new implementation for Postgres 15
Peter Eisentraut
-
2024/06/02
Re: Switch background worker on/off in runtime.
Peter Eisentraut
-
2024/06/02
Re: pgsql: Add more SQL/JSON constructor functions
Peter Eisentraut
-
2024/06/02
Re: Avoid an odd undefined behavior with memcmp (src/bin/pg_rewind/pg_rewind.c)
Ranier Vilela
-
2024/06/02
Re: Fix possible dereference null pointer (PQprint)
Ranier Vilela
-
2024/06/02
Re: pltcl crashes due to a syntax error
Erik Wienhold
-
2024/06/02
Re: The xversion-upgrade test fails to stop server
Alexander Lakhin
-
2024/06/02
Re: meson and check-tests
Andrew Dunstan
-
2024/06/02
Optimizing COPY with SIMD
Neil Conway
-
2024/06/02
Re: The xversion-upgrade test fails to stop server
Andrew Dunstan
-
2024/06/02
Re: POC: GROUP BY optimization
Alexander Korotkov
-
2024/06/02
Re: pltcl crashes due to a syntax error
Pierre Forstmann
-
2024/06/02
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?
Andres Freund
-
2024/06/02
Re: POC: GROUP BY optimization
jian he
-
2024/06/01
Re: meson and check-tests
Tom Lane
-
2024/06/01
Re: meson and check-tests
jian he
-
2024/06/01
Extension security improvement: Add support for extensions with an owned schema
Jelte Fennema-Nio
-
2024/06/01
Fix grammar oddities in comments
James Coleman
-
2024/06/01
Re: meson and check-tests
Tristan Partin
-
2024/06/01
Re: pltcl crashes due to a syntax error
Tom Lane
-
2024/06/01
Re: ResourceOwner refactoring
Alexander Lakhin
-
2024/05/31
pltcl crashes due to a syntax error
a.kozhemyakin
-
2024/05/31
Re: Add memory context type to pg_backend_memory_contexts view
Michael Paquier
-
2024/05/31
Re: To what extent should tests rely on VACUUM ANALYZE?
Alexander Lakhin
-
2024/05/31
Re: Explicit specification of index ensuring uniqueness of foreign columns
David G. Johnston
-
2024/05/31
Re: Explicit specification of index ensuring uniqueness of foreign columns
Tom Lane
-
2024/05/31
Re: Ambiguous description on new columns
Peter Smith
-
2024/05/31
meson and check-tests
Ashutosh Bapat
-
2024/05/31
Re: meson "experimental"?
Andres Freund
-
2024/05/31
Re: Schema variables - new implementation for Postgres 15
Pavel Stehule
-
2024/05/31
Re: Add memory context type to pg_backend_memory_contexts view
David Christensen
-
2024/05/31
Re: Schema variables - new implementation for Postgres 15
Wolfgang Walther
-
2024/05/31
Re: Schema variables - new implementation for Postgres 15
Pavel Stehule
-
2024/05/31
Re: Schema variables - new implementation for Postgres 15
Pavel Stehule
-
2024/05/31
Re: Schema variables - new implementation for Postgres 15
Wolfgang Walther
-
2024/05/31
Re: Schema variables - new implementation for Postgres 15
Pavel Stehule
-
2024/05/31
Re: Schema variables - new implementation for Postgres 15
Pavel Stehule
-
2024/05/31
Re: Improve the connection failure error messages
Nisha Moond
-
2024/05/31
Re: 回复: An implementation of multi-key sort
Yao Wang
-
2024/05/31
Re: Schema variables - new implementation for Postgres 15
Wolfgang Walther
-
2024/05/31
Re: Schema variables - new implementation for Postgres 15
Pavel Stehule
-
2024/05/31
Re: Schema variables - new implementation for Postgres 15
Wolfgang Walther
-
2024/05/31
Re: Schema variables - new implementation for Postgres 15
Pavel Stehule
-
2024/05/31
Re: meson "experimental"?
Aleksander Alekseev
-
2024/05/31
Re: Switch background worker on/off in runtime.
Kashif Zeeshan
-
2024/05/31
Re: Schema variables - new implementation for Postgres 15
Dmitry Dolgov
-
2024/05/31
Switch background worker on/off in runtime.
ISHAN CHHANGANI .
-
2024/05/31
Re: 001_rep_changes.pl fails due to publisher stuck on shutdown
Peter Smith
-
2024/05/31
Re: Fix possible dereference null pointer (PQprint)
Daniel Gustafsson
-
2024/05/30
Re: Use generation memory context for tuplestore.c
David Rowley
-
2024/05/30
Cluster forcefully removal without user input
Zaid Shabbir
-
2024/05/30
Explicit specification of index ensuring uniqueness of foreign columns
Kaiting Chen
-
2024/05/30
Re: Add memory context type to pg_backend_memory_contexts view
David Rowley
-
2024/05/30
Re: POC: GROUP BY optimization
Alexander Korotkov
-
2024/05/30
Re: Reuse child_relids in try_partitionwise_join was Re: Assert failure on bms_equal(child_joinrel->relids, child_joinrelids)
David Christensen
-
2024/05/30
Re: Should consider materializing the cheapest inner path in consider_parallel_nestloop()
Tomasz Rybak
-
2024/05/30
Re: Add memory context type to pg_backend_memory_contexts view
David Christensen
-
2024/05/30
Re: Vacuum statistics
Andrei Zubkov
-
2024/05/30
Re: Vacuum statistics
Alena Rybakina
-
2024/05/30
Re: [PATCH] psql: \dn+ to show size of each schema (and \dA+ for AMs)
David Christensen
-
2024/05/30
Vacuum statistics
Alena Rybakina
-
2024/05/30
Re: The xversion-upgrade test fails to stop server
Andrew Dunstan
-
2024/05/30
Re: Add LSN <-> time conversion functionality
Andrey M. Borodin
-
2024/05/30
Re: meson "experimental"?
Andrew Dunstan
-
2024/05/30
The xversion-upgrade test fails to stop server
Alexander Lakhin
-
2024/05/30
Re: Implementing CustomScan over an index
Aleksander Alekseev
-
2024/05/30
Re: meson "experimental"?
Aleksander Alekseev
-
2024/05/30
Re: meson "experimental"?
Aleksander Alekseev
-
2024/05/30
Re: Exposing the lock manager's WaitForLockers() to SQL
Will Mortensen
-
2024/05/30
Re: Exposing the lock manager's WaitForLockers() to SQL
Will Mortensen
-
2024/05/29
Re: Improving the latch handling between logical replication launcher and worker processes.
vignesh C
-
2024/05/29
Re: 001_rep_changes.pl fails due to publisher stuck on shutdown
Peter Smith
-
2024/05/29
Re: POC: GROUP BY optimization
Andrei Lepikhov
-
2024/05/29
Re: Avoid an odd undefined behavior with memcmp (src/bin/pg_rewind/pg_rewind.c)
David Rowley
-
2024/05/29
Implementing CustomScan over an index
Chris Cleveland
-
2024/05/29
Re: Improving the latch handling between logical replication launcher and worker processes.
Peter Smith
-
2024/05/29
Re:Avoid an odd undefined behavior with memcmp (src/bin/pg_rewind/pg_rewind.c)
Long Song
-
2024/05/29
Re: Remove last traces of HPPA support
Noah Misch
-
2024/05/29
Re: pgsql: Add more SQL/JSON constructor functions
Tom Lane
-
2024/05/29
Re: 001_rep_changes.pl fails due to publisher stuck on shutdown
vignesh C
-
2024/05/29
Re: Volatile write caches on macOS and Windows, redux
Peter Eisentraut
-
2024/05/29
Re: About 0001:,Having overviewed it, I don't see any issues (but I'm the author), except grammatical ones - but I'm not a native to judge it.,Also, the sentence 'turning GROUP BY clauses into pathkeys' is unclear to me. It may be better to write something like: 'building pathkeys by the list of grouping clauses'.,,0002:,The part under USE_ASSERT_CHECKING looks good to me. But the code in group_keys_reorder_by_pathkeys looks suspicious: of course, we do some doubtful work without any possible way to reproduce, but if we envision some duplicated elements in the group_clauses, we should avoid usage of the list_concat_unique_ptr. What's more, why do you not exit from foreach_ptr immediately after SortGroupClause has been found? I think the new_group_clauses should be consistent with the new_group_pathkeys.,,0003:,Looks good,,0004:,I was also thinking about reintroducing the preprocess_groupclause because with the re-arrangement of GROUP-BY clauses according to incoming pathkeys, it d...
Alexander Korotkov
-
2024/05/29
RE: Psql meta-command conninfo+
Maiquel Grassi
-
2024/05/29
001_rep_changes.pl fails due to publisher stuck on shutdown
Alexander Lakhin
-
2024/05/29
Timeout gets unset on a syntax error.
ISHAN CHHANGANI .
-
2024/05/29
Re: Improving the latch handling between logical replication launcher and worker processes.
vignesh C
-
2024/05/29
Re: Improving the latch handling between logical replication launcher and worker processes.
vignesh C
-
2024/05/29
About 0001:,Having overviewed it, I don't see any issues (but I'm the author), except grammatical ones - but I'm not a native to judge it.,Also, the sentence 'turning GROUP BY clauses into pathkeys' is unclear to me. It may be better to write something like: 'building pathkeys by the list of grouping clauses'.,,0002:,The part under USE_ASSERT_CHECKING looks good to me. But the code in group_keys_reorder_by_pathkeys looks suspicious: of course, we do some doubtful work without any possible way to reproduce, but if we envision some duplicated elements in the group_clauses, we should avoid usage of the list_concat_unique_ptr. What's more, why do you not exit from foreach_ptr immediately after SortGroupClause has been found? I think the new_group_clauses should be consistent with the new_group_pathkeys.,,0003:,Looks good,,0004:,I was also thinking about reintroducing the preprocess_groupclause because with the re-arrangement of GROUP-BY clauses according to incoming pathkeys, it doesn't make sense to have a user-defined order—at least while cost_sort doesn't differ costs for alternative column orderings.,So, I'm okay with the code. But why don't you use the same approach with foreach_ptr as before?
Andrei Lepikhov
-
2024/05/28
Re: meson: Specify -Wformat as a common warning flag for extensions
Sutou Kouhei
-
2024/05/28
meson "experimental"?
Peter Eisentraut
-
2024/05/28
Re: meson: Specify -Wformat as a common warning flag for extensions
Peter Eisentraut
-
2024/05/28
Re: Need clarification on compilation errors in PG 16.2
Pradeep Kumar
-
2024/05/28
Re: Need clarification on compilation errors in PG 16.2
Pradeep Kumar
-
2024/05/28
Re: Improving the latch handling between logical replication launcher and worker processes.
Peter Smith
-
2024/05/28
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning
Ashutosh Bapat
-
2024/05/28
Re: pgsql: Add more SQL/JSON constructor functions
Amit Langote
-
2024/05/28
Re: DROP OWNED BY fails to clean out pg_init_privs grants
Hannu Krosing
-
2024/05/28
Re: In-placre persistance change of a relation
Jelte Fennema-Nio
-
2024/05/28
Re: meson vs windows perl
Andres Freund
-
2024/05/28
Re: Need clarification on compilation errors in PG 16.2
Daniel Gustafsson
-
2024/05/28
Re: Need clarification on compilation errors in PG 16.2
Tom Lane
-
2024/05/28
Windows: openssl & gssapi dislike each other
Dave Page
-
2024/05/28
Avoid an odd undefined behavior with memcmp (src/bin/pg_rewind/pg_rewind.c)
Ranier Vilela
-
2024/05/28
Re: errors building on windows using meson
Imran Zaheer
-
2024/05/28
Re: Add last_commit_lsn to pg_stat_database
James Coleman
-
2024/05/28
Re: Schema variables - new implementation for Postgres 15
Pavel Stehule
-
2024/05/28
small fix for llvm build
Peter Eisentraut
-
2024/05/28
Re: Add last_commit_lsn to pg_stat_database
James Coleman
-
2024/05/28
Re: commitfest.postgresql.org is no longer fit for purpose
James Coleman
-
2024/05/28
Re: commitfest.postgresql.org is no longer fit for purpose
James Coleman
-
2024/05/28
Re: pgsql: Add more SQL/JSON constructor functions
David G. Johnston
-
2024/05/28
Re:[PATCH]A minor improvement to the error-report in SimpleLruWriteAll()
Long Song
-
2024/05/28
Re: ON ERROR in json_query and the like
Pavel Stehule
-
2024/05/28
Re: why memoize is not used for correlated subquery
Andy Fan
-
2024/05/28
Re: Parallel CREATE INDEX for GIN indexes
Andy Fan
-
2024/05/28
ON ERROR in json_query and the like
Markus Winand
-
2024/05/28
Re: Conflict Detection and Resolution
Nisha Moond
-
2024/05/28
Re: Use pgBufferUsage for block reporting in analyze
Anthonin Bonnefoy
-
2024/05/28
Re: why memoize is not used for correlated subquery
Pavel Stehule
-
2024/05/28
Re: why memoize is not used for correlated subquery
David Rowley
-
2024/05/28
Re: why memoize is not used for correlated subquery
Tender Wang
-
2024/05/28
why memoize is not used for correlated subquery
Pavel Stehule
-
2024/05/28
Re: Need clarification on compilation errors in PG 16.2
Pradeep Kumar
-
2024/05/27
Re: Need clarification on compilation errors in PG 16.2
Pradeep Kumar
-
2024/05/27
Re: Need clarification on compilation errors in PG 16.2
Daniel Gustafsson
-
2024/05/27
Re: GUC names in messages
Peter Smith
-
2024/05/27
Re: CREATE INDEX CONCURRENTLY on partitioned index
Alexander Pyhalov
-
2024/05/27
Re: Partial aggregates pushdown
Alexander Pyhalov
-
2024/05/27
Re: Partial aggregates pushdown
Alexander Pyhalov
-
2024/05/27
Need clarification on compilation errors in PG 16.2
Pradeep Kumar
-
2024/05/27
Re: First draft of PG 17 release notes
Bruce Momjian
-
2024/05/27
Re: First draft of PG 17 release notes
David Rowley
-
2024/05/27
Re: pgsql: Add more SQL/JSON constructor functions
Alvaro Herrera
-
2024/05/27
Re: apply_scanjoin_target_to_paths and partitionwise join
arne . roland
-
2024/05/27
Re: Show WAL write and fsync stats in pg_stat_io
Amit Kapila
-
2024/05/27
Re: remaining sql/json patches
jian he
-
2024/05/27
Re: CREATE INDEX CONCURRENTLY on partitioned index
Ilya Gladyshev
-
2024/05/27
Re: Comments on Custom RMGRs
Tristan Partin
-
2024/05/27
Re: apply_scanjoin_target_to_paths and partitionwise join
Ashutosh Bapat
-
2024/05/27
Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c)
Ashutosh Bapat
-
2024/05/27
Re: Comments on Custom RMGRs
Michael Paquier
-
2024/05/27
Re: Fix calloc check if oom (PQcancelCreate)
Ranier Vilela
-
2024/05/27
Re: Fix calloc check if oom (PQcancelCreate)
Daniel Gustafsson
-
2024/05/27
Re: Fix calloc check if oom (PQcancelCreate)
Ranier Vilela
-
2024/05/27
Re: Fix calloc check if oom (PQcancelCreate)
Jelte Fennema-Nio
-
2024/05/27
Re: Fix calloc check if oom (PQcancelCreate)
Ranier Vilela
-
2024/05/27
Re: Fix calloc check if oom (PQcancelCreate)
Jelte Fennema-Nio
-
2024/05/27
Test 031_recovery_conflict fails when a conflict counted twice
Alexander Lakhin
-
2024/05/27
Fix possible dereference null pointer (PQprint)
Ranier Vilela
-
2024/05/27
Fix use of possible uninitialized variable retval (src/pl/plpgsql/src/pl_handler.c)
Ranier Vilela
-
2024/05/27
Re: Fix calloc check if oom (PQcancelCreate)
Ranier Vilela
-
2024/05/27
Re: Fix calloc check if oom (PQcancelCreate)
Daniel Gustafsson
-
2024/05/27
Re: relfilenode statistics
Robert Haas
-
2024/05/27
Re: POC: GROUP BY optimization
Alexander Korotkov
-
2024/05/27
Fix calloc check if oom (PQcancelCreate)
Ranier Vilela
-
2024/05/26
Re: DISCARD ALL does not force re-planning of plpgsql functions/procedures
Jelte Fennema-Nio
-
2024/05/26
Re: Conflict Detection and Resolution
shveta malik
-
2024/05/26
Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c)
Michael Paquier
-
2024/05/26
Re: Speed up JSON escape processing with SIMD plus other optimisations
David Rowley
-
2024/05/26
Re: Improve conditional compilation for direct I/O alignment checks
Peter Eisentraut
-
2024/05/26
Re: DROP OWNED BY fails to clean out pg_init_privs grants
Daniel Gustafsson
-
2024/05/26
Re: DROP OWNED BY fails to clean out pg_init_privs grants
Tom Lane
-
2024/05/26
Re: DROP OWNED BY fails to clean out pg_init_privs grants
Hannu Krosing
-
2024/05/26
Re: DISCARD ALL does not force re-planning of plpgsql functions/procedures
Jelte Fennema-Nio