pgsql-general since 2022-03-15 00:00

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

March 15, 2022

Thread Author Time
Re: Indexes that would span partitions. Michael Lewis 06:18
Re: Support logical replication of DDLs rajesh singarapu 06:27
Re: Restoring using PG_DUMP in PG12 results in Shukla, Pranjal 06:42
Postgres Crash Issue 📎 Sankar, Uma (Uma) 07:20
Re: Indexes that would span partitions. Tim Uckun 07:32
Re: LISTEN/NOTIFY ultra slow speed 📎 Арсен Арутюнян 07:34
Re[2]: LISTEN/NOTIFY ultra slow speed Арсен Арутюнян 10:39
Re: Postgres Crash Issue hubert depesz lubaczewski 13:27
RE: [External]Re: Postgres Crash Issue Menon, Deepak (Deepak) 13:30
Re: [External]Re: Postgres Crash Issue hubert depesz lubaczewski 13:32
RE: [External]Re: Postgres Crash Issue Menon, Deepak (Deepak) 13:38
Re: [External]Re: Postgres Crash Issue hubert depesz lubaczewski 13:42
Re: [External]Re: Postgres Crash Issue Tom Lane 14:17
Re: Re[2]: LISTEN/NOTIFY ultra slow speed Tom Lane 14:32
Re: Restoring using PG_DUMP in PG12 results in Adrian Klaver 15:49
Corrupt Index Jorel Casal 16:01
Re: Corrupt Index Tom Lane 16:41
Re: [External]Re: Postgres Crash Issue Adrian Klaver 17:40
Re[4]: LISTEN/NOTIFY ultra slow speed Арсен Арутюнян 20:48

March 16, 2022

Thread Author Time
Apparently table locks are the key issue to see red flags Shaozhong SHI 20:14
Apparently table locks are the key issue to see red flags Shaozhong SHI 20:15
Re: Apparently table locks are the key issue to see red flags Ron 20:21
Re: Apparently table locks are the key issue to see red flags Adrian Klaver 20:23
How to explicitly lock and unlock tables in pgsql? Shaozhong SHI 20:30
How to explicitly lock and unlock tables in pgsql? Shaozhong SHI 20:30
Apparently table locks are the key issue to see red flags Shaozhong SHI 20:32
Re: How to explicitly lock and unlock tables in pgsql? Fabrízio de Royes Mello 20:35
Re: Support logical replication of DDLs 📎 Zheng Li 21:17
Re: Support logical replication of DDLs Alvaro Herrera 22:06

March 17, 2022

Thread Author Time
Re: Support logical replication of DDLs Japin Li 00:08
Re: How to explicitly lock and unlock tables in pgsql? Laurenz Albe 07:51
Re: PSQL bug? Pavel Stehule 10:38
PSQL bug? Dominique Devienne 10:38
Re: PSQL bug? Dominique Devienne 11:09
Re: PSQL bug? Josef Šimánek 11:32
Query on WAL Optimization and Streaming Replication Shukla, Pranjal 12:36
High Postgres postmaster CPU when My Background Worker is loaded. GoLang Developere 12:58
Re: Query on WAL Optimization and Streaming Replication Laurenz Albe 13:19
Re: Apparently table locks are the key issue to see red flags Jayson Hreczuck 13:21
Re: Query on WAL Optimization and Streaming Replication Shukla, Pranjal 14:05
Re: Query on WAL Optimization and Streaming Replication Laurenz Albe 14:38
Re: Query on WAL Optimization and Streaming Replication Shukla, Pranjal 15:21
Re: Support logical replication of DDLs Japin Li 15:56
Re: Support logical replication of DDLs Zheng Li 16:22
Re[5]: LISTEN/NOTIFY ultra slow speed Арсен Арутюнян 18:34

March 18, 2022

Thread Author Time
Re: Support logical replication of DDLs 📎 Zheng Li 00:18
Re: Support logical replication of DDLs Japin Li 00:22
Re: Support logical replication of DDLs Japin Li 00:25
Re: Support logical replication of DDLs Japin Li 00:38
Re: PSQL bug? Kyotaro Horiguchi 00:52
Re: Support logical replication of DDLs Japin Li 10:19
Re: How to explicitly lock and unlock tables in pgsql? Merlin Moncure 16:38
Re: Support logical replication of DDLs Zheng Li 17:25
Re: Support logical replication of DDLs Zheng Li 17:29
Re: How to explicitly lock and unlock tables in pgsql? Laurenz Albe 22:48
Re: Support logical replication of DDLs Japin Li 23:33

March 21, 2022

Thread Author Time
Re: Support logical replication of DDLs Dilip Kumar 08:13
Re: Support logical replication of DDLs Zheng Li 20:56
Can you install/run postgresql on a FIPS enabled host? McDermott, Becky 22:15
Re: Can you install/run postgresql on a FIPS enabled host? Adrian Klaver 22:24
Re: Can you install/run postgresql on a FIPS enabled host? Tom Lane 22:33
RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? McDermott, Becky 22:43
Re: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? Adrian Klaver 22:45
RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? McDermott, Becky 22:47
RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? McDermott, Becky 22:52
RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? McDermott, Becky 22:55
Re: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? Rob Sargent 22:57
Re: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? Tom Lane 22:59
RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? McDermott, Becky 23:02
Re: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? Rob Sargent 23:08
RE: [EXTERNAL] Re: Can you install/run postgresql on a FIPS enabled host? McDermott, Becky 23:16

