pgsql-general since 2024-01-24 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

Jan. 24, 2024

Thread Author Time
Providers missing from pgdg-common for GDAL 3.7 (related to multiple missing providers from pgdg-common) James Colannino 00:55
Re: Need assistance for running postgresql procedures Sasmit Utkarsh 04:44
Re: how to trace a backend session Dominique Devienne 08:16
about statement execution times in the logs Mickaël SALMON 10:48
Re: about statement execution times in the logs Adrian Klaver 17:03
Re: Providers missing from pgdg-common for GDAL 3.7 (related to multiple missing providers from pgdg-common) Bruce Momjian 21:46

Jan. 25, 2024

Thread Author Time
Re: undefined symbol when installing pgcrypto on 16.1 Michael Nolan 00:09
Re: undefined symbol when installing pgcrypto on 16.1 Michael Nolan 00:23
Re: undefined symbol when installing pgcrypto on 16.1 Tom Lane 00:45
Re: undefined symbol when installing pgcrypto on 16.1 Michael Nolan 01:32
Re: undefined symbol when installing pgcrypto on 16.1 Tom Lane 01:35
Clarification regarding managing advisory locks in postgresql Sasmit Utkarsh 03:17
Re: Clarification regarding managing advisory locks in postgresql Christophe Pettus 05:11
Re: Clarification regarding managing advisory locks in postgresql Sasmit Utkarsh 10:43
[No subject] Ron Johnson 17:18
Re: Tom Lane 17:29
permission denied on socket Atul Kumar 20:22
Re: Ron Johnson 20:24
Re: permission denied on socket Adrian Klaver 20:32
Re: permission denied on socket Ron Johnson 20:32
Re: permission denied on socket Ron Johnson 20:39
Re: permission denied on socket Adrian Klaver 21:14
field error on refreshed materialized view Michael Nolan 21:29
Re: permission denied on socket Tom Lane 21:30
Re: field error on refreshed materialized view Adrian Klaver 21:32
Re: field error on refreshed materialized view Tom Lane 21:38
Re: field error on refreshed materialized view Michael Nolan 21:51

Jan. 26, 2024

Thread Author Time
Re: permission denied on socket Atul Kumar 02:40
Re: permission denied on socket Tom Lane 03:45
Feature Request: log_line_prefix %h Counterpart Jawala 04:34
Re: Laurenz Albe 08:23
Re: permission denied on socket pf 18:34

Jan. 27, 2024

Thread Author Time
Re: Emitting JSON to file using COPY TO 📎 Junwang Zhao 05:55
Re: field error on refreshed materialized view Michael Nolan 20:28
Re: field error on refreshed materialized view Tom Lane 21:27

Jan. 28, 2024

Thread Author Time
Query performance in 9.6.24 vs 14.10 Ron Johnson 18:36

Jan. 29, 2024

Thread Author Time
Re: Query performance in 9.6.24 vs 14.10 David Rowley 03:44
Re: Query performance in 9.6.24 vs 14.10 Ron Johnson 07:55
Scriptable way to validate a pg_dump restore ? Laura Smith 08:12
Re: Scriptable way to validate a pg_dump restore ? Shaheed Haque 09:03
Re: Scriptable way to validate a pg_dump restore ? Ron Johnson 09:06
Re: Query performance in 9.6.24 vs 14.10 Bob Jolliffe 12:08
Re: Query performance in 9.6.24 vs 14.10 Ron Johnson 14:18
Re: Scriptable way to validate a pg_dump restore ? Adrian Klaver 16:52
Re: Query performance in 9.6.24 vs 14.10 Ron Johnson 16:52
Re: Scriptable way to validate a pg_dump restore ? Shaheed Haque 17:28
Re: Scriptable way to validate a pg_dump restore ? Adrian Klaver 17:57
Re: Scriptable way to validate a pg_dump restore ? Shaheed Haque 18:12
Re: Query performance in 9.6.24 vs 14.10 Bob Jolliffe 18:21
Re: Scriptable way to validate a pg_dump restore ? Adrian Klaver 18:27
Re: Scriptable way to validate a pg_dump restore ? Laura Smith 19:20
Seeking help extricating data from Amazon RDS Aurora/Postgres Bill Mitchell 19:22
Re: Seeking help extricating data from Amazon RDS Aurora/Postgres Christophe Pettus 19:25
Re: Scriptable way to validate a pg_dump restore ? Shaheed Haque 19:35
Best practices for data buffer cache setting/tuning (v15) David Gauthier 19:39
Re: Best practices for data buffer cache setting/tuning (v15) Laurenz Albe 21:05
Re: Seeking help extricating data from Amazon RDS Aurora/Postgres Alan Hodgson 21:12
Re: Best practices for data buffer cache setting/tuning (v15) Christophe Pettus 21:46
Re: What should I expect when creating many logical replication slots? Klaus Darilion 23:01
Re: Scriptable way to validate a pg_dump restore ? Adrian Klaver 23:02
Re: Monitoring logical replication Klaus Darilion 23:15

