pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3
  2023-07-27 20:02 UTC  Hellen Jiang <hjiang@federatedwireless.com>
` Re: Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3
  2023-07-28 10:48 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [2+ messages in thread]

Create DB privilege is not inherited
  2023-07-27 12:47 UTC  Ben Hancock <lists@benghancock.com>
` Re: Create DB privilege is not inherited
  2023-07-27 13:09 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Create DB privilege is not inherited
  2023-07-27 14:37 UTC  Ben Hancock <lists@benghancock.com>
  [3+ messages in thread]

Difference in the tablespace folders on primary and secondary nodes
  2023-07-25 08:38 UTC  Abhishek Bhola <abhishek.bhola@japannext.co.jp>
` Re: Difference in the tablespace folders on primary and secondary nodes
  2023-07-25 12:22 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Difference in the tablespace folders on primary and secondary nodes
  2023-07-26 02:00 UTC  Abhishek Bhola <abhishek.bhola@japannext.co.jp>
` Re: Difference in the tablespace folders on primary and secondary nodes
  2023-07-26 06:12 UTC  Abhishek Bhola <abhishek.bhola@japannext.co.jp>
` Re: Difference in the tablespace folders on primary and secondary nodes
  2023-07-26 13:55 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Difference in the tablespace folders on primary and secondary nodes
  2023-07-27 01:30 UTC  Abhishek Bhola <abhishek.bhola@japannext.co.jp>
` Re: Difference in the tablespace folders on primary and secondary nodes
  2023-07-27 02:39 UTC  Stephen Frost <sfrost@snowman.net>
  [7+ messages in thread]

Query on Primary_conninfo
  2023-07-26 12:03 UTC  Praneel Devisetty <devisettypraneel@gmail.com>
` Re: Query on Primary_conninfo
  2023-07-27 00:55 UTC  Michael Paquier <michael@paquier.xyz>
  [2+ messages in thread]

logging_collector is off, but the logging is opening
  2023-07-25 21:43 UTC  Wen Yi <wen-yi@qq.com>
` Re: logging_collector is off, but the logging is opening
  2023-07-26 15:31 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
  [2+ messages in thread]

How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint?
  2023-07-26 09:00 UTC  Dionisis Kontominas <dkontominas@gmail.com>
` Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint?
  2023-07-26 09:18 UTC  Thomas Kellerer <shammat@gmx.net>
` Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint?
  2023-07-26 09:25 UTC  Dionisis Kontominas <dkontominas@gmail.com>
` Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint?
  2023-07-26 09:39 UTC  Dominique Devienne <ddevienne@gmail.com>
` Re: How to check for Overlapping Date Ranges with extra fields in table EXCLUDE constraint?
  2023-07-26 09:56 UTC  Thomas Kellerer <shammat@gmx.net>
  [5+ messages in thread]

Nu-B here
  2023-07-20 00:36 UTC  Amn Ojee Uw <amnojeeuw@gmail.com>
` Re: Nu-B here
  2023-07-20 00:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Nu-B here
  2023-07-20 00:55 UTC  Maciek Sakrejda <m.sakrejda@gmail.com>
` Re: Nu-B here
  2023-07-20 06:32 UTC  Alban Hertroys <haramrae@gmail.com>
` Re: Nu-B here
  2023-07-20 14:41 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Nu-B here
  2023-07-25 22:10 UTC  Amn Ojee Uw <amnojeeuw@gmail.com>
  [6+ messages in thread]

Error 503 Backend fetch failed
  2023-07-24 13:01 UTC  Sabri Taner Burak ALTINDAL <stba@protonmail.com>
` Re: Error 503 Backend fetch failed
  2023-07-25 13:49 UTC  Stephen Frost <sfrost@snowman.net>
  [2+ messages in thread]

suggestion about time based partitioning and hibernate
  2023-07-18 06:18 UTC  Luca Ferrari <fluca1978@gmail.com>
` Re: suggestion about time based partitioning and hibernate
  2023-07-18 06:47 UTC  Ron <ronljohnsonjr@gmail.com>
` RE: suggestion about time based partitioning and hibernate
  2023-07-18 07:32 UTC  n.kobzarev@aeronavigator.ru
` Re: suggestion about time based partitioning and hibernate
  2023-07-19 16:45 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: suggestion about time based partitioning and hibernate
  2023-07-20 15:31 UTC  Luca Ferrari <fluca1978@gmail.com>
` Re: suggestion about time based partitioning and hibernate
  2023-07-20 16:52 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: suggestion about time based partitioning and hibernate
  2023-07-25 10:23 UTC  Marc Millas <marc.millas@mokadb.com>
  [7+ messages in thread]

[Beginner Question]Is there way to test the postgres's kernel function?
  2023-07-23 09:22 UTC  Wen Yi <wen-yi@qq.com>
