pgsql-general - February 2024

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

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
Partitioning options sud 05:42
Re: archive command doesnt work Alpaslan AKDAĞ 08:23
Re: Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb" Daniel Gustafsson 13:00
cookiecutter template for Postgres extensions Florents Tselai 13:09
Re: How to do faster DML Greg Sabino Mullane 14:31
Re: Partitioning options Greg Sabino Mullane 14:38
Fwd: pgadmin not opening in concurrent sessions Siraj G 15:27
Re: Fwd: pgadmin not opening in concurrent sessions Adrian Klaver 15:56
Re: Clarification regarding managing advisory locks in postgresql Merlin Moncure 19:34
Re: Partitioning options veem v 19:43
Re: archive command doesnt work Laurenz Albe 20:10
Re: archive command doesnt work Mateusz Henicz 20:24
Re: archive command doesnt work Alpaslan AKDAĞ 20:28
Re: Partitioning options Jim Nasby 20:34
Re: archive command doesnt work Alpaslan AKDAĞ 20:35
Re: archive command doesnt work Mateusz Henicz 20:38
Re: archive command doesnt work Alpaslan AKDAĞ 20:47
Re: Partitioning options Greg Sabino Mullane 20:50
Re: Clarification regarding managing advisory locks in postgresql Greg Sabino Mullane 20:54
Re: Partitioning options Justin 21:25
Re: archive command doesnt work Laurenz Albe 22:23

Feb. 9, 2024

Thread Author Time
Migrate schemas Lorusso Domenico 00:18
Re: Migrate schemas Adrian Klaver 00:31
Multiple connections over VPN password fail error Sanjay Minni 07:41
Re: Multiple connections over VPN password fail error Daniel Gustafsson 07:56
Re: Multiple connections over VPN password fail error Sanjay Minni 09:14
Re: Multiple connections over VPN password fail error Sanjay Minni 09:34
Re: Multiple connections over VPN password fail error Laurenz Albe 11:59
Re: Partitioning options Marc Millas 15:29

Feb. 10, 2024

Thread Author Time
How should we design our tables and indexes veem v 19:38

Feb. 11, 2024

Thread Author Time
Re: How to do faster DML Peter J. Holzer 00:25
Re: How should we design our tables and indexes Greg Sabino Mullane 05:13
Re: How should we design our tables and indexes veem v 07:23
Re: How should we design our tables and indexes Michał Kłeczek 07:29
Re: How to do faster DML veem v 07:55
Re: How should we design our tables and indexes Karsten Hilbert 09:36
Re: How to do faster DML Laurenz Albe 11:00
Re: How to do faster DML Peter J. Holzer 13:32
Re: Partitioning options Justin 14:25
Re: How to do faster DML veem v 16:53
Re: How to do faster DML David G. Johnston 16:59
Re: How to do faster DML Ron Johnson 17:08
Query hangs (and then timeout) after using COPY to import data steott 21:37
Re: Query hangs (and then timeout) after using COPY to import data Adrian Klaver 21:41
Re: How to do faster DML Peter J. Holzer 22:10
Re: How to do faster DML Peter J. Holzer 22:22
Re: Query hangs (and then timeout) after using COPY to import data Ron Johnson 23:12
RE: Query hangs (and then timeout) after using COPY to import data steott 23:13
Re: Query hangs (and then timeout) after using COPY to import data Ron Johnson 23:27
Re: Query hangs (and then timeout) after using COPY to import data Tom Lane 23:43

Feb. 12, 2024

Thread Author Time
Re: How to do faster DML veem v 06:50
Safest pgupgrade jump distance Dávid Suchan 10:07
Re: Safest pgupgrade jump distance Justin Clift 10:15
Re: How to do faster DML Dominique Devienne 10:30
Re: Safest pgupgrade jump distance Johnathan Tiamoh 13:31
Re: Safest pgupgrade jump distance Ron Johnson 14:31
Re: Safest pgupgrade jump distance Karsten Hilbert 16:07
Re: How to do faster DML Greg Sabino Mullane 16:17
Re: How to do faster DML Greg Sabino Mullane 16:28
Re: Query hangs (and then timeout) after using COPY to import data Adrian Klaver 16:42
Re: How should we design our tables and indexes Greg Sabino Mullane 16:46
Re: Safest pgupgrade jump distance Tom Lane 16:52
Re: Safest pgupgrade jump distance Greg Sabino Mullane 16:54
Re: Query hangs (and then timeout) after using COPY to import data Adrian Klaver 17:01
Re: How should we design our tables and indexes veem v 19:04
Re: How should we design our tables and indexes Greg Sabino Mullane 19:12
Re: How to do faster DML veem v 20:23
Re: How to do faster DML Ron Johnson 20:30
Re: How to do faster DML veem v 20:43

Feb. 13, 2024

Thread Author Time
Compressing large column by moving it to a unique table Adrian Garcia Badaracco 03:11
Re: Compressing large column by moving it to a unique table Ron Johnson 06:16
MAT. VIEW security problems and PG 10-11 versions? Durumdara 07:56
Re: MAT. VIEW security problems and PG 10-11 versions? Daniel Gustafsson 08:43
FOR UPDATE SKIP LOCKED and get locked row/avoid updating other row(s) Wiwwo Staff 11:17

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29