March 22, 2022

Thread Author Time
PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause PALAYRET Jacques 09:45
Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause Torsten Förtsch 10:16
Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause Guillaume Lelarge 10:42
PG12: Any drawback of increasing wal_keep_segments Shukla, Pranjal 11:32
Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause David G. Johnston 12:42
Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause PALAYRET Jacques 12:48
Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause David G. Johnston 13:04
Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause PALAYRET Jacques 15:03
Re: PostgreSQL : bug (ou not) in CTE Common Table Expressions or Subqueries in the FROM Clause David Rowley 15:26

March 23, 2022

Thread Author Time
Re: Can you install/run postgresql on a FIPS enabled host? Michael Paquier 04:19
Re: Support logical replication of DDLs 📎 Japin Li 05:09
Open SSL Version Query Sahaj Diwan 11:48
Re: Open SSL Version Query Laura Smith 14:23
Unexpected zero results Viliam Ďurina 16:56
Re: Unexpected zero results Thomas Kellerer 17:00
Re: Unexpected zero results Viliam Ďurina 17:10
Re: Unexpected zero results David G. Johnston 22:51
Re: Unexpected zero results Tom Lane 22:57

March 24, 2022

Thread Author Time
Re: Support logical replication of DDLs Dilip Kumar 10:02
Re: PG12: Any drawback of increasing wal_keep_segments Alvaro Herrera 10:25
Re: Support logical replication of DDLs Dilip Kumar 11:36
Get primary key of a table through SPI Oskar Stenberg 15:49
Re: Get primary key of a table through SPI Tom Lane 15:59
Re: Support logical replication of DDLs Zheng Li 17:54

March 25, 2022

Thread Author Time
Leading comments and client applications Philip Semanchuk 15:32
Re: Leading comments and client applications David G. Johnston 15:46
Re: Leading comments and client applications Tom Lane 15:59
Re: Leading comments and client applications Rob Sargent 16:25
Re: Leading comments and client applications Peter J. Holzer 17:37
Re: Leading comments and client applications Philip Semanchuk 18:05
Re: Leading comments and client applications Tom Lane 19:30
Re: Leading comments and client applications Rob Sargent 19:35

March 26, 2022

Thread Author Time
Re: Leading comments and client applications Laurenz Albe 05:08
dynamically generate path to output file [email protected] 09:35
In what situation, a line feature could not be visible in PgAdmin? Shaozhong SHI 12:12
Re: dynamically generate path to output file Osvaldo Kussama 12:48

March 27, 2022

Thread Author Time
support for DIN SPEC 91379 encoding Marco Lechner 10:54
Re: support for DIN SPEC 91379 encoding Ralf Schuchardt 14:14
Performance issues on FK Triggers after replacing a primary column Per Kaminsky 16:30
Re: support for DIN SPEC 91379 encoding Alvaro Herrera 17:47
Re: support for DIN SPEC 91379 encoding Tom Lane 18:06
Re: support for DIN SPEC 91379 encoding Bzm@g 18:08
Re: Performance issues on FK Triggers after replacing a primary column Adrian Klaver 21:22
Re: support for DIN SPEC 91379 encoding Peter J. Holzer 23:34

March 28, 2022

Thread Author Time
Re: Performance issues on FK Triggers after replacing a primary column Per Kaminsky 06:53
Re: Performance issues on FK Triggers after replacing a primary column Per Kaminsky 07:22
Re: support for DIN SPEC 91379 encoding Alvaro Herrera 08:13
Will using subtransactions will come back to bite me? Kannan Goundan 08:49
Re: Leading comments and client applications Philippe Doussot 09:42
Re: Performance issues on FK Triggers after replacing a primary column Tom Lane 14:07
Re: Will using subtransactions will come back to bite me? Laurenz Albe 15:31
Re: Performance issues on FK Triggers after replacing a primary column Adrian Klaver 15:41
Re: Performance issues on FK Triggers after replacing a primary column Per Kaminsky 15:47
Re: Performance issues on FK Triggers after replacing a primary column Adrian Klaver 15:59
Re: Performance issues on FK Triggers after replacing a primary column Per Kaminsky 16:39
Re: Performance issues on FK Triggers after replacing a primary column Adrian Klaver 16:41
Re: Performance issues on FK Triggers after replacing a primary column Adrian Klaver 16:49
Re: Leading comments and client applications Philip Semanchuk 17:35
Re: Performance issues on FK Triggers after replacing a primary column Per Kaminsky 17:49
Re: Performance issues on FK Triggers after replacing a primary column Adrian Klaver 17:56

March 29, 2022

