Postgresql General Discussion

• Thread Index

• Re: Best Strategy for Large Number of Images
  • From: Rob Sargent
• Best Strategy for Large Number of Images
  • From: Estevan Rech
• Re: Reindex "locked" standby database
  • From: Martín Fernández
• Re: Reindex "locked" standby database
  • From: Martín Fernández
• Re: Reindex "locked" standby database
  • From: Mladen Gogala
• Re: Reindex "locked" standby database
  • From: Michael Paquier
• Reindex "locked" standby database
  • From: Martín Fernández
• Re: Why can't I have a "language sql" anonymous block?
  • From: Bryn Llewellyn
• Re: Why can't I have a "language sql" anonymous block?
  • From: David G. Johnston
• Re: Properly handling aggregate in nested function call
  • From: Tom Lane
• Re: Why can't I have a "language sql" anonymous block?
  • From: Adrian Klaver
• Re: Why can't I have a "language sql" anonymous block?
  • From: Bryn Llewellyn
• Re: locks within select
  • From: Marc Millas
• Re: When Update balloons memory
  • From: Vincent Veyron
• Postgresql DB on virtual machine in Ceph cluster
  • From: Poul Kristensen
• Re: locks within select
  • From: Laurenz Albe
• Re: When Update balloons memory
  • From: Tom Lane
• Re: When Update balloons memory
  • From: Klaudie Willis
• Re: timestamp default current_timestamp not working
  • From: Adrian Klaver
• Re: timestamp default current_timestamp not working
  • From: David G. Johnston
• Re: timestamp default current_timestamp not working
  • From: Ron
• Re: timestamp default current_timestamp not working
  • From: Sanjay Minni
• Re: When Update balloons memory
  • From: Vincent Veyron
• Re: timestamp default current_timestamp not working
  • From: Adrian Klaver
• Re: timestamp default current_timestamp not working
  • From: Ron
• timestamp default current_timestamp not working
  • From: Sanjay Minni
• Re: locks within select
  • From: David G. Johnston
• Re: locks within select
  • From: Marc Millas
• Re:
  • From: Amul Sul
• [no subject]
  • From: Dennis
• Re: LibPQ: Lifetime of PGresult passed in to PQnoticeReceiver callback
  • From: Dmitry Igrishin
• Re: LibPQ: Lifetime of PGresult passed in to PQnoticeReceiver callback
  • From: Dominique Devienne
• Re: When Update balloons memory
  • From: Klaudie Willis
• Re: locks within select
  • From: David G. Johnston
• Re: log shipping with pg_receivewal
  • From: Dilip Kumar
• Re: log shipping with pg_receivewal
  • From: Michael Paquier
• log shipping with pg_receivewal
  • From: Marc Millas
• locks within select
  • From: Marc Millas
• Re: Why can't I have a "language sql" anonymous block?
  • From: Adrian Klaver
• Re: When Update balloons memory
  • From: Tom Lane
• Re: When Update balloons memory
  • From: Klaudie Willis
• Re: Why can't I have a "language sql" anonymous block?
  • From: Bryn Llewellyn
• Properly handling aggregate in nested function call
  • From: Matt Magoffin
• Re: Why can't I have a "language sql" anonymous block?
  • From: Tom Lane
• Why can't I have a "language sql" anonymous block?
  • From: Bryn Llewellyn
• Re: Where can I follow the progress of "Pluggable Storage" development?
  • From: Jean Baro
• Re: Where can I follow the progress of "Pluggable Storage" development?
  • From: Fabrízio de Royes Mello
• Re: Error : /usr/local/share/lua/5.1/pgmoon/init.lua:211: don’t know how to auth: 10
  • From: Tom Lane
• Error : /usr/local/share/lua/5.1/pgmoon/init.lua:211: don’t know how to auth: 10
  • From: Kaushal Shriyan
• RE: [EXTERNAL] Re: performance expectations for table(s) with 2B recs
  • From: Godfrin, Philippe E
• Re: Postgresql + containerization possible use case
  • From: Achilleas Mantzios
• Re: Postgresql + containerization possible use case
  • From: Achilleas Mantzios
• Re: Postgresql + containerization possible use case
  • From: Achilleas Mantzios
• Re: Postgresql + containerization possible use case
  • From: Benedict Holland
• Re: Postgresql + containerization possible use case
  • From: Achilleas Mantzios
• Re: Postgresql + containerization possible use case
  • From: Adrian Klaver
• Re: Postgresql + containerization possible use case
  • From: Rainer Duffner
• Where can I follow the progress of "Pluggable Storage" development?
  • From: Jean Baro
• Re: Postgresql + containerization possible use case
  • From: Achilleas Mantzios
• Re: Postgresql + containerization possible use case
  • From: Rainer Duffner
• LibPQ: Lifetime of PGresult passed in to PQnoticeReceiver callback
  • From: Dominique Devienne
• Re: Postgresql + containerization possible use case
  • From: Achilleas Mantzios
• Re: Postgresql + containerization possible use case
  • From: Achilleas Mantzios
• Re: Postgresql + containerization possible use case
  • From: Achilleas Mantzios
• Re: Postgresql + containerization possible use case
  • From: Achilleas Mantzios
• Re: Need to know more about pg_test_fsync utility
  • From: PGSQL DBA
• Re: Need to know more about pg_test_fsync utility
  • From: Thomas Munro
• Re: Need to know more about pg_test_fsync utility
  • From: PGSQL DBA
• Re: Advice on using materialized views
  • From: Wicher
• Re: Postgresql + containerization possible use case
  • From: Michael Lewis
• Re: Difference in execution plans pg12 vs pg14
  • From: Дмитрий Иванов
• Re: Difference in execution plans pg12 vs pg14
  • From: Peter J. Holzer
• Re: Difference in execution plans pg12 vs pg14
  • From: Дмитрий Иванов
• Re: Difference in execution plans pg12 vs pg14
  • From: Imre Samu
• Re: Difference in execution plans pg12 vs pg14
  • From: Дмитрий Иванов
• PostgreSQL 14 Slaves setup - Question about WAL Files recovery
  • From: Lucas
• Re: Difference in execution plans pg12 vs pg14
  • From: Adrian Klaver
• Re: Difference in execution plans pg12 vs pg14
  • From: Дмитрий Иванов
• Re: Difference in execution plans pg12 vs pg14
  • From: Adrian Klaver
• Difference in execution plans pg12 vs pg14
  • From: Дмитрий Иванов
• Re: CTE Materialization
  • From: Richard Michael
• Re: [EXTERNAL] Re: performance expectations for table(s) with 2B recs
  • From: Peter J. Holzer
• Re: Postgresql + containerization possible use case
  • From: Adrian Klaver
• Re: Postgresql + containerization possible use case
  • From: Michael Lewis
• RE: [EXTERNAL] Re: performance expectations for table(s) with 2B recs
  • From: Godfrin, Philippe E
• Re: Postgresql + containerization possible use case
  • From: Adrian Klaver
• Re: Postgresql + containerization possible use case
  • From: o1bigtenor
• request to support "conflict on(col1 or col2) do update xxx" feature
  • From: sai
• Re: Postgresql + containerization possible use case
  • From: Achilleas Mantzios
• Re: Postgresql + containerization possible use case
  • From: o1bigtenor
• Re: What is the best way to redefine a trigger? (lock issue)
  • From: Achilleas Mantzios
• RE: What is the best way to redefine a trigger? (lock issue)
  • From: Marc Mamin
• Re: What is the best way to redefine a trigger? (lock issue)
  • From: Achilleas Mantzios
• RE: What is the best way to redefine a trigger? (lock issue)
  • From: Marc Mamin
• Re: What is the best way to redefine a trigger? (lock issue)
  • From: Achilleas Mantzios
• What is the best way to redefine a trigger? (lock issue)
  • From: Marc Mamin
