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: Extension pg_trgm, permissions and pg_dump order | Noah Misch | 04:51 |
| Improve configurability for IO related behavoir | 浩辰 何 | 12:11 |
| JSONB index not in use, but is TOAST the real cause of slow query? | Shaheed Haque | 17:53 |
| Re: JSONB index not in use, but is TOAST the real cause of slow query? | Tom Lane | 18:41 |
| Re: JSONB index not in use, but is TOAST the real cause of slow query? | Shaheed Haque | 19:38 |
| Re: JSONB index not in use, but is TOAST the real cause of slow query? | Adrian Klaver | 19:58 |
| Re: JSONB index not in use, but is TOAST the real cause of slow query? | Tom Lane | 19:59 |
| Re: Improve configurability for IO related behavoir | Thomas Munro | 20:33 |
| Re: JSONB index not in use, but is TOAST the real cause of slow query? | Shaheed Haque | 20:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Order of rows in statement triggers NEW/OLD tables | Thomas Munro | 01:50 |
| GIN theory | [email protected] | 07:07 |
| function currtid2() in SQL and ESQL/C to get the new CTID of a row | Matthias Apitz | 10:59 |
| Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row | Tom Lane | 13:46 |
| Extended multivariate statistics are ignored (potentially related to high null fraction, not sure) | Danny Shemesh | 16:28 |
| Re: Extended multivariate statistics are ignored (potentially related to high null fraction, not sure) | Bruce Momjian | 20:08 |
| Re: unoptimized nested loops | David Rowley | 21:10 |
| Thread | Author | Time |
|---|---|---|
| Max sane value for join_collapse_limit? | Andreas Joseph Krogh | 08:19 |
| Re: GIN theory | jian he | 10:38 |
| Re: Support logical replication of DDLs | Amit Kapila | 11:15 |
| Re: Max sane value for join_collapse_limit? | Philip Semanchuk | 15:11 |
| Re: Logically replicated table has no visible rows | Jeff Ross | 17:10 |
| Re: Extension pg_trgm, permissions and pg_dump order | Nathan Bossart | 18:17 |
| Re: psql 15beta1 does not print notices on the console until transaction completes 📎 | Fabien COELHO | 18:25 |
| Why password authentication failed for user "postgres"? | BeginnerC | 22:32 |
| Re: Why password authentication failed for user "postgres"? | Reid Thompson | 22:38 |
| Thread | Author | Time |
|---|---|---|
| '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? | Bryn Llewellyn | 01:41 |
| Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? | David G. Johnston | 02:01 |
| Call pstrdup() of palloc.h will change source string, please help! | mengfanjun | 03:07 |
| Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? | Bryn Llewellyn | 04:45 |
| Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? | Tom Lane | 05:37 |
| Window function? | Robert Stanford | 08:18 |
| Re: unoptimized nested loops | Tim Kelly | 11:32 |
| Re: Window function? | Thiemo Kellner | 12:56 |
| Re: Window function? | Robert Stanford | 13:18 |
| Re: Window function? | Tom Lane | 14:50 |
| Re: Why password authentication failed for user "postgres"? | Jeff Janes | 16:00 |
| Re: Window function? | David G. Johnston | 16:25 |
| Re: Call pstrdup() of palloc.h will change source string, please help! | Tom Lane | 17:05 |
| Re: Window function? | John W Higgins | 17:06 |
| Thread | Author | Time |
|---|---|---|
| Logical replication of large objects | Andreas Joseph Krogh | 09:23 |
| Re: Why password authentication failed for user "postgres"? 📎 | Frank Finner | 23:06 |
| Re: Why password authentication failed for user "postgres"? | David G. Johnston | 23:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Extension pg_trgm, permissions and pg_dump order | Noah Misch | 06:30 |
| GSSAPI authentication | Niels Jespersen | 12:05 |
| Re: GSSAPI authentication | Michael van der Kolff | 12:26 |
| Re: GSSAPI authentication | Michael van der Kolff | 13:01 |
| SV: GSSAPI authentication | Niels Jespersen | 13:33 |
| Re: GSSAPI authentication | Michael van der Kolff | 13:41 |
| Re: GSSAPI authentication | Michael van der Kolff | 13:42 |
| Re: GSSAPI authentication | Michael van der Kolff | 13:49 |
| Re: [EXT] Re: Accessing composite type elements | Garfield Lewis | 15:22 |
| Thread | Author | Time |
|---|---|---|
| RE: Support logical replication of DDLs 📎 | [email protected] | 02:59 |
| SV: GSSAPI authentication | Niels Jespersen | 05:43 |
| Re: psql 15beta1 does not print notices on the console until transaction completes | Peter Eisentraut | 12:05 |
| SQL state: 42601. Execption handling. | Ц | 13:11 |
| SQL state: 42601. Execption handling. | Ц | 14:19 |
| Re: SQL state: 42601. Execption handling. | Tom Lane | 14:36 |
| Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really? | Merlin Moncure | 15:09 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL state: 42601. Execption handling. | Kyotaro Horiguchi | 01:12 |
| message log merge (streaming replication) | Peter Adlersburg | 07:59 |
| Re: psql 15beta1 does not print notices on the console until transaction completes | Fabien COELHO | 10:16 |
| [No subject] | Jim McNamara | 10:51 |
| Fwd: | Jim McNamara | 11:03 |
| FATAL: could not receive timeline history file from the primary server: ERROR: could not open file "pg_wal/0000000x.history": No such file or directory | pgdba pgdba | 16:43 |
| gawk extension linux missing stuff in package manager fedora 36 | Jim McNamara | 17:15 |
| Re: gawk extension linux missing stuff in package manager fedora 36 | Daniel Verite | 18:09 |
| Re: | Ian Lawrence Barwick | 23:13 |
| Thread | Author | Time |
|---|---|---|
| Re: Support logical replication of DDLs | Amit Kapila | 06:26 |
| How to drop a subscription inside a stored procedure? | Thomas Kellerer | 12:57 |
| Re: How to drop a subscription inside a stored procedure? | Adrian Klaver | 14:58 |
| multiple entries for synchronous_standby_names | Nitesh Nathani | 16:04 |
| How to get response message | Rama Krishnan | 16:37 |
| Re: How to get response message | Adrian Klaver | 16:47 |
| Re: How to get response message | Francisco Olarte | 18:57 |
| Re: How to get response message | David G. Johnston | 19:08 |
| Need optimization in query | Shubham Mittal | 19:18 |
| Re: How to drop a subscription inside a stored procedure? | Thomas Kellerer | 20:29 |
| Thread | Author | Time |
|---|---|---|
| newbie db design question | Rino Mardo | 07:05 |
| Re: newbie db design question | Gavan Schneider | 08:36 |
| Re: newbie db design question | Ray O'Donnell | 08:43 |
| Re: newbie db design question | Peter J. Holzer | 09:50 |
| PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P | Markur Sens | 19:49 |
| Re: PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P | Tom Lane | 21:06 |
| Re: PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P | Markur Sens | 21:14 |
| Re: PG_GETARG_TEXT_PP vs PG_GETARG_TEXT_P | Tom Lane | 21:25 |
| Thread | Author | Time |
|---|---|---|
| Re: newbie db design question | Rino Mardo | 00:20 |
| Re: Support logical replication of DDLs 📎 | Zheng Li | 06:46 |
| Thread | Author | Time |
|---|---|---|
| Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one" | Bryn Llewellyn | 01:40 |
| Re: multiple entries for synchronous_standby_names | Michael Paquier | 02:18 |
| RE: Build Postgres On AIX | Mark Hill | 03:43 |
| Re: Tools to convert timestamp data to another time zone in PostgreSQL | Ilya Anfimov | 06:53 |
| Postgres NOT IN vs NOT EXISTS optimization | Dirschel, Steve | 15:58 |
| Re: Postgres NOT IN vs NOT EXISTS optimization | Jeremy Smith | 16:06 |
| Re: Postgres NOT IN vs NOT EXISTS optimization | Tom Lane | 16:09 |
| Recent 11.16 release change | Daniel Brinzila | 19:30 |
| Re: Recent 11.16 release change | Tom Lane | 21:23 |
| Re: Recent 11.16 release change | Daniel Brinzila | 21:35 |
| Re: cast to domain with default collation issue. | Tom Lane | 21:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Support logical replication of DDLs | Zheng Li | 00:14 |
| Re: Support logical replication of DDLs | Amit Kapila | 04:00 |
| RE: Support logical replication of DDLs | [email protected] | 06:45 |