pgsql-general  

Messages by Thread

• dead tuple difference between pgstattuple and pg_stat_user_tables Matthew Tice
  • Re: dead tuple difference between pgstattuple and pg_stat_user_tables Adrian Klaver
  • Re: dead tuple difference between pgstattuple and pg_stat_user_tables Matthew Tice
  • Re: dead tuple difference between pgstattuple and pg_stat_user_tables Adrian Klaver
  • Re: dead tuple difference between pgstattuple and pg_stat_user_tables Adrian Klaver
• On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null? Koen De Groote
  • Re: On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null? Adrian Klaver
  • Re: On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null? Koen De Groote
  • Re: On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null? Adrian Klaver
• Where is my app installed? Arbol One
  • Re: Where is my app installed? Adrian Klaver
  • Re: Where is my app installed? Tom Lane
  • Re: Where is my app installed? Adrian Klaver
  • Re: Where is my app installed? Muhammad Ikram
  • Re: Where is my app installed? Adrian Klaver
  • Re: Where is my app installed? Arbol One
  • Re: Where is my app installed? Alan Hodgson
• where is postres installed? Arbol One
  • Re: where is postres installed? Muhammad Usman Khan
  • Re: where is postres installed? Muhammad Ikram
  • Re: where is postres installed? Kashif Zeeshan
  • Re: where is postres installed? Ron Johnson
• Is there a way to translate pg_amop.amopstrategy into a description? Morris de Oryx
  • Re: Is there a way to translate pg_amop.amopstrategy into a description? Tom Lane
  • Re: Is there a way to translate pg_amop.amopstrategy into a description? Morris de Oryx
• How to validate restore of backup? Vince McMahon
  • Re: How to validate restore of backup? Muhammad Usman Khan
  • Re: How to validate restore of backup? Ron Johnson
  • Re: How to validate restore of backup? o1bigtenor
  • Re: How to validate restore of backup? Ron Johnson
  • Re: How to validate restore of backup? o1bigtenor
  • Re: How to validate restore of backup? Ron Johnson
  • Re: How to validate restore of backup? Greg Sabino Mullane
  • Re: How to validate restore of backup? Ron Johnson
  • Re: How to validate restore of backup? Peter J. Holzer
  • Re: How to validate restore of backup? Peter J. Holzer
  • Re: How to validate restore of backup? Ron Johnson
  • Re: How to validate restore of backup? Adrian Klaver
  • Re: How to validate restore of backup? Vince McMahon
  • Re: How to validate restore of backup? Adrian Klaver
• unable to upgrade postgres extensions plsqlvids01 plsqlvids01
  • Re: unable to upgrade postgres extensions Adrian Klaver
  • Re: unable to upgrade postgres extensions Alvaro Herrera
  • Re: unable to upgrade postgres extensions Tom Lane
• Npgsql.dll Andy Hartman
  • Re: Npgsql.dll Daniel Gustafsson
• Query tuning question Dirschel, Steve
• pgbackrest restore with a checkpoint and timestamp after the checkpoint KK CHN
• security invoker review need full select (all columns) to do DML? jian he
  • Re: security invoker review need full select (all columns) to do DML? Dean Rasheed
  • Re: security invoker review need full select (all columns) to do DML? Tom Lane
• insufficient privilege with pg_read_all_stats granted Costa Alexoglou
  • Re: insufficient privilege with pg_read_all_stats granted Pavel Luzanov
  • Re: insufficient privilege with pg_read_all_stats granted Pavel Luzanov
  • Re: insufficient privilege with pg_read_all_stats granted Costa Alexoglou
• Does a partition key need to be part of a composite index for the planner to take advantage of it? (PG 16.3+) William Kaper
  • Re: Does a partition key need to be part of a composite index for the planner to take advantage of it? (PG 16.3+) Laurenz Albe
• Looking for pg_config for postgresql 13.16 H
  • Re: Looking for pg_config for postgresql 13.16 Ron Johnson
  • Re: Looking for pg_config for postgresql 13.16 Tom Lane
  • Re: Looking for pg_config for postgresql 13.16 H
• pg 16.4, logical replication, use case = data archiving milist ujang
  • Re: pg 16.4, logical replication, use case = data archiving milist ujang
• WAL replication and Archive command for pgbackrest on same server conf KK CHN
  • Re: WAL replication and Archive command for pgbackrest on same server conf Ruben Morais