Thread Author Time
Re: Support logical replication of DDLs Dilip Kumar 04:17
Indexes in JSONB Saurav Sarkar 05:05
Re: Indexes in JSONB Magnus Hagander 08:49
Re: Indexes in JSONB Michael Lewis 14:32
Re: Indexes in JSONB Saurav Sarkar 15:12
Re: PG12: Any drawback of increasing wal_keep_segments Stephen Frost 15:17
Why is my function inlined only when STABLE? Philip Semanchuk 18:05
Re: Why is my function inlined only when STABLE? Tom Lane 18:24
Re: Why is my function inlined only when STABLE? Philip Semanchuk 18:43

March 30, 2022

Thread Author Time
psql -f and PAGER Paul Jungwirth 01:30
Re: psql -f and PAGER David G. Johnston 02:08
Reg: User creation script/List of privileges Sai Ch 03:09
Re: psql -f and PAGER Peter J. Holzer 06:57
Re: Reg: User creation script/List of privileges Tomas Pospisek 16:19

March 31, 2022

Thread Author Time
PostgreSQL on focal and llvm version Christoph Berg 14:01
Re: PG12: Any drawback of increasing wal_keep_segments Marc 16:58
Re: PG12: Any drawback of increasing wal_keep_segments Stephen Frost 16:59
Locking a table read-only temporarilty 📎 Digimer 19:20

April 1, 2022

Thread Author Time
Does PGDG apt repository support ARM64? Daniele Varrazzo 01:22
Re: Does PGDG apt repository support ARM64? Adrian Klaver 04:07
Re: Does PGDG apt repository support ARM64? Daniele Varrazzo 06:27
Re: Does PGDG apt repository support ARM64? Daniele Varrazzo 06:48
Re: Locking a table read-only temporarilty Laurenz Albe 07:04
weird issue with occasional stuck queries 📎 spiral 07:06
Re: Does PGDG apt repository support ARM64? Magnus Hagander 14:28
Re: Does PGDG apt repository support ARM64? Daniele Varrazzo 14:51
Re: Does PGDG apt repository support ARM64? Magnus Hagander 15:00
Re: Does PGDG apt repository support ARM64? Daniele Varrazzo 15:08
Re: Does PGDG apt repository support ARM64? Magnus Hagander 15:22
LISTEN - ERROR: could not access status of transaction 3021015672 Aleš Zelený 15:43
Re: Does PGDG apt repository support ARM64? Adrian Klaver 18:04
Re: weird issue with occasional stuck queries Adam Scott 22:53

April 2, 2022

Thread Author Time
How long does iteration over 4-5 million rows usually take? Shaozhong SHI 01:34
How long does iteration over 4-5 million rows usually take? Shaozhong SHI 01:35
Re: How long does iteration over 4-5 million rows usually take? Adrian Klaver 01:47
Re: How long does iteration over 4-5 million rows usually take? Ron 02:18
Re: weird issue with occasional stuck queries spiral 12:23
Re: How long does iteration over 4-5 million rows usually take? Rob Sargent 13:21
Aw: Re: How long does iteration over 4-5 million rows usually take? Karsten Hilbert 13:46
Re: Re: How long does iteration over 4-5 million rows usually take? Shaozhong SHI 14:16
Re: Re: How long does iteration over 4-5 million rows usually take? Benedict Holland 14:34
Re: How long does iteration over 4-5 million rows usually take? Steve Midgley 16:38
Re: weird issue with occasional stuck queries Adam Scott 19:09

April 3, 2022

Thread Author Time
Re: weird issue with occasional stuck queries overland 02:08

April 4, 2022

Thread Author Time
PostgreSQL JSON Dave Ekhaus 01:47
Re: PostgreSQL JSON David G. Johnston 01:57
gist segmentation fault 📎 Arup Nanda 08:35
Transaction and SQL errors Sebastien Flaesch 11:33
Re: Transaction and SQL errors Karsten Hilbert 11:37
Re: Transaction and SQL errors David Rowley 11:44
Select .... where id not in (....) returns 0 incorrectly J. Roeleveld 12:08
Re: Transaction and SQL errors Sebastien Flaesch 12:38
Re: Transaction and SQL errors Sebastien Flaesch 12:41
Re: Select .... where id not in (....) returns 0 incorrectly Ravi Krishna 12:44
Re: Select .... where id not in (....) returns 0 incorrectly Jeremy Smith 12:50
Re: Select .... where id not in (....) returns 0 incorrectly J. Roeleveld 13:21
Re: Transaction and SQL errors J. Roeleveld 13:26
Re: Transaction and SQL errors David G. Johnston 13:47
Re: gist segmentation fault Tom Lane 14:12
Trigger functions and FDW tables Michael Nolan 14:18
Re: Trigger functions and FDW tables Laurenz Albe 14:23
Re: gist segmentation fault Arup Nanda 14:45
Re: PostgreSQL on focal and llvm version Christoph Berg 14:56
how to find out field size? Shaozhong SHI 15:28
Re: how to find out field size? Adrian Klaver 15:37
Re: Trigger functions and FDW tables Michael Nolan 16:15
Re: Transaction and SQL errors Sebastien Flaesch 16:20
Re: Select .... where id not in (....) returns 0 incorrectly David Rowley 20:47
Load Balancer with PostgreSQL Lucas 23:14

Browse Archives

Prev | Next