` Re: [Beginner Question]Is there way to test the postgres's kernel function?
  2023-07-24 14:56 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: [Beginner Question]Is there way to test the postgres's kernel function?
  2023-07-25 08:37 UTC  jian he <jian.universality@gmail.com>
  [3+ messages in thread]

Setting Auto Commit off in C API
  2023-07-25 01:54 UTC  Badri Subramaniam <sbadrina@gmail.com>
` Re: Setting Auto Commit off in C API
  2023-07-25 05:57 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [2+ messages in thread]

Duplicate Primary keys in postgresql tables
  2023-07-22 17:11 UTC  De Lan <delandl@google.com>
` Re: Duplicate Primary keys in postgresql tables
  2023-07-22 17:30 UTC  Ken Marshall <ktm@rice.edu>
` Re: Duplicate Primary keys in postgresql tables
  2023-07-22 18:02 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Duplicate Primary keys in postgresql tables
  2023-07-24 16:59 UTC  De Lan <delandl@google.com>
  [4+ messages in thread]

Grant all privileges to user on a database
  2023-07-24 13:15 UTC  Kaushal Shriyan <kaushalshriyan@gmail.com>
` Re: Grant all privileges to user on a database
  2023-07-24 13:21 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Grant all privileges to user on a database
  2023-07-24 13:38 UTC  Kaushal Shriyan <kaushalshriyan@gmail.com>
` Re: Grant all privileges to user on a database
  2023-07-24 13:56 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Grant all privileges to user on a database
  2023-07-24 14:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Grant all privileges to user on a database
  2023-07-24 14:51 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Grant all privileges to user on a database
  2023-07-24 14:59 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [7+ messages in thread]

\d don't print all the tables
  2023-07-24 02:25 UTC  Wen Yi <wen-yi@qq.com>
` Re: \d don't print all the tables
  2023-07-24 09:51 UTC  Antonio Čale <antonio.cale@gmail.com>
` Re: \d don't print all the tables
  2023-07-24 13:17 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: \d don't print all the tables
  2023-07-24 13:42 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: \d don't print all the tables
  2023-07-24 14:17 UTC  Alvaro Herrera <alvherre@alvh.no-ip.org>
  [5+ messages in thread]

aclitem binary encoding
  2023-07-21 14:30 UTC  Joseph Koshakow <koshy44@gmail.com>
` Re: aclitem binary encoding
  2023-07-21 14:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: aclitem binary encoding
  2023-07-24 12:44 UTC  Dominique Devienne <ddevienne@gmail.com>
  [3+ messages in thread]

pageinspect bt_page_items doc
  2023-07-24 00:57 UTC  jian he <jian.universality@gmail.com>
` Re: pageinspect bt_page_items doc
  2023-07-24 01:46 UTC  Julien Rouhaud <rjuju123@gmail.com>
  [2+ messages in thread]

Effects of dropping a large table
  2023-07-18 17:58 UTC  Devin Ivy <devinivy@gmail.com>
` Re: Effects of dropping a large table
  2023-07-18 19:41 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: Effects of dropping a large table
  2023-07-19 08:17 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Effects of dropping a large table
  2023-07-19 23:15 UTC  David Rowley <dgrowleyml@gmail.com>
` Re: Effects of dropping a large table
  2023-07-19 23:33 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: Effects of dropping a large table
  2023-07-22 20:37 UTC  Gus Spier <gus.spier@gmail.com>
` Re: Effects of dropping a large table
  2023-07-23 09:51 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Effects of dropping a large table
  2023-07-23 10:09 UTC  Gus Spier <gus.spier@gmail.com>
` Re: Effects of dropping a large table
  2023-07-23 10:27 UTC  Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Effects of dropping a large table
  2023-07-23 20:05 UTC  Ron <ronljohnsonjr@gmail.com>
  [10+ messages in thread]

invalid value for parameter "default_text_search_config": "public.pg"
  2023-07-21 05:25 UTC  Les <nagylzs@gmail.com>
` Re: invalid value for parameter "default_text_search_config": "public.pg"
  2023-07-21 05:41 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: invalid value for parameter "default_text_search_config": "public.pg"
  2023-07-21 05:42 UTC  Les <nagylzs@gmail.com>
` Re: invalid value for parameter "default_text_search_config": "public.pg"
  2023-07-21 14:49 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: invalid value for parameter "default_text_search_config": "public.pg"
  2023-07-21 15:28 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: invalid value for parameter "default_text_search_config": "public.pg"
  2023-07-21 18:51 UTC  Les <nagylzs@gmail.com>