Jan. 30, 2024

Thread Author Time
Re: Best practices for data buffer cache setting/tuning (v15) Bruce Momjian 03:56
Good overview of programming IN Postgres? Guyren Howe 05:19
building a singularity image from docker hub postgres image Allan Kamau 05:52
Re: building a singularity image from docker hub postgres image Justin Clift 09:27
Re: Monitoring logical replication Shaheed Haque 11:27
Re: Scriptable way to validate a pg_dump restore ? Shaheed Haque 11:29
Re: Scriptable way to validate a pg_dump restore ? Shaheed Haque 11:32
Write Logical Replication Spill Files to different volume Klaus Darilion 13:08
Re: Good overview of programming IN Postgres? Joshua Kacsir 13:54

Jan. 31, 2024

Thread Author Time
Re: Emitting JSON to file using COPY TO vignesh C 09:49
Re: Emitting JSON to file using COPY TO Junwang Zhao 09:58
Re: Emitting JSON to file using COPY TO Alvaro Herrera 13:26
vacuum freeze wait_event BufferPin abrahim abrahao 19:05

Feb. 1, 2024

Thread Author Time
Postgresql BUG / Help Needed Johnathan Tiamoh 05:48
Query to fetch the list of tables that have cascade constraints enabled Satalabaha Postgres 05:48
Re: Query to fetch the list of tables that have cascade constraints enabled David G. Johnston 06:08
Issue in Postgres Client 14.9 with OpenSSL 3.2.0 M Tarkeshwar Rao 06:47
Issue in Postgres Client 14.9 with OpenSSL 3.2.0 David G. Johnston 07:04
Re: Postgresql BUG / Help Needed Laurenz Albe 07:36
support fix query_id for temp table ma lz 07:37
Re: support fix query_id for temp table Michael Paquier 08:46
TableOID in description of inlined function Marius Lorek 09:22
Re: building a singularity image from docker hub postgres image Allan Kamau 10:50
using palloc/pfree for OpenSSL allocations with CRYPTO_set_mem_functions Evan Czaplicki 12:46
Re: Postgresql BUG / Help Needed Johnathan Tiamoh 13:28
Re: Postgresql BUG / Help Needed Jehan-Guillaume de Rorthais 14:06
Re: Postgresql BUG / Help Needed Johnathan Tiamoh 14:10
Re: TableOID in description of inlined function Tom Lane 15:15
Re: using palloc/pfree for OpenSSL allocations with CRYPTO_set_mem_functions Tom Lane 16:01
Re: Postgresql BUG / Help Needed Adrian Klaver 16:19
Re: Postgresql BUG / Help Needed Adrian Klaver 17:33
Query running longer veem v 20:57
Re: Query running longer Laurenz Albe 21:13
Re: Query running longer Ron Johnson 23:22

Feb. 2, 2024

Thread Author Time
Logical replication and AFTER UPDATE triggers [PG 16] Chris Angelico 02:20
Re: Query running longer veem v 04:44
Re: Emitting JSON to file using COPY TO jian he 08:25
Re: Query running longer Laurenz Albe 08:37
Re: using palloc/pfree for OpenSSL allocations with CRYPTO_set_mem_functions Evan Czaplicki 08:57
Re: Emitting JSON to file using COPY TO Alvaro Herrera 09:47
Re: Emitting JSON to file using COPY TO jian he 10:05
Re: vacuum freeze wait_event BufferPin Greg Sabino Mullane 18:36
Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common Marcelo Marques 19:05
Re: vacuum freeze wait_event BufferPin 📎 abrahim abrahao 20:25
update schema table permission denied Vano Beridze 22:18
Re: update schema table permission denied Tom Lane 22:22

Feb. 3, 2024

Thread Author Time
Re: vacuum freeze wait_event BufferPin Greg Sabino Mullane 01:15
Re: Logical replication and AFTER UPDATE triggers [PG 16] Chris Angelico 06:06
How to do faster DML Lok P 12:20
Re: How to do faster DML Lok P 13:55
Re: How to do faster DML Todd Lewis 13:58
Re: How to do faster DML Ron Johnson 14:06
Re: How to do faster DML Lok P 16:09
Re: How to do faster DML Greg Sabino Mullane 18:28
Re: How to do faster DML Francisco Olarte 19:20
Re: How to do faster DML Peter J. Holzer 20:29
Re: How to do faster DML Lok P 20:44

Feb. 4, 2024

