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.
| Thread | Author | Time |
|---|---|---|
| Re: Support logical replication of DDLs 📎 | Zheng Li | 04:58 |
| Re: Support logical replication of DDLs | Ajin Cherian | 12:20 |
| Re: Support logical replication of DDLs 📎 | Ajin Cherian | 13:13 |
| PITR and instance without any activity | Adrien Nayrat | 16:53 |
| names of the WAL files | Matthias Apitz | 17:16 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 17:40 |
| Re: names of the WAL files | Reid Thompson | 18:22 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 22:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Support logical replication of DDLs | li jie | 02:37 |
| Re: Is there a way to know write statistics on an individual index | higherone | 08:28 |
| Re: Support logical replication of DDLs 📎 | vignesh C | 09:17 |
| Is there a way to detect that code is inside CREATE EXTENSION? | Michel Pelletier | 18:39 |
| Re: Is there a way to detect that code is inside CREATE EXTENSION? | Tom Lane | 18:49 |
| Re: Is there a way to detect that code is inside CREATE EXTENSION? | Julien Rouhaud | 18:58 |
| Re: Is there a way to detect that code is inside CREATE EXTENSION? | Michel Pelletier | 18:59 |
| Re: print in plpython not appearing in logs | Shaozhong SHI | 21:20 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 22:25 |
| Thread | Author | Time |
|---|---|---|
| Re: Test if a database has any privilege granted to public | Bryn Llewellyn | 00:17 |
| postgres_fdw does not push down DISTINCT | Christophe Pettus | 04:29 |
| Re: Test if a database has any privilege granted to public | David G. Johnston | 17:08 |
| Thread | Author | Time |
|---|---|---|
| Autovacuum on sys tables | Inzamam Shafiq | 07:15 |
| tsvector not giving expected results on one host | Dan Langille | 18:53 |
| Re: tsvector not giving expected results on one host | Dan Langille | 19:41 |
| Re: tsvector not giving expected results on one host | Tom Lane | 19:55 |
| Re: tsvector not giving expected results on one host | Dan Langille | 20:14 |
| Re: tsvector not giving expected results on one host | Dan Langille | 20:22 |
| Re: tsvector not giving expected results on one host | Dan Langille | 20:33 |
| Postgres Date Type Value | Michael Arnold | 23:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres Date Type Value | Tom Lane | 00:20 |
| Re: Postgres Date Type Value | David G. Johnston | 00:24 |
| Re: Postgres Date Type Value | Michael Arnold | 01:15 |
| integer square root function proposed | Martin L. Buchanan | 02:39 |
| Re: integer square root function proposed | Rob Sargent | 03:20 |
| Re: integer square root function proposed | Martin L. Buchanan | 03:40 |
| Re: integer square root function proposed | Rob Sargent | 03:56 |
| Re: integer square root function proposed | Tom Lane | 04:20 |
| Re: Autovacuum on sys tables | Thomas Boussekey | 11:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Autovacuum on sys tables | Inzamam Shafiq | 06:12 |
| Re: Autovacuum on sys tables | Thomas Boussekey | 08:31 |
| Re: Support logical replication of DDLs | li jie | 10:02 |
| Re: Support logical replication of DDLs 📎 | Ajin Cherian | 13:19 |
| Re: Support logical replication of DDLs | Alvaro Herrera | 15:29 |
| Selecting across servers | Brad White | 18:14 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 21:25 |
| Thread | Author | Time |
|---|---|---|
| RE: Support logical replication of DDLs | Takamichi Osumi (Fujitsu) | 06:03 |
| Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration) | Chetan Kosanam | 09:37 |
| Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline... | Andres Freund | 11:20 |
| Re: Implementing foreign data wrappers and avoiding n+1 querying | Brad White | 16:32 |
| Thread | Author | Time |
|---|---|---|
| How to write a crosstab which returns empty row results | David Goldsmith | 03:03 |
| Re: How to write a crosstab which returns empty row results | Brad White | 03:24 |
| Re: How to write a crosstab which returns empty row results | David Goldsmith | 07:25 |
| Re: How to write a crosstab which returns empty row results | David G. Johnston | 16:45 |
| Re: How to write a crosstab which returns empty row results | David Goldsmith | 16:56 |
| Re: How to write a crosstab which returns empty row results | David Goldsmith | 16:57 |
| Thread | Author | Time |
|---|---|---|
| best practice to patch a postgresql version? | qihua wu | 09:29 |
| Sample schemas and data that correlate with all examples in PostgreSQL documentation | Minh Van Le | 11:03 |
| Re: best practice to patch a postgresql version? | Ron | 15:54 |
| Thread | Author | Time |
|---|---|---|
| Re: best practice to patch a postgresql version? | qihua wu | 05:33 |
| Re: Support logical replication of DDLs 📎 | vignesh C | 06:13 |
| Re: best practice to patch a postgresql version? | Ron | 06:48 |
| Re: best practice to patch a postgresql version? | Guillaume Lelarge | 07:00 |
| Re: what is the solution like oracle DB's datafile | Eagna | 10:37 |
| Re: Support logical replication of DDLs 📎 | vignesh C | 12:03 |
| Re: what is the solution like oracle DB's datafile | Guillaume Lelarge | 15:43 |
| Re: best practice to patch a postgresql version? | Peter J. Holzer | 22:15 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 22:32 |
| Thread | Author | Time |
|---|---|---|
| https://wiki.postgresql.org/wiki/Working_with_Git link one link cannot open, another link is unrelated. | jian he | 10:01 |
| Re: Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration) | Adrian Klaver | 17:45 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 22:42 |
| Re: Support logical replication of DDLs | Zheng Li | 22:50 |
| Thread | Author | Time |
|---|---|---|
| Updating column default values in code | Brad White | 00:15 |
| Re: Updating column default values in code | David G. Johnston | 00:46 |
| Re: Updating column default values in code | Adrian Klaver | 01:10 |
| Re: Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration) | rob stone | 02:15 |
| Re: Regd. the Query w.r.t Alternative functionalities from Oracle PostgreSQL (Oracle to PostgreSQL database migration) | Ron | 02:17 |
| Re: https://wiki.postgresql.org/wiki/Working_with_Git link one link cannot open, another link is unrelated. | Melih Mutlu | 09:51 |
| Fwd: Segmentation fault on RelationGetDescr in my first extension | Дмитрий Цветков | 10:52 |
| Thread | Author | Time |
|---|---|---|
| Purging few months old data and vacuuming in production | Ranjith Paliyath | 06:39 |
| Re: Purging few months old data and vacuuming in production | Inzamam Shafiq | 07:17 |
| Re: Purging few months old data and vacuuming in production | Amitabh Kant | 07:18 |
| Re: Purging few months old data and vacuuming in production | Ron | 14:47 |
| Exact same output - pg_stat_statements | Rushikesh socha | 16:04 |
| Re: Exact same output - pg_stat_statements | Ron | 20:24 |
| Thread | Author | Time |
|---|---|---|
| Inserts create new records in reporting table | Bret Stern | 07:02 |
| Re: Inserts create new records in reporting table | Ron | 08:55 |
| Re: Exact same output - pg_stat_statements | Rushikesh socha | 17:26 |
| REINDEX vs VACUUM | Hao Zhang | 21:04 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Antonis Christodoulou | 20:51 |
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Adrian Klaver | 21:00 |
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Antonis Christodoulou | 21:11 |
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Adrian Klaver | 21:48 |
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Rob Sargent | 21:50 |
| Thread | Author | Time |
|---|---|---|
| Re: what kind of hash algorithm is used by hash_bytes()? | Julien Rouhaud | 01:41 |
| Re: Exact same output - pg_stat_statements | Julien Rouhaud | 05:52 |
| Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours | Julien Rouhaud | 05:58 |
| postgres restore & needed history files | Zwettler Markus (OIZ) | 16:03 |
| Re: REINDEX vs VACUUM | Hao Zhang | 17:57 |
| Thread | Author | Time |
|---|---|---|
| Re: REINDEX vs VACUUM | Rébeli-Szabó Tamás | 13:25 |
| What is the best setup for distributed and fault-tolerant PG database? | Age Apache | 13:26 |
| Re: REINDEX vs VACUUM | Ron | 15:34 |
| curious postgres (crash) recovery behavior | Zwettler Markus (OIZ) | 16:54 |
| Re: REINDEX vs VACUUM | Rébeli-Szabó Tamás | 21:00 |
| Corrupt WAL in replication slot | Fontana Daniel (Desartec S.R.L.) | 21:24 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 21:35 |
| Re: curious postgres (crash) recovery behavior | Rébeli-Szabó Tamás | 21:52 |
| Re: What is the best setup for distributed and fault-tolerant PG database? | Rob Sargent | 23:54 |
| Thread | Author | Time |
|---|---|---|
| Re: What is the best setup for distributed and fault-tolerant PG database? | Saul Perdomo | 03:34 |
| Re: What is the best setup for distributed and fault-tolerant PG database? | Bryn Llewellyn | 04:28 |
| Re: REINDEX vs VACUUM | Brad White | 08:51 |
| Re: REINDEX vs VACUUM | Peter J. Holzer | 10:26 |
| Aw: Re: REINDEX vs VACUUM | Karsten Hilbert | 11:34 |
| Re: REINDEX vs VACUUM | Peter J. Holzer | 12:15 |
| PG replicas and transactions atomicity | Louis Laborde | 20:07 |
| Re: PG replicas and transactions atomicity | Christophe Pettus | 20:09 |
| Thread | Author | Time |
|---|---|---|
| Re: PG replicas and transactions atomicity | Ron | 00:03 |
| Re: PG replicas and transactions atomicity | Christophe Pettus | 00:04 |
| Re: PG replicas and transactions atomicity | Christophe Pettus | 03:46 |
| Re: postgres restore & needed history files | Laurenz Albe | 05:28 |
| Re: postgres restore & needed history files | Christophe Pettus | 05:34 |
| Re: best practice to patch a postgresql version? | Laurenz Albe | 05:43 |
| Re: Purging few months old data and vacuuming in production | Ranjith Paliyath | 08:44 |