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: Query on Primary_conninfo | Michael Paquier | 00:55 |
| Re: Difference in the tablespace folders on primary and secondary nodes | Abhishek Bhola | 01:30 |
| Re: Difference in the tablespace folders on primary and secondary nodes | Stephen Frost | 02:39 |
| Re: How to improve the performance of my SQL query？ | David Rowley | 03:36 |
| Bogus temp file reporting? | kg.postgresql | 07:30 |
| Re: How to improve the performance of my SQL query？ | gzh | 08:09 |
| Re: Bogus temp file reporting? | Kyotaro Horiguchi | 08:31 |
| Re: Bogus temp file reporting? | kg.postgresql | 10:27 |
| Create DB privilege is not inherited | Ben Hancock | 12:47 |
| Re: Create DB privilege is not inherited | David G. Johnston | 13:09 |
| Re: Create DB privilege is not inherited | Ben Hancock | 14:37 |
| Reindex after upgrade from PostgreSQL 12.10 to PostgreSQL 15.3 | Hellen Jiang | 20:02 |
| password error in batch script | Atul Kumar | 20:17 |
| Re: How to improve the performance of my SQL query？ | Charly | 20:38 |
| Re: password error in batch script | Adrian Klaver | 21:45 |
| Thread | Author | Time |
|---|---|---|
| Re: backup_manifest rename to backup_manifest.old after successful postgres start up | Michael Paquier | 02:55 |
| How to get an md5/sha256 hash of a really large object in psql? | Alex Shan | 06:42 |
| Re: How to improve the performance of my SQL query？ | Peter J. Holzer | 08:59 |
| Re: How to improve the performance of my SQL query？ | Alban Hertroys | 09:37 |
| Timeout in Logical Replication | Philip Warner | 13:49 |
| Re: How to get an md5/sha256 hash of a really large object in psql? | Erik Wienhold | 16:57 |
| Thread | Author | Time |
|---|---|---|
| [Question]Can someone explain the context_freelists? | Wen Yi | 11:44 |
| Upgrading | Amn Ojee Uw | 11:53 |
| Re: Upgrading | Wen Yi | 12:04 |
| Re: Upgrading | Ron | 12:12 |
| Migrating MySQL DB to PostgreSQL DB. | Kaushal Shriyan | 14:01 |
| Re: Migrating MySQL DB to PostgreSQL DB. | Ken Marshall | 14:11 |
| Re: Migrating MySQL DB to PostgreSQL DB. | Adrian Klaver | 14:53 |
| Re: Upgrading | Peter J. Holzer | 15:34 |
| Re: Migrating MySQL DB to PostgreSQL DB. | Kaushal Shriyan | 17:53 |
| Re: Migrating MySQL DB to PostgreSQL DB. | Ron | 22:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Sample pg_hba.conf allows local users to access all databases | William Edwards | 08:08 |
| Different releases in the same server | marco.ptz | 14:31 |
| Re: Different releases in the same server | Christoph Moench-Tegeder | 14:57 |
| Re: Different releases in the same server | marco.ptz | 15:27 |
| Re: Different releases in the same server | Ron | 15:51 |
| Thread | Author | Time |
|---|---|---|
| question on auto_explain | Karsten Hilbert | 16:29 |
| Re: question on auto_explain | David G. Johnston | 16:35 |
| Aw: Re: question on auto_explain | Karsten Hilbert | 16:53 |
| Runaway Initial Table Syncs in Logical Replication? | Don Seiler | 19:24 |
| Aw: Re: question on auto_explain | Karsten Hilbert | 19:45 |
| Re: Installation Issue | Mark Atlantic | 22:58 |
| Thread | Author | Time |
|---|---|---|
| How does pg parse 'select '(1,2)'' | jacktby jacktby | 13:46 |
| How to solve the warning? 📎 | jacktby jacktby | 14:08 |
| Failed to parse new syntax | jacktby jacktby | 15:56 |
| Re: Failed to parse new syntax | Jan Wieck | 18:18 |
| Thread | Author | Time |
|---|---|---|
| Re:How to solve the warning? | Wen Yi | 02:50 |
| [Question] Can someone provide the explain of the relation between PGPROC and transaction? | Wen Yi | 02:54 |
| /usr/local/pgsql is empty after successful of make 📎 | Aramaki Zyake | 16:00 |
| Re: /usr/local/pgsql is empty after successful of make | Julien Rouhaud | 16:05 |
| Re: /usr/local/pgsql is empty after successful of make | Tom Lane | 16:08 |
| Re: /usr/local/pgsql is empty after successful of make | Adrian Klaver | 16:09 |
| Re: /usr/local/pgsql is empty after successful of make | Aramaki Zyake | 16:14 |
| Thread | Author | Time |
|---|---|---|
| Re: How to solve the warning? | Jeffrey Walton | 00:47 |
| Dropping all tables in a database | H | 01:17 |
| Re: Dropping all tables in a database | Christophe Pettus | 01:24 |
| Re: Dropping all tables in a database | Julien Rouhaud | 01:29 |
| Re: Dropping all tables in a database | David G. Johnston | 01:31 |
| Re: Dropping all tables in a database | Thorsten Glaser | 02:19 |
| Backup Copy of a Production server. | KK CHN | 05:02 |
| Re: Backup Copy of a Production server. | Ron | 05:19 |
| My 1st TABLESPACE | Amn Ojee Uw | 05:43 |
| Re: My 1st TABLESPACE | negora | 05:48 |
| Re: Dropping all tables in a database | Thomas Kellerer | 05:50 |
| Re: How does pg parse 'select '(1,2)'' | Kyotaro Horiguchi | 05:54 |
| Re: Backup Copy of a Production server. | KK CHN | 12:05 |
| Re: My 1st TABLESPACE | Amn Ojee Uw | 12:16 |
| Re: Backup Copy of a Production server. | Chris Travers | 12:30 |
| Re: Backup Copy of a Production server. | Ron | 13:17 |
| DB Server slow down & hang during Peak hours of Usage 📎 | KK CHN | 13:41 |
| Re: DB Server slow down & hang during Peak hours of Usage | Ron | 15:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Dropping all tables in a database | H | 00:59 |
| PostgreSQL 14.8 - server fails to start even though all transaction logs with base backup are restored | Meera Nair | 07:39 |
| Re: My 1st TABLESPACE | KK CHN | 09:33 |
| Re: DB Server slow down & hang during Peak hours of Usage | Marc Millas | 11:59 |
| Re: DB Server slow down & hang during Peak hours of Usage | Marc Millas | 12:19 |
| Re: DB Server slow down & hang during Peak hours of Usage | KK CHN | 12:51 |
| Re: PostgreSQL 14.8 - server fails to start even though all transaction logs with base backup are restored | Ron | 13:30 |
| Re: PostgreSQL 14.8 - server fails to start even though all transaction logs with base backup are restored | Stephen Frost | 14:18 |
| ignore_system_indexes=on no help for missing/corrupt pg_class_oid_index? | Jerry Sievers | 22:47 |
| Thread | Author | Time |
|---|---|---|
| PgSQL 15.3: Execution plan not using index as expected 📎 | Dürr Software | 08:14 |
| RE: PostgreSQL 14.8 - server fails to start even though all transaction logs with base backup are restored | Meera Nair | 10:19 |
| PrepareStatement and parameters data types | ihab sabiq | 12:01 |
| Re: PostgreSQL 14.8 - server fails to start even though all transaction logs with base backup are restored | Stephen Frost | 15:43 |
| How to set default privilege for new users to have no access to other databases? | Erik Nelson | 18:35 |
| Thread | Author | Time |
|---|---|---|
| Query regarding certificate authentication in postgres | Ashok Patil | 05:11 |
| Re: PgSQL 15.3: Execution plan not using index as expected | Adrian Klaver | 14:41 |
| Re: How to set default privilege for new users to have no access to other databases? | David G. Johnston | 16:06 |
| pb with big volumes | Marc Millas | 21:36 |
| Thread | Author | Time |
|---|---|---|
| Re: pb with big volumes | Ron | 01:09 |
| Re: pb with big volumes | Adam Scott | 01:41 |
| Re: pb with big volumes | Ron | 01:53 |
| Re: pb with big volumes | David Rowley | 04:40 |
| Re: pb with big volumes | Marc Millas | 10:17 |
| Re: pb with big volumes | Ron | 14:27 |
| Re: PgSQL 15.3: Execution plan not using index as expected | Adrian Klaver | 14:32 |
| Thread | Author | Time |
|---|---|---|
| Re: PgSQL 15.3: Execution plan not using index as expected | rob stone | 02:25 |
| Re: How to set default privilege for new users to have no access to other databases? | Peter J. Holzer | 08:17 |
| Re: PgSQL 15.3: Execution plan not using index as expected 📎 | Dürr Software | 09:01 |
| Re: PgSQL 15.3: Execution plan not using index as expected 📎 | Dürr Software | 09:03 |
| A Good Beginner's Book | Amn Ojee Uw | 13:02 |
| Re: A Good Beginner's Book | Amn Ojee Uw | 13:04 |
| Dynamically accessing columns from a row type in a trigger | Rhys A.D. Stewart | 20:09 |
| Re: Dynamically accessing columns from a row type in a trigger | Adrian Klaver | 20:22 |
| Re: Dynamically accessing columns from a row type in a trigger | Adrian Klaver | 20:31 |
| Re: A Good Beginner's Book | Miles Elam | 22:22 |
| Re: A Good Beginner's Book | Anthony DeBarros | 22:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Dynamically accessing columns from a row type in a trigger | Rhys A.D. Stewart | 03:21 |
| Re: Dynamically accessing columns from a row type in a trigger | Adrian Klaver | 04:28 |
| Re: Dynamically accessing columns from a row type in a trigger | David G. Johnston | 04:34 |
| Re: Dynamically accessing columns from a row type in a trigger | jian he | 04:53 |
| Re: pb with big volumes | Marc Millas | 23:14 |
| Re: pb with big volumes | David Rowley | 23:24 |
| Thread | Author | Time |
|---|---|---|
| Best strategy to perform individual incremental backups | Mario Diangelo | 09:51 |
| Fatal Error : Invalid Memory alloc request size 1236252631 | Sai Teja | 09:59 |
| Re: Fatal Error : Invalid Memory alloc request size 1236252631 | Andreas Kretschmer | 11:42 |
| Re: Best strategy to perform individual incremental backups | Stephen Frost | 12:58 |
| Query plan regression between CTE and views | David Gilman | 14:54 |
| Re: Fatal Error : Invalid Memory alloc request size 1236252631 | Sai Teja | 15:29 |
| Re: Query plan regression between CTE and views | Ron | 15:44 |
| How to optimize PostgreSQL Row Security Policies that involve related tables? | David Ventimiglia | 16:36 |
| Re: Fatal Error : Invalid Memory alloc request size 1236252631 | Rob Sargent | 17:25 |
| Re: Fatal Error : Invalid Memory alloc request size 1236252631 | Sai Teja | 17:31 |
| Re: How to optimize PostgreSQL Row Security Policies that involve related tables? | David Ventimiglia | 17:55 |