• Insert query performance sud
  • Re: Insert query performance Muhammad Ikram
  • Re: Insert query performance sud
  • Re: Insert query performance Muhammad Ikram
  • Re: Insert query performance David Rowley
  • Re: Insert query performance sud
  • Re: Insert query performance David Rowley
• use of postgres reg* datatypes in user tables? plsqlvids01 plsqlvids01
  • Re: use of postgres reg* datatypes in user tables? Tom Lane
  • Re: use of postgres reg* datatypes in user tables? David G. Johnston
• array_agg() does not stop aggregating according to HAVING clause Dimitrios Apostolou
  • Re: array_agg() does not stop aggregating according to HAVING clause Tom Lane
  • Re: array_agg() does not stop aggregating according to HAVING clause Dimitrios Apostolou
• PostgreSQL Upgrade Issue - Undefined Symbol Error Vivek Gadge
  • Re: PostgreSQL Upgrade Issue - Undefined Symbol Error Adrian Klaver
  • Re: PostgreSQL Upgrade Issue - Undefined Symbol Error Tom Lane
• What is the best way to upgrade pgAdmin on Windows? 毛毛
  • Re: What is the best way to upgrade pgAdmin on Windows? Ron Johnson
  • Re: What is the best way to upgrade pgAdmin on Windows? Adrian Klaver
  • Re:Re: What is the best way to upgrade pgAdmin on Windows? 毛毛
  • Re: What is the best way to upgrade pgAdmin on Windows? Adrian Klaver
• Using PQsocketPoll() for PIPELINE mode Dominique Devienne
  • Re: Using PQsocketPoll() for PIPELINE mode Dominique Devienne
  • Re: Using PQsocketPoll() for PIPELINE mode Dominique Devienne
  • Re: Using PQsocketPoll() for PIPELINE mode Greg Sabino Mullane
• Novice with Postgresql - trying simple Stored Procedure jim.kosloskey
  • Re: Novice with Postgresql - trying simple Stored Procedure Ron Johnson
  • RE: Novice with Postgresql - trying simple Stored Procedure jim.kosloskey
• Re: PG Dump on 11 - Restore on 16 - is possible? Kashif Zeeshan
  • Re: PG Dump on 11 - Restore on 16 - is possible? Ron Johnson
  • Re: PG Dump on 11 - Restore on 16 - is possible? Ron Johnson
  • Re: PG Dump on 11 - Restore on 16 - is possible? Tomas Vondra
  • Re: PG Dump on 11 - Restore on 16 - is possible? Ron Johnson
• Problem with a Query Siraj G
  • Re: Problem with a Query Tom Lane
  • Re: Problem with a Query Siraj G
  • Re: Problem with a Query Ron Johnson
  • Problem with a query Siraj G
• autovacuum freeze recommendations at table level Durgamahesh Manne
  • Re: autovacuum freeze recommendations at table level semab tariq
  • Re: autovacuum freeze recommendations at table level Durgamahesh Manne
• Soluton on Lock:extend issue Durgamahesh Manne
  • Re: Soluton on Lock:extend issue Christophe Pettus
• Insert works but fails for merge yudhi s
  • Re: Insert works but fails for merge David G. Johnston
  • Re: Insert works but fails for merge Adrian Klaver
  • Re: Insert works but fails for merge yudhi s
  • Re: Insert works but fails for merge David G. Johnston
  • Re: Insert works but fails for merge Adrian Klaver
  • Re: Insert works but fails for merge yudhi s
  • Re: Insert works but fails for merge Adrian Klaver
  • Re: Insert works but fails for merge yudhi s
  • Re: Insert works but fails for merge Alban Hertroys
  • Re: Insert works but fails for merge Adrian Klaver
  • Re: Insert works but fails for merge Greg Sabino Mullane
  • Re: Insert works but fails for merge Greg Sabino Mullane
• Trouble understanding how to avoid/manage ERROR: multixact "members" limit exceeded Jim Vanns
  • Re: Trouble understanding how to avoid/manage ERROR: multixact "members" limit exceeded Jim Vanns
  • Re: Trouble understanding how to avoid/manage ERROR: multixact "members" limit exceeded Adrian Klaver
• searching for libpq5-14.1-42PGDG.rhel8.x86_64 王瞿
  • Re: searching for libpq5-14.1-42PGDG.rhel8.x86_64 Laurenz Albe
  • Re:Re: searching for libpq5-14.1-42PGDG.rhel8.x86_64 王瞿
  • Re: Re: searching for libpq5-14.1-42PGDG.rhel8.x86_64 Ron Johnson
  • 回复：searching for libpq5-14.1-42PGDG.rhel8.x86_64 王瞿
  • Re: 回复：searching for libpq5-14.1-42PGDG.rhel8.x86_64 Devrim Gündüz