• Postgresql + containerization possible use case
  • From: Achilleas Mantzios
• pqxx accumulating a transaction
  • From: Jeff Abrahamson
• Re: Need to know more about pg_test_fsync utility
  • From: Thomas Munro
• Need to know more about pg_test_fsync utility
  • From: PGSQL DBA
• Re: Detecting repeated phrase in a string
  • From: Peter J. Holzer
• Re: Advice on using materialized views
  • From: Phil Endecott
• Re: CTE Materialization
  • From: Paul van der Linden
• Re: Detecting repeated phrase in a string
  • From: Andreas Joseph Krogh
• Re: Detecting repeated phrase in a string
  • From: Shaozhong SHI
• RE: Identity/Serial Column In Subscriber's Tables
  • From: Avi Weinberg
• Re: Detecting repeated phrase in a string
  • From: Peter J. Holzer
• Detecting repeated phrase in a string
  • From: Shaozhong SHI
• help
  • From: Willy Skjæveland
• Re: Identity/Serial Column In Subscriber's Tables
  • From: Laurenz Albe
• Re: performance expectations for table(s) with 2B recs
  • From: Marc Millas
• Use tsquery to check out occurrence of the same phrase in a cell
  • From: Shaozhong SHI
• Identity/Serial Column In Subscriber's Tables
  • From: Avi Weinberg
• Re: CTE Materialization
  • From: Дмитрий Иванов
• Re: performance expectations for table(s) with 2B recs
  • From: Peter J. Holzer
• performance expectations for table(s) with 2B recs
  • From: David Gauthier
• Re: How to allow null as an option when using regexp_matches?
  • From: Roxanne Reid-Bennett
• Re: How to allow null as an option when using regexp_matches?
  • From: Vincent Veyron
• Re: How to allow null as an option when using regexp_matches?
  • From: Shaozhong SHI
• RE: Working with fixed-point calculations in C
  • From: Oskar Stenberg
• AW: error connecting to pgbouncer admin console
  • From: Zwettler Markus (OIZ)
• Re: How to allow null as an option when using regexp_matches?
  • From: Karsten Hilbert
• How to allow null as an option when using regexp_matches?
  • From: Shaozhong SHI
• Re: Working with fixed-point calculations in C
  • From: Peter J. Holzer
• Re: error connecting to pgbouncer admin console
  • From: Peter Eisentraut
• Re: Are Foreign Key Disabled During Logical Replication Initial Sync?
  • From: Peter Eisentraut
• Re: how to get value of parameter set in session for other user
  • From: Vikas Sharma
• Re: Working with fixed-point calculations in C
  • From: Tom Lane
• Re: CTE Materialization
  • From: David G. Johnston
• Re: CTE Materialization
  • From: Дмитрий Иванов
• Working with fixed-point calculations in C
  • From: Oskar Stenberg
• error connecting to pgbouncer admin console
  • From: Zwettler Markus (OIZ)
• Re: When Update balloons memory
  • From: Tom Lane
• Re: how to get value of parameter set in session for other user
  • From: Tom Lane
• Re: When Update balloons memory
  • From: Francisco Olarte
• Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Francisco Olarte
• how to get value of parameter set in session for other user
  • From: Vikas Sharma
• Re: Advice on using materialized views
  • From: Wicher
• When Update balloons memory
  • From: Klaudie Willis
• RE: Are Foreign Key Disabled During Logical Replication Initial Sync?
  • From: Avi Weinberg
• Re: Advice on using materialized views
  • From: Nick Cleaton
• Re: CTE Materialization
  • From: Paul van der Linden
• Re: Are Foreign Key Disabled During Logical Replication Initial Sync?
  • From: Peter Eisentraut
• Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Mladen Gogala
• Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Laurenz Albe
• Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Rob Sargent
• Advice on using materialized views
  • From: Phil Endecott
• Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Pavel Stehule
• Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Adrian Klaver
• Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Alan Hodgson
• Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Alan Hodgson
• Re: Require details that how to find user creation date in postgresql Database
  • From: Sonai muthu raja M
• Re: CTE Materialization
  • From: Paul van der Linden
• Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Alan Hodgson
• Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Francisco Olarte
• Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Rob Sargent
• Re: Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Michael Lewis
• Query planner issue with preferring primary key over a better index when using ORDER BY and LIMIT
  • From: Alan Hodgson
• Are Foreign Key Disabled During Logical Replication Initial Sync?
  • From: Avi Weinberg
• Re: libpq: Which functions may hang due to network issues?
  • From: Daniel Frey
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
  • From: Kyotaro Horiguchi
• Re: Max connections reached without max connections reached
  • From: Amul Sul
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: libpq: Which functions may hang due to network issues?
  • From: Daniel Frey
• Re: libpq: Which functions may hang due to network issues?
  • From: Tom Lane
• Re: Max connections reached without max connections reached
  • From: Dilip Kumar
• Re: libpq: Which functions may hang due to network issues?
  • From: Daniel Frey
• Re: Max connections reached without max connections reached
  • From: Dilip Kumar
• Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions
  • From: Matt Magoffin
• Re: libpq: Which functions may hang due to network issues?
  • From: Laurenz Albe
• Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions
  • From: Tom Lane
• Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions
  • From: Matt Magoffin
• Re: Handling memory contexts in aggregate function invoking other built-in aggregate functions
  • From: Tom Lane
• Handling memory contexts in aggregate function invoking other built-in aggregate functions
  • From: Matt Magoffin
• Re: Insert binary file into bytea where PG server does not have access to the file ?
  • From: Adrian Klaver
• Re: Insert binary file into bytea where PG server does not have access to the file ?
  • From: Adrian Klaver
• Re: libpq: Which functions may hang due to network issues?
  • From: Daniel Frey
• Insert binary file into bytea where PG server does not have access to the file ?
  • From: David Gauthier
• Re: libpq: Which functions may hang due to network issues?
  • From: Tom Lane
• Re: SUM() of INTERVAL type produces INTERVAL with no precision
  • From: Sebastien Flaesch
• Re: SUM() of INTERVAL type produces INTERVAL with no precision
  • From: Adrian Klaver
• Re: Max connections reached without max connections reached
  • From: Dmitry Dolgov
• Re: libpq: Which functions may hang due to network issues?
  • From: Daniel Frey
• Re: SUM() of INTERVAL type produces INTERVAL with no precision
  • From: Sebastien Flaesch
• Re: SUM() of INTERVAL type produces INTERVAL with no precision
  • From: Sebastien Flaesch
• Re: libpq: Which functions may hang due to network issues?
  • From: Laurenz Albe
• Re: Max connections reached without max connections reached
  • From: Tom Lane
• Re: SUM() of INTERVAL type produces INTERVAL with no precision
  • From: Tom Lane
• Re: Require details that how to find user creation date in postgresql Database
  • From: Achilleas Mantzios
• SUM() of INTERVAL type produces INTERVAL with no precision
  • From: Sebastien Flaesch
• libpq: Which functions may hang due to network issues?
  • From: Daniel Frey
• Re: Max connections reached without max connections reached
  • From: Dilip Kumar
• Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
  • From: Yi Sun
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: CTE Materialization
  • From: David G. Johnston
• Re: Require details that how to find user creation date in postgresql Database
  • From: Adrian Klaver
• Re: Require details that how to find user creation date in postgresql Database
  • From: Tom Lane
• CTE Materialization
  • From: Paul van der Linden
• Re: Require details that how to find user creation date in postgresql Database
  • From: Sonai muthu raja M
• Re: Issues cross-compiling libpq 14.x to MacOS armv8
  • From: Tom Lane
• Re: Issues cross-compiling libpq 14.x to MacOS armv8
  • From: Vincas Dargis
• Re: pg_upgrade question
  • From: Alan Stange
• Re: pg_upgrade question
  • From: Adrian Klaver