` Re: invalid value for parameter "default_text_search_config": "public.pg"
  2023-07-21 18:59 UTC  Les <nagylzs@gmail.com>
` Re: invalid value for parameter "default_text_search_config": "public.pg"
  2023-07-21 19:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: invalid value for parameter "default_text_search_config": "public.pg"
  2023-07-21 19:57 UTC  Les <nagylzs@gmail.com>
` Re: invalid value for parameter "default_text_search_config": "public.pg"
  2023-07-21 21:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: invalid value for parameter "default_text_search_config": "public.pg"
  2023-07-22 07:29 UTC  Les <nagylzs@gmail.com>
  [11+ messages in thread]

Moving data from huge table slow, min() query on indexed column taking 38s
  2023-07-06 15:00 UTC  Dimitrios Apostolou <jimis@gmx.net>
` Re: Moving data from huge table slow, min() query on indexed column taking 38s
  2023-07-06 16:11 UTC  Dimitrios Apostolou <jimis@gmx.net>
` Re: Moving data from huge table slow, min() query on indexed column taking 38s
  2023-07-06 21:42 UTC  Lorusso Domenico <domenico.l76@gmail.com>
` Re: Moving data from huge table slow, min() query on indexed column taking 38s
  2023-07-10 15:58 UTC  Dimitrios Apostolou <jimis@gmx.net>
` Re: Moving data from huge table slow, min() query on indexed column taking 38s
  2023-07-11 19:31 UTC  Lorusso Domenico <domenico.l76@gmail.com>
` Re: Moving data from huge table slow, min() query on indexed column taking 38s
  2023-07-21 07:20 UTC  Dimitrios Apostolou <jimis@gmx.net>
  [6+ messages in thread]

Server unable to UP after restore
  2023-07-21 04:06 UTC  Ram Pratap Maurya <ram.maurya@lavainternational.in>

fsync data directory after DB crash
  2023-07-18 08:50 UTC  Pandora <yeyukui@qq.com>
` Re: fsync data directory after DB crash
  2023-07-19 00:41 UTC  Michael Paquier <michael@paquier.xyz>
` Re: fsync data directory after DB crash
  2023-07-19 01:37 UTC  Thomas Munro <thomas.munro@gmail.com>
` Re: fsync data directory after DB crash
  2023-07-20 23:26 UTC  Thomas Munro <thomas.munro@gmail.com>
  [4+ messages in thread]

pg_upgradecluster fails if pg_hba.conf contains "@file" entries
  2023-07-20 17:18 UTC  Albrecht Dreß <albrecht.dress@posteo.de>

My 1st JDBC and PostgreSQL
  2023-07-20 00:37 UTC  Amn Ojee Uw <amnojeeuw@gmail.com>
` Re: My 1st JDBC and PostgreSQL
  2023-07-20 00:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: My 1st JDBC and PostgreSQL
  2023-07-20 01:11 UTC  Chuck Davis <cjgunzel@gmail.com>
` Re: My 1st JDBC and PostgreSQL
  2023-07-20 01:52 UTC  Jeffrey Walton <noloader@gmail.com>
` Re: My 1st JDBC and PostgreSQL
  2023-07-20 15:18 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: My 1st JDBC and PostgreSQL
  2023-07-20 15:21 UTC  Adrian Klaver <adrian.klaver@aklaver.com>
` Re: My 1st JDBC and PostgreSQL
  2023-07-20 16:44 UTC  Chuck Davis <cjgunzel@gmail.com>
  [7+ messages in thread]

TSQL To Postgres - Unpivot/Union All
  2023-07-20 11:29 UTC  Anthony Apollis <anthony.apollis@gmail.com>
` Fwd: TSQL To Postgres - Unpivot/Union All
  2023-07-20 12:17 UTC  Anthony Apollis <anthony.apollis@gmail.com>
` Re: TSQL To Postgres - Unpivot/Union All
  2023-07-20 12:48 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: TSQL To Postgres - Unpivot/Union All
  2023-07-20 13:58 UTC  Geoff Winkless <pgsqladmin@geoff.dj>
` Fwd: TSQL To Postgres - Unpivot/Union All
  2023-07-20 14:28 UTC  Anthony Apollis <anthony.apollis@gmail.com>
` Re: TSQL To Postgres - Unpivot/Union All
  2023-07-20 14:51 UTC  Geoff Winkless <pgsqladmin@geoff.dj>
` Re: Fwd: TSQL To Postgres - Unpivot/Union All
  2023-07-20 15:07 UTC  Thomas Kellerer <shammat@gmx.net>
` Re: TSQL To Postgres - Unpivot/Union All
  2023-07-20 15:47 UTC  Anthony Apollis <anthony.apollis@gmail.com>
  [8+ messages in thread]

Re:Re: How to improve the performance of my SQL query?
  2023-07-20 11:36 UTC  gzh <gzhcoder@126.com>


[next (older)]

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox