Архив рассылок [pgsql-hackers]

Поиск
Список
Период
Сортировка
Искать
Re: Removing unneeded self joins Alexander Lakhin
Re: Removing unneeded self joins Alexander Korotkov
Document NULL David G. Johnston
Re: Document NULL Thom Brown
Re: Weird test mixup Noah Misch
Re: Document NULL Kashif Zeeshan
Re: Document NULL David Rowley
Re: Document NULL Tom Lane
Re: Weird test mixup Michael Paquier
Re: Weird test mixup Andrey M. Borodin
Re: Weird test mixup Michael Paquier
Re: Weird test mixup Andrey M. Borodin
Re: Removing unneeded self joins Alexander Korotkov
Re: Reducing the log spam Laurenz Albe
Re: Reducing the log spam Jelte Fennema-Nio
Re: Reducing the log spam Jelte Fennema-Nio
Re: Typos in the code and README Alexander Lakhin
Re: EXPLAN redundant options David G. Johnston
Re: EXPLAN redundant options Euler Taveira
Re: Document NULL David G. Johnston
Re: Weird test mixup Noah Misch
wrong comment in libpq.h David Zhang
Re: Removing unneeded self joins Alexander Korotkov
Re: Document NULL Kashif Zeeshan
Re: UUID v7 Andrey M. Borodin
Re: Document NULL Laurenz Albe
different engine for JIT Pavel Stehule
Re: Document NULL jian he
Re: Removing unneeded self joins Alexander Korotkov
Re: different engine for JIT Adrien Nayrat
Re: wrong comment in libpq.h Peter Eisentraut
Re: wrong comment in libpq.h Daniel Gustafsson
Re: Reducing the log spam Laurenz Albe
Re: Document NULL David G. Johnston
Re: Document NULL Peter Eisentraut
Re: Document NULL David G. Johnston
Re: Document NULL Tom Lane
Re: Document NULL David G. Johnston
Re: On disable_cost Robert Haas
Re: Weird test mixup Michael Paquier
Re: UniqueKey v2 Andy Fan
Re: wrong comment in libpq.h Peter Eisentraut
Re: On disable_cost Robert Haas
Re: On disable_cost Robert Haas
Re: AIX support Sriram RK
Re: On disable_cost Robert Haas
Re: On disable_cost Tom Lane
Re: Removing unneeded self joins Alexander Korotkov
Re: On disable_cost Tom Lane
Re: Removing unneeded self joins Alexander Korotkov
Re: On disable_cost Robert Haas
Re: On disable_cost Tom Lane
Re: On disable_cost Peter Geoghegan
Re: Weird test mixup Noah Misch
Re: Weird test mixup Michael Paquier
PERIOD foreign key feature Bruce Momjian
Re: PERIOD foreign key feature David G. Johnston
Re: PERIOD foreign key feature Paul Jungwirth
Re: Weird test mixup Noah Misch
Re: On disable_cost Robert Haas
Re: Weird test mixup Noah Misch
Re: AIX support Sriram RK
Re: PERIOD foreign key feature Peter Eisentraut
Re: AIX support Peter Eisentraut
Re: SQL:2011 application time Peter Eisentraut
Re: AIX support Bruce Momjian
Re: UUID v7 Andrey M. Borodin
Re: Weird test mixup Michael Paquier
Re: Weird test mixup Noah Misch
Re: PERIOD foreign key feature Paul Jungwirth
Re: SQL:2011 application time Paul Jungwirth
Re: Weird test mixup Michael Paquier
Re: Weird test mixup Michael Paquier
Rajan Pandey
Re: Kashif Zeeshan
Re: First draft of PG 17 release notes Dagfinn Ilmari Mannsåker
Re: First draft of PG 17 release notes Dagfinn Ilmari Mannsåker
Re: Tom Lane
open items Robert Haas
Re: open items Dagfinn Ilmari Mannsåker
Re: open items Robert Haas
Re: open items Michael Paquier
Re: Weird test mixup Noah Misch
Re: SQL:2011 application time Matthias van de Meent
Re: Weird test mixup Michael Paquier
Re: zaidagilist
Re: gcc 12.1.0 warning Nazir Bilal Yavuz
Re: open items Alvaro Herrera
Re: open items Melanie Plageman
Re: SQL:2011 application time Peter Eisentraut
Re: open items Daniel Gustafsson
Serverside SNI support in libpq Daniel Gustafsson
Re: open items Robert Haas
Re: open items Robert Haas
Re: Weird test mixup Andrey M. Borodin
Re: Row pattern recognition Tatsuo Ishii
Re: Document NULL David G. Johnston
Re: open items Heikki Linnakangas
Re: Document NULL Thom Brown
Re: Document NULL David G. Johnston
Re: SQL:2011 application time Paul Jungwirth
Re: SQL:2011 application time Paul Jungwirth
Re: SQL:2011 application time Matthias van de Meent
Re: SQL:2011 application time Paul Jungwirth
Re: Weird test mixup Noah Misch
Re: Weird test mixup Michael Paquier
Re: Weird test mixup Michael Paquier
Re: SQL:2011 application time Paul Jungwirth
Re: SQL:2011 application time Paul Jungwirth
Convert sepgsql tests to TAP Peter Eisentraut
Re: race condition in pg_class Michael Paquier
Re: UniqueKey v2 Antonin Houska
Re: SQL:2011 application time Peter Eisentraut
Re: pg_stat_advisor extension Ilia Evdokimov
I have an exporting need... Juan Hernández
Re: UniqueKey v2 Antonin Houska
Re: Large files for relations Peter Eisentraut
Re: Why is parula failing? David Rowley
Re: SQL:2011 application time Paul Jungwirth
Re: UniqueKey v2 Andy Fan
Re: UniqueKey v2 Andy Fan
Re: I have an exporting need... Heikki Linnakangas
Re: JIT compilation per plan node Jelte Fennema-Nio
Re: Postgres and --config-file option Aleksander Alekseev
Re: JIT compilation per plan node Jelte Fennema-Nio
Re: Postgres and --config-file option Aleksander Alekseev
Re: open items Robert Haas
Re: libpq compression (part 3) Jacob Burroughs
Re: libpq compression (part 3) Jacob Burroughs
Fwd: libpq compression (part 3) Jacob Burroughs
Re: Row pattern recognition Tatsuo Ishii
Re: SQL:2011 application time Michael Paquier
Re: SQL:2011 application time Peter Eisentraut
Re: AIX support Sriram RK
Re: AIX support Noah Misch
Re: AIX support Sriram RK
Re: libpq compression (part 3) Jacob Burroughs
Re: libpq compression (part 3) Jacob Burroughs
More links on release-17.html Marcos Pegoraro
Re: recovery modules Nathan Bossart
Re: SQL:2011 application time Peter Eisentraut
Minor cleanups in the SSL tests Daniel Gustafsson
Re: POC: GROUP BY optimization Andrei Lepikhov
Re: Postgres and --config-file option Aleksander Alekseev
Re: Why is parula failing? Robins Tharakan
Re: GUC names in messages Peter Eisentraut
Re: GUC names in messages Alvaro Herrera
avoid MERGE_ACTION keyword? Peter Eisentraut
Re: AIX support Sriram RK
Re: AIX support Alvaro Herrera
Re: GUC names in messages Daniel Gustafsson
Re: GUC names in messages Daniel Gustafsson
Re: open items Michael Paquier
Re: GUC names in messages Peter Smith
Re: GUC names in messages Peter Eisentraut
Re: psql JSON output format Christoph Berg
Re: psql JSON output format Pavel Stehule
Re: libpq compression (part 3) Jacob Burroughs
Re: libpq compression (part 3) Jacob Champion
Re: libpq compression (part 3) Jelte Fennema-Nio
Re: libpq compression (part 3) Jelte Fennema-Nio
Re: libpq compression (part 3) Jacob Burroughs
Re: Requiring LLVM 14+ in PostgreSQL 18 Ole Peder Brandtzæg
Re: Requiring LLVM 14+ in PostgreSQL 18 Ole Peder Brandtzæg
Re: GUC names in messages Peter Smith
Re: Postgres and --config-file option Aleksander Alekseev
Re: libpq compression (part 3) Jacob Champion
Re: libpq compression (part 3) Jacob Champion
Cleaning up perl code Alexander Lakhin
Re: libpq compression (part 3) Jacob Champion
Re: libpq compression (part 3) Andrey M. Borodin
Re: libpq compression (part 3) Andrey M. Borodin
Re: libpq compression (part 3) Jacob Champion
Re: libpq compression (part 3) Jacob Champion
Re: libpq compression (part 3) Magnus Hagander
Re: Cleaning up perl code Dagfinn Ilmari Mannsåker
Re: I have an exporting need... Juan Hernández
Re: recovery modules Nathan Bossart
Re: Cleaning up perl code Alexander Lakhin
Re: Cleaning up perl code Michael Paquier
Re: POC: GROUP BY optimization Andrei Lepikhov
Re: libpq compression (part 3) Jacob Burroughs
Re: libpq compression (part 3) Jelte Fennema-Nio
Re: libpq compression (part 3) Jacob Burroughs
Re: libpq compression (part 3) Jacob Champion
Re: libpq compression (part 3) Jacob Champion
Re: libpq compression (part 3) Jacob Burroughs
Re: libpq compression (part 3) Jacob Burroughs
Re: libpq compression (part 3) Jacob Champion
Re: AIX support Sriram RK
Re: Virtual generated columns Peter Eisentraut
Re: Virtual generated columns Peter Eisentraut
Re: AIX support Peter Eisentraut
RE: State of pg_createsubscriber Hayato Kuroda (Fujitsu)
RE: AIX support Srirama Kucherlapati
Re: AIX support Heikki Linnakangas
PG catalog Karki, Sanjay
Re: Row pattern recognition Tatsuo Ishii
Re: Cleaning up perl code Michael Paquier
Re: PG catalog David G. Johnston
Re: PG catalog Tom Lane
relfilenode statistics Bertrand Drouvot
Re: AIX support Bruce Momjian
Re: POC: GROUP BY optimization Alexander Korotkov
Re: Comments on Custom RMGRs Michael Paquier
RE: Partial aggregates pushdown Fujii.Yuki@df.MitsubishiElectric.co.jp
Re: Comments on Custom RMGRs Tristan Partin
Re: Partial aggregates pushdown Alexander Pyhalov
Re: Partial aggregates pushdown Alexander Pyhalov
Re: GUC names in messages Peter Smith
small fix for llvm build Peter Eisentraut
Re: meson vs windows perl Andres Freund
meson "experimental"? Peter Eisentraut
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
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
Re: POC: GROUP BY optimization Andrei Lepikhov
Re: meson "experimental"? Aleksander Alekseev
Re: meson "experimental"? Aleksander Alekseev
Re: meson "experimental"? Andrew Dunstan
Vacuum statistics Alena Rybakina
Re: Vacuum statistics Alena Rybakina
Re: Vacuum statistics Andrei Zubkov
Re: POC: GROUP BY optimization Alexander Korotkov
Re: meson "experimental"? Aleksander Alekseev
Re: meson "experimental"? Andres Freund
meson and check-tests Ashutosh Bapat
FAQ