• Getting specific partition from the partition name veem v
  • Re: Getting specific partition from the partition name Greg Sabino Mullane
  • Re: Getting specific partition from the partition name Ron Johnson
  • Re: Getting specific partition from the partition name GF
  • Re: Getting specific partition from the partition name veem v
  • Re: Getting specific partition from the partition name Torsten Förtsch
  • Re: Getting specific partition from the partition name Thiemo Kellner
• Debugging set up for Postgres? James Creasy
  • Re: Debugging set up for Postgres? Pavel Stehule
• Re: Destination Table - Condition Amount 0 Adrian Klaver
  • Re: Destination Table - Condition Amount 0 Anthony Apollis
  • Re: Destination Table - Condition Amount 0 Alban Hertroys
  • Re: Destination Table - Condition Amount 0 Adrian Klaver
• Vacuum full connection exhaustion Costa Alexoglou
  • Re: Vacuum full connection exhaustion Ron Johnson
  • Re: Vacuum full connection exhaustion Francisco Olarte
  • Re: Vacuum full connection exhaustion Christophe Pettus
  • Re: Vacuum full connection exhaustion David Rowley
  • Re: Vacuum full connection exhaustion Costa Alexoglou
  • Re: Vacuum full connection exhaustion Ron Johnson
  • Re: Vacuum full connection exhaustion Christophe Pettus
• How can I get a query-based subtotal in a select using group by rollup ? dfgpostgres
  • Re: How can I get a query-based subtotal in a select using group by rollup ? David G. Johnston
• Column type modification in big tables Lok P
  • Re: Column type modification in big tables sud
  • Re: Column type modification in big tables Lok P
  • Re: Column type modification in big tables sud
  • Re: Column type modification in big tables Lok P
  • Re: Column type modification in big tables Alban Hertroys
  • Re: Column type modification in big tables Greg Sabino Mullane
  • Re: Column type modification in big tables Lok P
  • Re: Column type modification in big tables Greg Sabino Mullane
  • Re: Column type modification in big tables Lok P
  • Re: Column type modification in big tables sud
  • Re: Column type modification in big tables Lok P
  • Re: Column type modification in big tables Greg Sabino Mullane
  • Re: Column type modification in big tables Lok P
  • Re: Column type modification in big tables Peter J. Holzer
  • Re: Column type modification in big tables Dominique Devienne
  • Re: Column type modification in big tables veem v
  • Re: Column type modification in big tables Lok P
  • Re: Column type modification in big tables Alban Hertroys
  • Re: Column type modification in big tables Lok P
  • Re: Column type modification in big tables Lok P
  • Re: Column type modification in big tables Greg Sabino Mullane
  • Re: Column type modification in big tables Lok P
• ANALYZE on partitioned tables vs on individual partitions Michael Harris
  • Re: ANALYZE on partitioned tables vs on individual partitions Christophe Pettus
  • Re: ANALYZE on partitioned tables vs on individual partitions David Rowley
  • Re: ANALYZE on partitioned tables vs on individual partitions Michael Harris
  • Re: ANALYZE on partitioned tables vs on individual partitions David Rowley
  • Re: ANALYZE on partitioned tables vs on individual partitions Michael Harris
• Streaming replication issue post upgrade from version 11 to 14 on windows 2016 Server Vamsi Chava
  • Re: Streaming replication issue post upgrade from version 11 to 14 on windows 2016 Server Muhammad Ikram
• Standard of data storage and transformation yudhi s
  • Re: Standard of data storage and transformation Ron Johnson
  • Re: Standard of data storage and transformation yudhi s
• data checksums bruno vieira da silva
  • Re: data checksums Ron Johnson
  • Re: data checksums Christophe Pettus
  • Re: data checksums Laurenz Albe
  • Re: data checksums Christophe Pettus
  • Re: data checksums Daniel Gustafsson
  • Re: data checksums Ron Johnson
  • Re: data checksums Greg Sabino Mullane
• libpq version macro to use or not PQsocketPoll Dominique Devienne
  • Re: libpq version macro to use or not PQsocketPoll Tom Lane
  • Re: libpq version macro to use or not PQsocketPoll Dominique Devienne
  • Re: libpq version macro to use or not PQsocketPoll Dominique Devienne
• Check psql parameter is passed, if not ask for it Wiwwo Staff

• Earlier messages
• Later messages