Thread Author Time
Re: How to do faster DML Peter J. Holzer 11:05
Re: How to do faster DML Alban Hertroys 11:19
Re: How to do faster DML Francisco Olarte 11:31
Re: How to do faster DML Marcos Pegoraro 12:59
Re: How to do faster DML Dennis White 14:44
Re: How to do faster DML Lok P 15:30
Re: How to do faster DML Greg Sabino Mullane 15:47
Re: How to do faster DML Ron Johnson 15:54
Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common Marcelo Marques 18:42
Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY Sean v 20:08
Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common Adrian Klaver 20:33
Re: How to do faster DML Lok P 20:51
Re: How to do faster DML Lok P 21:25
Question on partitioning veem v 21:39
select from composite type Lorusso Domenico 22:50
Re: How to do faster DML Ron Johnson 23:15
Re: Question on partitioning Ron Johnson 23:40

Feb. 5, 2024

Thread Author Time
Re: select from composite type Adrian Klaver 00:39
Re: select from composite type David G. Johnston 00:48
bug/confusion with pg_log_standby_snapshot() Pete O'Such 04:41
Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common Devrim Gündüz 08:47
Re: How to do faster DML Lok P 11:21
Re: Question on partitioning Laurenz Albe 12:22
Unused indexes arun chirappurath 14:01
Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY Ron Johnson 15:54
Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY David G. Johnston 15:58
Re: Unused indexes Ron Johnson 16:03
Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common Devrim Gündüz 16:18
Re: Question on partitioning veem v 18:56
Improving pg_dump performance when handling large numbers of LOBs Wyatt Tellis 19:00
Re: How to do faster DML veem v 19:24
Re: Improving pg_dump performance when handling large numbers of LOBs Ron Johnson 19:35
Re: Improving pg_dump performance when handling large numbers of LOBs Adrian Klaver 19:53
Re: Improving pg_dump performance when handling large numbers of LOBs Wyatt Tellis 19:55
Re: Improving pg_dump performance when handling large numbers of LOBs Andreas Joseph Krogh 20:05
Re: Improving pg_dump performance when handling large numbers of LOBs Wyatt Tellis 20:10
Re: Improving pg_dump performance when handling large numbers of LOBs Ron Johnson 20:15
Re: Improving pg_dump performance when handling large numbers of LOBs Andreas Joseph Krogh 20:17
Re: Improving pg_dump performance when handling large numbers of LOBs Ken Marshall 20:32
Re: Improving pg_dump performance when handling large numbers of LOBs Tom Lane 20:38
Re: Improving pg_dump performance when handling large numbers of LOBs Adrian Klaver 20:52
Log pre-master keys during TLS v1.3 handshake Максим Чистяков 21:38
Deleting duplicate rows using ctid ? David Gauthier 23:08
Re: Deleting duplicate rows using ctid ? David G. Johnston 23:32

Feb. 6, 2024

Thread Author Time
Re: select from composite type Lorusso Domenico 00:01
Re: select from composite type Lorusso Domenico 00:35
Re: select from composite type Adrian Klaver 00:41
Re: Unused indexes Greg Sabino Mullane 02:53
Re: How to do faster DML Greg Sabino Mullane 03:04
Re: How to do faster DML Lok P 03:57
Re: How to do faster DML Greg Sabino Mullane 04:56
Re: How to do faster DML Lok P 05:15
Re: How to do faster DML veem v 05:55
Re: Improving pg_dump performance when handling large numbers of LOBs Shaheed Haque 07:31
Problem managing slots in Patroni Fabrice Chapuis 08:03
Re: Unused indexes Ron Johnson 09:32
Re: Log pre-master keys during TLS v1.3 handshake Daniel Gustafsson 09:43
Re: Question on partitioning Laurenz Albe 10:16
Re: Deleting duplicate rows using ctid ? Andreas Kretschmer 17:45
Exclude certain application pgaudit logging? Ron Johnson 18:11
Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common Marcelo Marques 18:12
Re: Exclude certain application pgaudit logging? Adrian Klaver 18:18
Re: Exclude certain application pgaudit logging? Christophe Pettus 18:21
Re: Exclude certain application pgaudit logging? Adrian Klaver 18:23
Re: Yum Update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86_64 from pgdg-common Marcelo Marques 19:06
Re: Question on partitioning veem v 19:39
Re: Question on partitioning Ron Johnson 19:55

Feb. 7, 2024

Thread Author Time
Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY Sean v 07:06
Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY Olivier Gautherot 07:20
Generic File Access Function to read program output Carsten Klein 10:28
archive command doesnt work Alpaslan AKDAĞ 11:07
Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY David Rowley 12:18
Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb" Marco Aurelio 14:09
Re: Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb" Daniel Gustafsson 14:17
Re: Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb" Marco Aurelio 14:40
Re: Generic File Access Function to read program output Joe Conway 14:54
Re: Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb" Tom Lane 15:12
Re: Generic File Access Function to read program output Carsten Klein 15:47
Re: Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb" Marco Aurelio 17:53
Re: vacuum freeze wait_event BufferPin abrahim abrahao 19:59
Re: archive command doesnt work Laurenz Albe 20:06

Feb. 8, 2024

Thread Author Time
Re: How to do faster DML Lok P 05:12

Browse Archives

Prev | Next