pgsql-general since 2022-03-27 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)
Advanced Search

Browse Archives

Prev | Next

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
Where is the best place to read for the paper around database? BeginnerC 23:34

April 5, 2022

Thread Author Time
JSON question Dave Ekhaus 04:45
Re: Select .... where id not in (....) returns 0 incorrectly J. Roeleveld 05:37
Re: Serializable read only deferrable- implications Michael Lewis 17:01
Re: Select .... where id not in (....) returns 0 incorrectly Mladen Gogala 23:25

April 6, 2022

Thread Author Time
Re: Select .... where id not in (....) returns 0 incorrectly Peter J. Holzer 06:19
Cascade view drop permission checks [email protected] 06:46
Re: Cascade view drop permission checks David G. Johnston 07:13
Re: Transaction and SQL errors Gilles Darold 08:26
Re: Transaction and SQL errors Sebastien Flaesch 08:56
Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) 📎 W.P. 08:57
Re: Cascade view drop permission checks [email protected] 10:04
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) Laurenz Albe 10:37
PostgreSQL 10.20 crashes / Antivirus Thomas, Richard 10:59
Re: Support logical replication of DDLs Ajin Cherian 11:37
Re: Cascade view drop permission checks David G. Johnston 12:16
Re: Cascade view drop permission checks Tom Lane 13:48
Re: Cascade view drop permission checks David G. Johnston 14:20
Re: PostgreSQL 10.20 crashes / Antivirus Adrian Klaver 14:41
RE: PostgreSQL 10.20 crashes / Antivirus Thomas, Richard 14:55
Re: PostgreSQL 10.20 crashes / Antivirus Adrian Klaver 15:17
Re: PostgreSQL 10.20 crashes / Antivirus Adrian Klaver 15:20
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) W.P. 16:41
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) Ron 16:54
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) Laura Smith 17:20
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) W.P. 18:04
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) Ray O'Donnell 18:06
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) Adrian Klaver 18:09
Per-Table vacuum_freeze_min_age Chris Bisnett 22:13
Re: Per-Table vacuum_freeze_min_age Tom Lane 22:22
Re: Per-Table vacuum_freeze_min_age Adrian Klaver 22:24
What have I done!?!?!? :-) Perry Smith 22:25
Re: Per-Table vacuum_freeze_min_age Chris Bisnett 22:28
Re: Per-Table vacuum_freeze_min_age Adrian Klaver 22:31
Re: What have I done!?!?!? :-) David G. Johnston 22:41
Re: Per-Table vacuum_freeze_min_age Chris Bisnett 22:45
Re: What have I done!?!?!? :-) Lionel Bouton 23:05
Re: What have I done!?!?!? :-) Perry Smith 23:15

April 7, 2022

Thread Author Time
Resources on modeling ordered hierachies? Tim Uckun 05:45
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) W.P. 06:23
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) Laurenz Albe 06:48
Reg. GET STACKED DIAGNOSTICS values to be stored in a single variable Maheswaran R 10:00
Re: Support logical replication of DDLs Amit Kapila 10:16
Re: Support logical replication of DDLs Amit Kapila 10:19
Re: Reg. GET STACKED DIAGNOSTICS values to be stored in a single variable Pavel Stehule 10:44
How to get updated order data Andrus 13:16
Re: What have I done!?!?!? :-) Jan Wieck 15:10
Re: Resources on modeling ordered hierachies? Peter J. Holzer 16:55
Re: Resources on modeling ordered hierachies? Rob Sargent 18:12
psql removes dashed comments Boris Zentner 18:25
Re: psql removes dashed comments Adrian Klaver 18:29
Re: psql removes dashed comments David G. Johnston 18:41
Re: psql removes dashed comments David G. Johnston 18:48
Re: psql removes dashed comments Boris Zentner 19:22
Re: psql removes dashed comments Tom Lane 20:27

April 8, 2022

Thread Author Time
Re: What have I done!?!?!? :-) Nikolay Samokhvalov 05:57
Could not read block 0 in file friend.have_00 07:01
PostgreSQL : error hint for LATERAL join PALAYRET Jacques 08:29
Re: Could not read block 0 in file Vijaykumar Jain 09:46
Re: Could not read block 0 in file Magnus Hagander 09:54
Re: Could not read block 0 in file Vijaykumar Jain 10:01
Re: Could not read block 0 in file Ron 10:01
Re: Could not read block 0 in file Vijaykumar Jain 10:22
Re: Support logical replication of DDLs Amit Kapila 11:00
Re: Support logical replication of DDLs Amit Kapila 11:13
Re: Support logical replication of DDLs Alvaro Herrera 11:34
Re: How to get updated order data Laurenz Albe 12:26
Re: What have I done!?!?!? :-) Jan Wieck 12:47
Re: What have I done!?!?!? :-) Magnus Hagander 12:58
Re: How to get updated order data Magnus Hagander 13:07
Re: What have I done!?!?!? :-) Jan Wieck 13:07
Re: What have I done!?!?!? :-) Magnus Hagander 13:10
Re: Support logical replication of DDLs Robert Haas 13:12
Re: What have I done!?!?!? :-) Perry Smith 13:22
Re: What have I done!?!?!? :-) Magnus Hagander 13:27
Re: What have I done!?!?!? :-) Perry Smith 13:27
Re: What have I done!?!?!? :-) Magnus Hagander 13:28
Re: PostgreSQL : error hint for LATERAL join David G. Johnston 13:36
Re: What have I done!?!?!? :-) Jan Wieck 13:58
Re: What have I done!?!?!? :-) Jan Wieck 14:01
Long running processes and commit writing to disk Shaozhong SHI 16:39
Long running processes and commit writing to disk Shaozhong SHI 16:39
RE: Long running processes and commit writing to disk Mike Sofen 16:52
Re: Long running processes and commit writing to disk Rob Sargent 17:05
Re: Problem with PG 11 database on OrangePi3 (ARMBIAN, ARM64) after disk disrupion (problem with USB disk connection) W.P. 17:18
FOR integer loop bug? Adrian Klaver 17:56
Re: FOR integer loop bug? Pavel Stehule 17:58
Re: Long running processes and commit writing to disk Ron 18:01
Re: FOR integer loop bug? Adrian Klaver 18:07
Re: FOR integer loop bug? Ron 18:23
Re: FOR integer loop bug? Adrian Klaver 19:27

April 9, 2022

Thread Author Time
Constraint ordering Perry Smith 14:42
Re: Constraint ordering David G. Johnston 15:01
Re: Constraint ordering Ron 15:05
Re: Constraint ordering Tom Lane 15:07

April 11, 2022

Thread Author Time
LDAP - Postgres server running on windows Joshua Price 04:57
Re: Support logical replication of DDLs Amit Kapila 05:00
Re: Support logical replication of DDLs Amit Kapila 05:04
Re: PostgreSQL : error hint for LATERAL join PALAYRET Jacques 08:00
Declarative partitioning and partition pruning/check Mats Taraldsvik 12:07
Re: Support logical replication of DDLs Euler Taveira 12:46
DBlink extension and behavior of dblink_get_connections() Pankaj Gupta 13:00
Re: PostgreSQL : error hint for LATERAL join Tom Lane 14:20
Re: PostgreSQL : error hint for LATERAL join David G. Johnston 16:05
Re: Support logical replication of DDLs Zheng Li 16:42
Re: Support logical replication of DDLs Zheng Li 17:31
Re: Support logical replication of DDLs Zheng Li 17:36

Browse Archives

Prev | Next