• pg_upgrade question
  • From: Alan Stange
• Re: case insensitive collation of Greek's sigma
  • From: Gianni Ceccarelli
• Re: case insensitive collation of Greek's sigma
  • From: Jakub Jedelsky
• Logical Replication - When to Enable Disabled Subscription and When to Create a New One
  • From: Avi Weinberg
• Logical Replication - When to Enable Disabled Publication and When to Create a New One
  • From: Avi Weinberg
• Re: INSERT ... ON CONFLICT doesn't work
  • From: Adrian Klaver
• Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
  • From: Kyotaro Horiguchi
• Re: INSERT ... ON CONFLICT doesn't work
  • From: Michael Lewis
• Re: Max connections reached without max connections reached
  • From: Michael Lewis
• Re: Max connections reached without max connections reached
  • From: Michael Lewis
• Re: Max connections reached without max connections reached
  • From: Dilip Kumar
• Re: Max connections reached without max connections reached
  • From: Rob Sargent
• Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
  • From: Yi Sun
• Re: Max connections reached without max connections reached
  • From: Michael Lewis
• Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
  • From: Kyotaro Horiguchi
• Re: Max connections reached without max connections reached
  • From: Rob Sargent
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: INSERT ... ON CONFLICT doesn't work
  • From: Adrian Klaver
• Re: INSERT ... ON CONFLICT doesn't work
  • From: Adrian Klaver
• Re: INSERT ... ON CONFLICT doesn't work
  • From: David G. Johnston
• Re: INSERT ... ON CONFLICT doesn't work
  • From: Tom Lane
• Re: INSERT ... ON CONFLICT doesn't work
  • From: Jenda Krynicky
• Re: INSERT ... ON CONFLICT doesn't work
  • From: Jenda Krynicky
• Re: INSERT ... ON CONFLICT doesn't work
  • From: David G. Johnston
• Re: INSERT ... ON CONFLICT doesn't work
  • From: David G. Johnston
• Re: INSERT ... ON CONFLICT doesn't work
  • From: David G. Johnston
• Re: INSERT ... ON CONFLICT doesn't work
  • From: Tom Lane
• Re: case insensitive collation of Greek's sigma
  • From: Tom Lane
• Re: INSERT ... ON CONFLICT doesn't work
  • From: Jenda Krynicky
• Re: INSERT ... ON CONFLICT doesn't work
  • From: Jenda Krynicky
• Re: INSERT ... ON CONFLICT doesn't work
  • From: David G. Johnston
• Re: INSERT ... ON CONFLICT doesn't work
  • From: Adrian Klaver
• Re: case insensitive collation of Greek's sigma
  • From: Peter Eisentraut
• INSERT ... ON CONFLICT doesn't work
  • From: Jenda Krynicky
• Re: Pgcrypto extension - decrypt(encrypt(... not returning original data?
  • From: Tom Lane
• Re: Pgcrypto extension - decrypt(encrypt(... not returning original data?
  • From: Wim Bertels
• Pgcrypto extension - decrypt(encrypt(... not returning original data?
  • From: SQL Padawan
• Re: Database Scalability
  • From: SQL Padawan
• Re: Linux: directory change .../lib to .../lib64
  • From: Tom Lane
• Re: Database Scalability
  • From: Ben Chobot
• Re: Database Scalability
  • From: Ben Chobot
• Re: Linux: directory change .../lib to .../lib64
  • From: Ron
• Re: Linux: directory change .../lib to .../lib64
  • From: Matthias Apitz
• Re: Linux: directory change .../lib to .../lib64
  • From: Matthias Apitz
• Re: Linux: directory change .../lib to .../lib64
  • From: Tom Lane
• Re: Logical replication issue after Postgresql upgrade from 13 to 14
  • From: Amit Kapila
• Linux: directory change .../lib to .../lib64
  • From: Matthias Apitz
• Re: Logical replication issue after Postgresql upgrade from 13 to 14
  • From: Sergey Belyashov
• Re: Logical replication issue after Postgresql upgrade from 13 to 14
  • From: Marcos Pegoraro
• Re: Issues cross-compiling libpq 14.x to MacOS armv8
  • From: Tom Lane
• Re: Issues cross-compiling libpq 14.x to MacOS armv8
  • From: Daniel Gustafsson
• Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
  • From: Yi Sun
• Re: Max connections reached without max connections reached
  • From: Dilip Kumar
• Re: case insensitive collation of Greek's sigma
  • From: Frank Limpert
• RE: Wildcarding json keys in json query
  • From: Patrick FICHE
• Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
  • From: Kyotaro Horiguchi
• Re: Issues cross-compiling libpq 14.x to MacOS armv8
  • From: Peter Eisentraut
• Re: [EXT] Re: XQuery/XPath 2.0+ support
  • From: Pavel Stehule
• Re: [EXT] Re: XQuery/XPath 2.0+ support
  • From: Garfield Lewis
• Re: Database Scalability
  • From: Michael Stephenson
• Re: Database Scalability
  • From: Mladen Gogala
• Re: Database Scalability
  • From: Saurav Sarkar
• Re: Wildcarding json keys in json query
  • From: David G. Johnston
• Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
  • From: Yi Sun
• Re: How to reveal the codes of functions properly?
  • From: David G. Johnston
• Re: Issues cross-compiling libpq 14.x to MacOS armv8
  • From: Tom Lane
• Re: Issues cross-compiling libpq 14.x to MacOS armv8
  • From: Daniel Gustafsson
• Re: Issues cross-compiling libpq 14.x to MacOS armv8
  • From: Tom Lane
• Re: Issues cross-compiling libpq 14.x to MacOS armv8
  • From: Tom Lane
• Re: Issues cross-compiling libpq 14.x to MacOS armv8
  • From: Daniel Gustafsson
• Wildcarding json keys in json query
  • From: David Gauthier
• Re: How to reveal the codes of functions properly?
  • From: Wicher
• Re: How to reveal the codes of functions properly?
  • From: Rob Sargent
• Re: How to reveal the codes of functions properly?
  • From: Shaozhong SHI
• Re: Issues cross-compiling libpq 14.x to MacOS armv8
  • From: Tom Lane
• Issues cross-compiling libpq 14.x to MacOS armv8
  • From: Vincas Dargis
• Re: Database Scalability
  • From: Ben Chobot
• Re: How to reveal the codes of functions properly?
  • From: Rob Sargent
• How to reveal the codes of functions properly?
  • From: Shaozhong SHI
• Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
  • From: Gabriel Cabillon
• ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
  • From: Yi Sun
• Logical replication issue after Postgresql upgrade from 13 to 14
  • From: Sergey Belyashov
• Database Scalability
  • From: Saurav Sarkar
• Re: RE: [EXTERNAL] Re: Inserts and bad performance
  • From: Ali .
• Re: split postgresql logfile
  • From: Michael Paquier
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: XQuery/XPath 2.0+ support
  • From: Tom Lane
• XQuery/XPath 2.0+ support
  • From: Garfield Lewis
• Experience with node-pg-migrate
  • From: Dirk Krautschick
• split postgresql logfile
  • From: Paul van Rixel
• DDL tools for working with views in dependency order?
  • From: Wicher
• Re: Match 2 words and more
  • From: Thomas Markus
• Re: [EXTERNAL] Re: Inserts and bad performance
  • From: Gavin Flower
• Re: Packaging pgAdmin 4
  • From: Blake McBride
• Re: Match 2 words and more
  • From: Peter J. Holzer
• Re: Match 2 words and more
  • From: Peter J. Holzer
• RE: [EXTERNAL] Re: Inserts and bad performance
  • From: Godfrin, Philippe E
• RE: [EXTERNAL] Re: Inserts and bad performance
  • From: Godfrin, Philippe E
• Re: Match 2 words and more
  • From: Ron
• Re: Match 2 words and more
  • From: David G. Johnston
• Re: Match 2 words and more
  • From: Guyren Howe
• Re: Match 2 words and more
  • From: Alvaro Herrera
• Re: Match 2 words and more
  • From: Rob Sargent
• Re: Packaging pgAdmin 4
  • From: Rob Sargent
• Match 2 words and more
  • From: Shaozhong SHI
• Re: Packaging pgAdmin 4
  • From: Chuck Davis
• Packaging pgAdmin 4
  • From: Blake McBride
• Re: Merge into does not work
  • From: Adrian Klaver
• Re: Merge into does not work
  • From: Alvaro Herrera
• Re: Merge into does not work
  • From: Adrian Klaver
• Re: Merge into does not work
  • From: Alvaro Herrera
• Re: What do you do with a long running rollback
  • From: Tom Lane
• Re: Merge into does not work
  • From: Ron
• Re: Merge into does not work
  • From: David G. Johnston
• Merge into does not work
  • From: Shaozhong SHI
• RE: [EXTERNAL] Re: Inserts and bad performance
  • From: Godfrin, Philippe E
• Re: case insensitive collation of Greek's sigma
  • From: Tom Lane
• download question
  • From: Marc Millas
• Re: case insensitive collation of Greek's sigma
  • From: Achilleas Mantzios
• case insensitive collation of Greek's sigma
  • From: Jakub Jedelsky
• Re: Best examples of cardinality check and associated functions
  • From: David G. Johnston
• Re: Best examples of cardinality check and associated functions
  • From: Rob Sargent
• Re: Best examples of cardinality check and associated functions
  • From: Shaozhong SHI
• Re: Best examples of cardinality check and associated functions
  • From: Rob Sargent
• Best examples of cardinality check and associated functions
  • From: Shaozhong SHI
• Re: As a Linux distro, how to package multiple postgres major versions?
  • From: Laurent FAILLIE
• Re: As a Linux distro, how to package multiple postgres major versions?
  • From: Ron
• Re: function difference not found
  • From: Osvaldo Kussama
• Re: function difference not found
  • From: David G. Johnston
• As a Linux distro, how to package multiple postgres major versions?
  • From: Chocimier
• Re: function difference not found
  • From: Achilleas Mantzios
• Re: function difference not found
  • From: Adrian Klaver
• function difference not found
  • From: Shaozhong SHI
• Re: ANALYZE, pg_class.xmin && pg_class.reltuples
  • From: Tom Lane
• Re: Error message while trying to connect from PGAdmin 4
  • From: sivapostgres@xxxxxxxxx
• ANALYZE, pg_class.xmin && pg_class.reltuples
  • From: Luca Ferrari
• Re: Max connections reached without max connections reached
  • From: Dilip Kumar
• Re: Error message while trying to connect from PGAdmin 4
  • From: sivapostgres@xxxxxxxxx
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: Inserts and bad performance
  • From: Ron
• Re: Max connections reached without max connections reached
  • From: Dilip Kumar
• Re: Max connections reached without max connections reached
  • From: Dilip Kumar
• Re: Max connections reached without max connections reached
  • From: Dilip Kumar
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: [EXTERNAL] Re: Inserts and bad performance
  • From: David Rowley
• Re: [EXTERNAL] Re: Inserts and bad performance
  • From: Michael Lewis
• RE: [EXTERNAL] Re: Inserts and bad performance
  • From: Godfrin, Philippe E
• RE: [EXTERNAL] Re: Inserts and bad performance
  • From: Godfrin, Philippe E
• Re: Inserts and bad performance
  • From: Gavin Roy
• Re: Inserts and bad performance
  • From: Tom Lane
• RE: [EXTERNAL] Re: Inserts and bad performance
  • From: Godfrin, Philippe E
• Re: Inserts and bad performance
  • From: Kenneth Marshall
• Inserts and bad performance
  • From: Godfrin, Philippe E
• Re: RPM package issue
  • From: Aleš Zelený
• Re: RPM package issue
  • From: Adrian Klaver
• Re: get last timestamp of table ddl
  • From: Luca Ferrari
• Re: get last timestamp of table ddl
  • From: Luca Ferrari
• Re: RPM package issue
  • From: Adrian Klaver
• RPM package issue
  • From: Aleš Zelený
• Re: get last timestamp of table ddl
  • From: Achilleas Mantzios
• Re: How to set alias data type?
  • From: hubert depesz lubaczewski
• Re: get last timestamp of table ddl
  • From: hubert depesz lubaczewski
• How to set alias data type?
  • From: Shaozhong SHI
• get last timestamp of table ddl
  • From: Luca Ferrari
• Re: Max connections reached without max connections reached
  • From: Tom Lane
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: Max connections reached without max connections reached
  • From: Adrian Klaver
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: Max connections reached without max connections reached
  • From: Adrian Klaver
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: Max connections reached without max connections reached
  • From: Adrian Klaver
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: Max connections reached without max connections reached
  • From: Tom Lane
• Re: Max connections reached without max connections reached
  • From: Adrian Klaver
• Re: Max connections reached without max connections reached
  • From: James Sewell
• Re: Regex for Word space Word space Word ....
  • From: Shaozhong SHI
• Re: PQexecParams, placeholders and variable lists of params
  • From: tomas
• Re: PQexecParams, placeholders and variable lists of params
  • From: Daniel Frey
• Re: PQexecParams, placeholders and variable lists of params
  • From: tomas
• Re: PQexecParams, placeholders and variable lists of params
  • From: Tom Lane
• Re: PQexecParams, placeholders and variable lists of params
  • From: David G. Johnston
• Re: Max connections reached without max connections reached
  • From: Tom Lane
• Re: Regex for Word space Word space Word ....
  • From: David G. Johnston
• Re: PQexecParams, placeholders and variable lists of params
  • From: tomas
• Re: Regex for Word space Word space Word ....
  • From: tomas
• Re: PQexecParams, placeholders and variable lists of params
  • From: Дмитрий Иванов
• Re: SELECT fails to present result rows depending on the columns to show
  • From: Matthias Apitz
• Re: Regex for Word space Word space Word ....
  • From: Andreas Joseph Krogh
• Re: Regex for Word space Word space Word ....
  • From: Saurabh Agrawal
• PQexecParams, placeholders and variable lists of params
  • From: tomas
• Re: Regex for Word space Word space Word ....
  • From: Shaozhong SHI
• Re: Regex for Word space Word space Word ....
  • From: chlor
• Re: Regex for Word space Word space Word ....
  • From: Shaozhong SHI
• Regex for Word space Word space Word ....
  • From: Shaozhong SHI
• Re: SELECT fails to present result rows depending on the columns to show
  • From: Thomas Kellerer
• Re: SELECT fails to present result rows depending on the columns to show
  • From: Ilya Anfimov
• SELECT fails to present result rows depending on the columns to show
  • From: Matthias Apitz
• Max connections reached without max connections reached
  • From: James Sewell
• Re: Why swirling circles in pgAdmin?
  • From: Adrian Klaver
• Why swirling circles in pgAdmin?
  • From: Shaozhong SHI
• Re:
  • From: Tom Lane
• [no subject]
  • From: AC Gomez
• Re: insert column monetary type ver 2
  • From: Tom Lane
• Re: pg_dump insert column GENERATED
  • From: Дмитрий Иванов
• Re: insert column monetary type ver 2
  • From: Adrian Klaver
• Re: pg_dump insert column GENERATED
  • From: Adrian Klaver
• Re: insert column monetary type ver 2
  • From: Дмитрий Иванов
• Re: pg_dump insert column GENERATED
  • From: Дмитрий Иванов
• Re: insert column monetary type ver 2
  • From: Tom Lane
• Re: pg_dump insert column GENERATED
  • From: Дмитрий Иванов
• Doubt regarding Postgres replication issue
  • From: Palani vel
• Re: pg_dump insert column GENERATED
  • From: Tom Lane
• Re: pg_dump insert column GENERATED
  • From: Дмитрий Иванов
• Incremental backup in windows machine
  • From: obi reddy
• Re: pg_dump insert column GENERATED
  • From: Дмитрий Иванов
• Re: insert column monetary type ver 2
  • From: Ron
• Re: insert column monetary type ver 2
  • From: Дмитрий Иванов
• Re: insert column monetary type ver 2
  • From: Rob Sargent
• Re: insert column monetary type ver 2
  • From: Ron
• insert column monetary type ver 2
  • From: David G. Johnston
• Re: insert column monetary type ver 2
  • From: Ron
• Re: insert column monetary type ver 2
  • From: Adrian Klaver
• Re: insert column monetary type ver 2
  • From: Ron
• Re: Error when rewriting a query into multiple queries
  • From: David G. Johnston
• Re: insert column monetary type ver 2
  • From: vincent.veyron@xxxxxxxxxxxx
• Error when rewriting a query into multiple queries
  • From: Huang Wang
• Re: pg_dump insert column GENERATED
  • From: Adrian Klaver
• Re: insert column monetary type ver 2
  • From: Tom Lane
• Re: pg_dump insert column GENERATED
  • From: Tom Lane
• Re: pg_dump insert column GENERATED
  • From: Дмитрий Иванов
• Re: pg_dump insert column GENERATED
  • From: Adrian Klaver
• Re: insert column monetary type ver 2
  • From: Дмитрий Иванов
• Re: pg_dump insert column GENERATED
  • From: Дмитрий Иванов
• Re: insert column monetary type ver 2
  • From: Ron
• Re: pg_dump insert column GENERATED
  • From: Adrian Klaver
• Re: pg_dump insert column GENERATED
  • From: Дмитрий Иванов
• Re: pg_dump insert column GENERATED
  • From: Adrian Klaver
• Re: pg_dump insert column GENERATED
  • From: Дмитрий Иванов
• Re: pg_dump insert column GENERATED
  • From: Дмитрий Иванов
• Re: pg_dump insert column GENERATED
  • From: Tom Lane
• Re: insert column monetary type ver 2
  • From: Tom Lane
• Re: pg_dump insert column GENERATED
  • From: Adrian Klaver
• Re: insert column monetary type ver 2
  • From: Adrian Klaver
• Re: any default columns for tracking / auditing purpose
  • From: Rob Sargent
• Re: insert column monetary type ver 2
  • From: Дмитрий Иванов
• Re: insert column monetary type ver 2
  • From: Josef Šimánek
• any default columns for tracking / auditing purpose
  • From: Sanjay Minni
• insert column monetary type ver 2
  • From: Дмитрий Иванов
• pg_dump insert column GENERATED
  • From: Дмитрий Иванов
• insert column monetary type
  • From: Дмитрий Иванов
• Re: Execute command in PL/pgSQL function not executing
  • From: Michael Lewis
• Re: Execute command in PL/pgSQL function not executing
  • From: Marc Millas
• Re: Execute command in PL/pgSQL function not executing
  • From: David G. Johnston
• Re: Execute command in PL/pgSQL function not executing
  • From: Abdul Mohammed
• Re: Execute command in PL/pgSQL function not executing
  • From: Abdul Mohammed
• Re: Execute command in PL/pgSQL function not executing
  • From: David G. Johnston
• Re: Execute command in PL/pgSQL function not executing
  • From: Tom Lane
• Re: Execute command in PL/pgSQL function not executing
  • From: Abdul Mohammed
• Re: check scripts after database code change
  • From: Dennis
• Re: check scripts after database code change
  • From: Ron
• Re: check scripts after database code change
  • From: Dennis
• Re: Plans with bad estimates/paths
  • From: Joe Wildish
• Re: check scripts after database code change
  • From: Adrian Klaver
• Re: check scripts after database code change
  • From: Karsten Hilbert
• Re: General Performance Question
  • From: Tom Lane
• restore with pg engine upgrade in a middle
  • From: Marcin Giedz
• Re: General Performance Question
  • From: DAVID ROTH
• check scripts after database code change
  • From: Dennis
• Re: General Performance Question
  • From: Thomas Kellerer
• General Performance Question
  • From: DAVID ROTH
• Re: Execute command in PL/pgSQL function not executing
  • From: Pavel Stehule
• Execute command in PL/pgSQL function not executing
  • From: Abdul Mohammed
• Re: Account privileges
  • From: Prathima Mulpuri
• Re: Postgres Equivalent of Oracle Package
  • From: Mladen Gogala
• Re: postgresql 9.6x installers for windows are no longer available
  • From: Adrian Klaver
• Re: postgresql 9.6x installers for windows are no longer available
  • From: Adrian Klaver
• Re: How is JSON stored in PG ?
  • From: Laurenz Albe
• Re: Account privileges
  • From: Joe Conway
• postgresql 9.6x installers for windows are no longer available
  • From: Ryan Wexler
• Re: create all indexes and triggers in a schema after bulk load
  • From: Akheel Ahmed
• Re: create all indexes and triggers in a schema after bulk load
  • From: hubert depesz lubaczewski
• create all indexes and triggers in a schema after bulk load
  • From: Akheel Ahmed
• Re: Managing major PostgreSQL upgrades
  • From: Saul Perdomo
• Re: Managing major PostgreSQL upgrades
  • From: Tiffany Thang
• Re: Postgres Equivalent of Oracle Package
  • From: Pavel Stehule
• Re: Row estimate on empty tables
  • From: Tom Lane
• Re: Account privileges
  • From: David G. Johnston
• Account privileges
  • From: Prathima Mulpuri
• Row estimate on empty tables
  • From: Michael Lewis
• Re: Plans with bad estimates/paths
  • From: Tomas Vondra
• Plans with bad estimates/paths
  • From: Joe Wildish
• Re: Postgres Equivalent of Oracle Package
  • From: DAVID ROTH
• Re: Postgres Equivalent of Oracle Package
  • From: Pavel Stehule
• Postgres Equivalent of Oracle Package
  • From: DAVID ROTH
• Re: How is JSON stored in PG ?
  • From: Ray O'Donnell
• Re: Performance question about using autosave=always and cleanupSavepoints=true
  • From: Dave Cramer
• Re: How is JSON stored in PG ?
  • From: Adrian Klaver
• Performance question about using autosave=always and cleanupSavepoints=true
  • From: Joel Rabinovitch
• How is JSON stored in PG ?
  • From: David Gauthier
• Re: historical log of data records
  • From: Laurenz Albe
• Re: historical log of data records
  • From: Peter J. Holzer
• Multiple multi-column gist indexes that shares one geometry field
  • From: 王景隆
• Re: reading this group other than thru mails
  • From: Jan Wieck
• Re: historical log of data records
  • From: Sanjay Minni
• Re: historical log of data records
  • From: Alban Hertroys
• Re: historical log of data records
  • From: Sanjay Minni
• Re: historical log of data records
  • From: Laurenz Albe
• reading this group other than thru mails
  • From: Sanjay Minni
• historical log of data records
  • From: Sanjay Minni
• RE: PostgreSQL debug log doesn't record whole procedure(from receiving request to sending response)
  • From: Chen, Yan-Jack (NSB - CN/Hangzhou)
• Re: Managing major PostgreSQL upgrades
  • From: Saul Perdomo
• Re: pg_restore depending on user functions
  • From: Дмитрий Иванов
• Re: pg_restore depending on user functions
  • From: Дмитрий Иванов
• Re: pg_restore depending on user functions
  • From: Дмитрий Иванов
• Re: pg_restore depending on user functions
  • From: Tom Lane
• Re: pg_restore depending on user functions
  • From: Дмитрий Иванов
• Re: help with a query
  • From: Francisco Olarte
• Re: PostgreSQL debug log doesn't record whole procedure(from receiving request to sending response)
  • From: Tom Lane
• Re: help with a query
  • From: Bruce Momjian
• Re: help with a query
  • From: Bruce Momjian
• Managing major PostgreSQL upgrades
  • From: Tiffany Thang
• PostgreSQL debug log doesn't record whole procedure(from receiving request to sending response)
  • From: Chen, Yan-Jack (NSB - CN/Hangzhou)
• help with a query
  • From: yarden tamam
• Re: pg_restore depending on user functions
  • From: Tom Lane
• Re: pg_restore depending on user functions
  • From: Дмитрий Иванов
• Re: pg_restore depending on user functions
  • From: Дмитрий Иванов
• Re: Pg_hba.conf problem after unexpected IP change
  • From: Ray O'Donnell
• Re: Pg_hba.conf problem after unexpected IP change
  • From: Adrian Klaver
• Re: Pg_hba.conf problem after unexpected IP change
  • From: Ray O'Donnell
• Re: Pg_hba.conf problem after unexpected IP change
  • From: Yessica Brinkmann
• Re: pg_restore depending on user functions
  • From: Tom Lane
• Re: pg_restore depending on user functions
  • From: Дмитрий Иванов
• Re: pg_restore depending on user functions
  • From: Tom Lane
• Logical Replication - Source and Destination Table Name Not The Same
  • From: Avi Weinberg
• pg_restore depending on user functions
  • From: Дмитрий Иванов
• How to Implement DR for a Production PostgreSQL v12.8 database cluster with repmgr & PgBouncer?
  • From: Hilbert, Karin
• Re: Pg_hba.conf problem after unexpected IP change
  • From: Adrian Klaver
• Re: Pg_hba.conf problem after unexpected IP change
  • From: Yessica Brinkmann
• Re: Are all unlogged tables in any case truncated after a server-crash?
  • From: Michael Lewis
• RE: Replace anonymized data in string
  • From: Patrick FICHE
• Re: Replace anonymized data in string
  • From: Rob Sargent
• Re: Replace anonymized data in string
  • From: Daniel Gustafsson
• Replace anonymized data in string
  • From: Patrick FICHE
• Re: Are all unlogged tables in any case truncated after a server-using
  • From: Michael Lewis
• Re: Pg_hba.conf problem after unexpected IP change
  • From: Dave Cramer
• Re: Are all unlogged tables in any case truncated after a server-crash?
  • From: sch8el
• Re: Pg_hba.conf problem after unexpected IP change
  • From: Yessica Brinkmann
• Re: Are all unlogged tables in any case truncated after a server-crash?
  • From: sch8el
• Re: Are all unlogged tables in any case truncated after a server-crash?
  • From: Laurenz Albe
• sqrt_bigint_v2
  • From: =?gb18030?b?ucKwwdChtv6hq7Ci4+U=?=
• sqrt_bigint_v2
  • From: =?gb18030?b?ucKwwdChtv6hq7Ci4+U=?=
• =?gb18030?b?u9i4tKO6IEkgYWRkZWQgYSChzCBvcGVyYXRvciwg?==?gb18030?b?dGhlIHNxcnQgZnVuY3Rpb24gaXMgc3RpbGwgdXNl?==?gb18030?b?ZCBpbnRlcm5hbGx5LCBidXQgbm93IHRoZXJlIGlz?==?gb18030?b?IGEgcHJvYmxlbSwgaXQgYWZmZWN0cyB0aGUgOj0g?==?gb18030?b?YW5kIC4uIG9wZXJhdG9ycyBvZiB0aGUgZGF0YWJh?==?gb18030?b?c2U=?=
  • From: =?gb18030?b?ucKwwdChtv6hq7Ci4+U=?=
• Re: I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database
  • From: David G. Johnston
• 回复： I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database
  • From: 孤傲小二～阿沐
• Re: =?gb18030?b?SSBhZGRlZCBhIKHMIG9wZXJhdG9yLCB0aGUgc3Fy?==?gb18030?b?dCBmdW5jdGlvbiBpcyBzdGlsbCB1c2VkIGludGVy?==?gb18030?b?bmFsbHksIGJ1dCBub3cgdGhlcmUgaXMgYSBwcm9i?==?gb18030?b?bGVtLCBpdCBhZmZlY3RzIHRoZSA6PSBhbmQgLi4g?==?gb18030?b?b3BlcmF0b3JzIG9mIHRoZSBkYXRhYmFzZQ==?=
  • From: Tom Lane
• =?gb18030?b?u9i4tKO6IEkgYWRkZWQgYSChzCBvcGVyYXRvciwg?==?gb18030?b?dGhlIHNxcnQgZnVuY3Rpb24gaXMgc3RpbGwgdXNl?==?gb18030?b?ZCBpbnRlcm5hbGx5LCBidXQgbm93IHRoZXJlIGlz?==?gb18030?b?IGEgcHJvYmxlbSwgaXQgYWZmZWN0cyB0aGUgOj0g?==?gb18030?b?YW5kIC4uIG9wZXJhdG9ycyBvZiB0aGUgZGF0YWJh?==?gb18030?b?c2U=?=
  • From: =?gb18030?b?ucKwwdChtv6hq7Ci4+U=?=
• Re: I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database
  • From: David G. Johnston
• =?gb18030?b?u9i4tKO6IEkgYWRkZWQgYSChzCBvcGVyYXRvciwg?==?gb18030?b?dGhlIHNxcnQgZnVuY3Rpb24gaXMgc3RpbGwgdXNl?==?gb18030?b?ZCBpbnRlcm5hbGx5LCBidXQgbm93IHRoZXJlIGlz?==?gb18030?b?IGEgcHJvYmxlbSwgaXQgYWZmZWN0cyB0aGUgOj0g?==?gb18030?b?YW5kIC4uIG9wZXJhdG9ycyBvZiB0aGUgZGF0YWJh?==?gb18030?b?c2U=?=
  • From: =?gb18030?b?ucKwwdChtv6hq7Ci4+U=?=
• Re: I added a √ operator, the sqrt function is still used internally, but now there is a problem, it affects the := and .. operators of the database
  • From: David G. Johnston
• =?gb18030?b?SSBhZGRlZCBhIKHMIG9wZXJhdG9yLCB0aGUgc3Fy?==?gb18030?b?dCBmdW5jdGlvbiBpcyBzdGlsbCB1c2VkIGludGVy?==?gb18030?b?bmFsbHksIGJ1dCBub3cgdGhlcmUgaXMgYSBwcm9i?==?gb18030?b?bGVtLCBpdCBhZmZlY3RzIHRoZSA6PSBhbmQgLi4g?==?gb18030?b?b3BlcmF0b3JzIG9mIHRoZSBkYXRhYmFzZQ==?=
  • From: =?gb18030?b?ucKwwdChtv6hq7Ci4+U=?=
• Re: Pg_hba.conf problem after unexpected IP change
  • From: Adrian Klaver
• Pg_hba.conf problem after unexpected IP change
  • From: Yessica Brinkmann
• Re: Are all unlogged tables in any case truncated after a server-crash?
  • From: David G. Johnston
• Are all unlogged tables in any case truncated after a server-crash?
  • From: sch8el
• Re: Why in pgAdmin an active session is marked/highlighted in Red
  • From: Laurenz Albe
• Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer?
  • From: Jean Baro
• Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer?
  • From: Jean Baro
• Re:Why in pgAdmin an active session is marked/highlighted in Red
  • From: chris
• Why in pgAdmin an active session is marked/highlighted in Red
  • From: Shaozhong SHI
• Re: Pause streaming replication
  • From: Laurenz Albe
• Re: Pause streaming replication
  • From: Michael Paquier
• Re: Pause streaming replication
  • From: Ben Chobot
• Re: Pause streaming replication
  • From: Rita
• Re: Pause streaming replication
  • From: Ben Chobot
• Pause streaming replication
  • From: Rita
• Re: E.1.2. Migration to Version 14
  • From: Дмитрий Иванов
• Re: Logical Replication - Type messages?
  • From: Tom Lane
• Re: E.1.2. Migration to Version 14
  • From: Bruce Momjian
• Re: Understanding the differences between Temporal tables, CDC and Time Series.
  • From: SQL Padawan
• Re: Understanding the differences between Temporal tables, CDC and Time Series.
  • From: Peter Eisentraut
• E.1.2. Migration to Version 14
  • From: Дмитрий Иванов
• Understanding the differences between Temporal tables, CDC and Time Series.
  • From: SQL Padawan
• Re: Logical Replication - Should Destination Table Columns Be Defined With Default Value
  • From: Mark Dilger
• Re: Logical Replication - Should Destination Table Columns Be Defined With Default Value
  • From: Michael Lewis
• Re: Logical Replication - Should Destination Table Columns Be Defined With Default Value
  • From: Mark Dilger
• Re: Logical Replication - Should Destination Table Columns Be Defined With Default Value
  • From: Tom Lane
• RE: Logical Replication - Should Destination Table Columns Be Defined With Default Value
  • From: Avi Weinberg
• Re: Logical Replication - Should Destination Table Columns Be Defined With Default Value
  • From: David G. Johnston
• Logical Replication - Should Destination Table Columns Be Defined With Default Value
  • From: Avi Weinberg
• Query Timeout not working using jpa
  • From: Shubham Mittal
• Logical Replication - Type messages?
  • From: Stefen Hillman
• Re: Zero Downtime Upgrade
  • From: Brent Wood
• Zero Downtime Upgrade
  • From: Akheel Ahmed
• Re: Question: Is it possible to get the new xlog position after query execution?
  • From: Christophe Pettus
• Re: Question: Is it possible to get the new xlog position after query execution?
  • From: Oleg Serov
• Re: Question: Is it possible to get the new xlog position after query execution?
  • From: Christophe Pettus
• Re: libpq: How to cancel a COPY ... TO statement?
  • From: Tom Lane
• libpq: How to cancel a COPY ... TO statement?
  • From: Daniel Frey
• Re: Question: Is it possible to get the new xlog position after query execution?
  • From: Oleg Serov
• Re: Question: Is it possible to get the new xlog position after query execution?
  • From: Christophe Pettus
• Re: Design database schemas around a common subset of objects
  • From: Adrian Klaver
• Re: Mongo FDW For Postgres
  • From: Laurenz Albe
• Re: Mongo FDW For Postgres
  • From: Dhivya E
• Re: Design database schemas around a common subset of objects
  • From: Rob Sargent
• Re: Question: Is it possible to get the new xlog position after query execution?
  • From: Oleg Serov
• Re: Design database schemas around a common subset of objects
  • From: Rich Shepard
• Re: Design database schemas around a common subset of objects
  • From: Erik Wienhold
• Re: Design database schemas around a common subset of objects
  • From: Adrian Klaver
• Design database schemas around a common subset of objects
  • From: Erik Wienhold
• Re: Determining if a table really changed in a trigger
  • From: Mitar
• Re: Determining if a table really changed in a trigger
  • From: Tom Lane
• Re: Question: Is it possible to get the new xlog position after query execution?
  • From: Peter J. Holzer
• Re: Determining if a table really changed in a trigger
  • From: Mitar
• Re: Debugging features needed
  • From: Boboc Cristi
• Re: Debugging features needed
  • From: Boboc Cristi
• Re: Debugging features needed
  • From: Vijaykumar Jain
• Re: Debugging features needed
  • From: Michael Lewis
• Re: Debugging features needed
  • From: Tom Lane
• Re: Debugging features needed
  • From: Boboc Cristi
• Re: Debugging features needed
  • From: Vijaykumar Jain
• Debugging features needed
  • From: Boboc Cristi
• Re: An self-contained example "expanded" C data type
  • From: Pavel Stehule
• An self-contained example "expanded" C data type
  • From: Michel Pelletier
• Re: to_date() and to_timestamp() with negative years
  • From: Adrian Klaver
• Re: Streaming replication versus Logical replication
  • From: Christophe Pettus
• RE: Streaming replication versus Logical replication
  • From: Alanoly Andrews
• Re: ZFS filesystem - supported ?
  • From: Benedict Holland
• Re: Streaming replication versus Logical replication
  • From: Ninad Shah
• Re: to_date() and to_timestamp() with negative years
  • From: Bryn Llewellyn
• Streaming replication versus Logical replication
  • From: Alanoly Andrews
• Re: Error with Insert from View with ON Conflict
  • From: Alex Magnum
• Re: to_date() and to_timestamp() with negative years
  • From: Adrian Klaver
• Re: to_date() and to_timestamp() with negative years
  • From: Bryn Llewellyn
• Re: Error with Insert from View with ON Conflict
  • From: Peter Geoghegan
• Re: to_date() and to_timestamp() with negative years
  • From: Adrian Klaver
• Re: to_date() and to_timestamp() with negative years
  • From: Adrian Klaver
• Re: to_date() and to_timestamp() with negative years
  • From: Bryn Llewellyn
• Re: to_date() and to_timestamp() with negative years
  • From: Tom Lane
• Re: to_date() and to_timestamp() with negative years
  • From: Adrian Klaver
• Re: Error with Insert from View with ON Conflict
  • From: Steve Baldwin
• Error with Insert from View with ON Conflict
  • From: Alex Magnum
• Re: to_date() and to_timestamp() with negative years
  • From: Bryn Llewellyn
• Re: Regex for (A) and (B) to find in Bus Stop (A) or (B)
  • From: David G. Johnston
• Re: Regex for (A) and (B) to find in Bus Stop (A) or (B)
  • From: David G. Johnston
• Regex for (A) and (B) to find in Bus Stop (A) or (B)
  • From: Shaozhong SHI
• Regex for (A) and (B) to find in Bus Stop (A) or (B)
  • From: Shaozhong SHI
• Re: to_date() and to_timestamp() with negative years
  • From: Adrian Klaver
• Re: Selectivity and row count estimates for JSONB columns
  • From: Tom Lane
• Re: to_date() and to_timestamp() with negative years
  • From: Bryn Llewellyn
• Re: to_date() and to_timestamp() with negative years
  • From: Tom Lane
• to_date() and to_timestamp() with negative years
  • From: Bryn Llewellyn
• Re: Doubt in pgbouncer
  • From: Ninad Shah
• Doubt in pgbouncer
  • From: Rama Krishnan
• Re: develop a extension with cpp?
  • From: huangning290@xxxxxxxxx
• Re: develop a extension with cpp?
  • From: Dmitry Igrishin
• Re: develop a extension with cpp?
  • From: Ilya Anfimov
• develop a extension with cpp?
  • From: huangning290@xxxxxxxxx
• Re: ZFS filesystem - supported ?
  • From: Mladen Gogala
• Re: ZFS filesystem - supported ?
  • From: Lucas
• Re: ZFS filesystem - supported ?
  • From: Stephen Frost
• Re: ZFS filesystem - supported ?
  • From: Lucas
• Re: ZFS filesystem - supported ?
  • From: Ron
• Re: ZFS filesystem - supported ?
  • From: Stephen Frost
• Re: Lazier alternative to row_to_json ?
  • From: Tom Lane
• Naked EXISTS vs SELECT EXISTS very different performance.
  • From: Jimmy A
• Lazier alternative to row_to_json ?
  • From: Florents Tselai
• Re: Settings for a new machine - some guidance sought.
  • From: Laurenz Albe
• Re: Question: Is it possible to get the new xlog position after query execution?
  • From: Oleg Serov
• Re: Question: Is it possible to get the new xlog position after query execution?
  • From: Peter J. Holzer
• Settings for a new machine - some guidance sought.
  • From: SQL Padawan
• Re: Why does the OID jump by 3 when creating tables?
  • From: Ron
• Re: Why does the OID jump by 3 when creating tables?
  • From: Daniel Westermann (DWE)
• Re: Why does the OID jump by 3 when creating tables?
  • From: Guillaume Lelarge
• Why does the OID jump by 3 when creating tables?
  • From: Daniel Westermann (DWE)
• Re: psql syntax for array of strings in a variable?
  • From: Philip Semanchuk
• Re: psql syntax for array of strings in a variable?
  • From: Tom Lane
• Re: psql syntax for array of strings in a variable?
  • From: Pavel Stehule
• Re: psql syntax for array of strings in a variable?
  • From: David G. Johnston
• Question: Is it possible to get the new xlog position after query execution?
  • From: Oleg Serov
• psql syntax for array of strings in a variable?
  • From: Philip Semanchuk
• Re: DBeaver does not show all tables in a Schema
  • From: Adrian Klaver
• Re: Postgres dblink example
  • From: Adrian Klaver
• Re: Incremental backup
  • From: Mladen Gogala
• Re: Postgres dblink example
  • From: Tom Lane
• Re: DBeaver does not show all tables in a Schema
  • From: Shaozhong SHI
• Postgres dblink example
  • From: Pratik Mehta
• Re: Incremental backup
  • From: Thomas Kellerer
• Re: DBeaver does not show all tables in a Schema
  • From: Ryan Booz
• Re: DBeaver does not show all tables in a Schema
  • From: Shaozhong SHI
• Re: Incremental backup
  • From: Peter J. Holzer
• Re: DBeaver does not show all tables in a Schema
  • From: negora
• Re: Incremental backup
  • From: Mladen Gogala
• Re: Incremental backup
  • From: Peter J. Holzer
• Re: DBeaver does not show all tables in a Schema
  • From: Ron
• Re: Incremental backup
  • From: Mladen Gogala
• DBeaver does not show all tables in a Schema
  • From: Shaozhong SHI
• Re: Incremental backup
  • From: Peter J. Holzer
• Re: pg_dump and pg_restore and foreign keys
  • From: Tore Halvorsen
• Re: WAL File Recovery on Standby Server Stops Before End of WAL Files
  • From: Kyotaro Horiguchi
• Re: database designs ERDs
  • From: Zahid Rahman
• Re: Incremental backup
  • From: Mladen Gogala
• Re: Incremental backup
  • From: Ron
• Re: Incremental backup
  • From: Andreas Joseph Krogh
• Re: How to Resolve Data Being Truncated or Rounded Up During PostgreSQL Migration from v9.623 to v12.8?
  • From: Hilbert, Karin
• Re: Incremental backup
  • From: Ron
• Re: Incremental backup
  • From: Ron
• Re: Model clause and
  • From: Michael Lewis
• Re: Model clause and
  • From: Thomas Kellerer
• Re: Model clause and
  • From: Michael Lewis
• Re: Incremental backup
  • From: Adrian Klaver
• Re: Incremental backup
  • From: Bruce Momjian
• Re: Model clause and
  • From: SQL Padawan
• Model clause and
  • From: SQL Padawan
• Re: Incremental backup
  • From: Ron
• Re: Incremental backup
  • From: Adrian Klaver
• Re: Incremental backup
  • From: Ron
• Re: Incremental backup
  • From: Adrian Klaver
• Re: Incremental backup
  • From: Ron
• Re: Incremental backup
  • From: Paul Jungwirth
• Re: Incremental backup
  • From: Adrian Klaver
• Re: Incremental backup
  • From: Ron
• Re: Incremental backup
  • From: Edu Gargiulo
• Re: Incremental backup
  • From: Adrian Klaver
• Re: Incremental backup
  • From: Ivan E. Panchenko
• Re: How to Resolve Data Being Truncated or Rounded Up During PostgreSQL Migration from v9.623 to v12.8?
  • From: Adrian Klaver
• Re: How to Resolve Data Being Truncated or Rounded Up During PostgreSQL Migration from v9.623 to v12.8?
  • From: Tom Lane
• Re: database designs ERDs
  • From: Thomas Kellerer
• How to Resolve Data Being Truncated or Rounded Up During PostgreSQL Migration from v9.623 to v12.8?
  • From: Hilbert, Karin
• RE: WAL File Recovery on Standby Server Stops Before End of WAL Files
  • From: Ryan, Les
• Re: Incremental backup
  • From: Ron
• Incremental backup
  • From: Edu Gargiulo
• database designs ERDs
  • From: Zahid Rahman
• Re: jsonb: unwrapping text
  • From: tomas
• Re: WAL File Recovery on Standby Server Stops Before End of WAL Files
  • From: Dilip Kumar
• Re: WAL File Recovery on Standby Server Stops Before End of WAL Files
  • From: Kyotaro Horiguchi
• Re: jsonb: unwrapping text
  • From: David G. Johnston
• Re: Segmentation fault in volatile c function
  • From: Louise Grandjonc
• Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]
  • From: Adrian Klaver
• Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]
  • From: Jérémy Garniaux
• Re: Segmentation fault in volatile c function
  • From: Peter Geoghegan
• Segmentation fault in volatile c function
  • From: Louise Grandjonc
• jsonb: unwrapping text
  • From: tomas
• Re: Strange sequences - how to construct?
  • From: SQL Padawan
• Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]
  • From: Adrian Klaver
• WAL File Recovery on Standby Server Stops Before End of WAL Files
  • From: Ryan, Les
• Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]
  • From: Jérémy Garniaux
• Re: psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]
  • From: Adrian Klaver
• psql could not connect to server after complete reinstallation [Ubuntu 21.10 / PostgreSQL 13]
  • From: Jérémy Garniaux
• Re: ZFS filesystem - supported ?
  • From: Laurenz Albe
• Re: pg_dump and pg_restore and foreign keys
  • From: Tore Halvorsen
• Re: Determining if a table really changed in a trigger
  • From: Mitar
• Re: pg_dump and pg_restore and foreign keys
  • From: Tom Lane
• Re: pg_dump and pg_restore and foreign keys
  • From: Tore Halvorsen
• Re: pg_dump and pg_restore and foreign keys
  • From: Tom Lane
• Re: Python3 for PostgreSQL 14
  • From: Magnus Hagander
• pg_dump and pg_restore and foreign keys
  • From: Tore Halvorsen
• Re: Determining if a table really changed in a trigger
  • From: Marcos Pegoraro
• Re: String comparison fails for some cases after migration
  • From: Jayadevan M
• Re: Determining if a table really changed in a trigger
  • From: Thomas Kellerer
• Re: Determining if a table really changed in a trigger
  • From: Mitar
• Re: String comparison fails for some cases after migration
  • From: Tom Lane
• Re: String comparison fails for some cases after migration
  • From: Julien Rouhaud
• String comparison fails for some cases after migration
  • From: Jayadevan M
• Best options for tracking history of data?
  • From: Guyren Howe
• Re: ZFS filesystem - supported ?
  • From: Ron
• Re: Need help understanding error message [RESOLVED]
  • From: Ron
• Re: Determining if a table really changed in a trigger
  • From: Michael Lewis
• Re: ZFS filesystem - supported ?
  • From: Benedict Holland
• Re: ZFS filesystem - supported ?
  • From: Mladen Gogala
• Re: ZFS filesystem - supported ?
  • From: Imre Samu
• Re: ZFS filesystem - supported ?
  • From: Mladen Gogala
• Re: Determining if a table really changed in a trigger
  • From: Mitar