pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedstart pglogical subscription from a specific lsn
2024-09-22 20:45 UTC plsqlvids01 plsqlvids01 <plsqlvids01@gmail.com>
Clarify this MERGE warning? "Only columns from the target table that attempt to match data_source rows should appear in join_condition."
2024-09-09 13:02 UTC Philip Hazelden <philip.hazelden@gmail.com>
` Re: Clarify this MERGE warning? "Only columns from the target table that attempt to match data_source rows should appear in join_condition."
2024-09-09 16:17 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Clarify this MERGE warning? "Only columns from the target table that attempt to match data_source rows should appear in join_condition."
2024-09-21 12:48 UTC Peter J. Holzer <hjp-pgsql@hjp.at>
[3+ messages in thread]
re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-07-15 20:31 UTC Dan Kortschak <dan+pgsql@kortschak.io>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-07-23 20:11 UTC Vincent Veyron <vv.lists@wanadoo.fr>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-07-23 20:35 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-07-23 21:52 UTC Dominique Devienne <ddevienne@gmail.com>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-07-24 00:23 UTC Dan Kortschak <dan+pgsql@kortschak.io>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-07-24 19:50 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-09-14 08:33 UTC Dan Kortschak <dan+pgsql@kortschak.io>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-09-14 10:05 UTC Alban Hertroys <haramrae@gmail.com>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-09-14 10:30 UTC Dan Kortschak <dan+pgsql@kortschak.io>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-09-15 09:07 UTC Dan Kortschak <dan+pgsql@kortschak.io>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-09-15 11:22 UTC Alban Hertroys <haramrae@gmail.com>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-09-15 17:13 UTC Willow Chargin <postgresql@wchargin.com>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-09-21 03:33 UTC Dan Kortschak <dan+pgsql@kortschak.io>
` Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres
2024-09-21 06:52 UTC Dan Kortschak <dan+pgsql@kortschak.io>
[14+ messages in thread]
Dependencies on the system view
2024-09-20 11:32 UTC Olleg <splarv@ya.ru>
` Dependencies on the system view
2024-09-20 11:32 UTC Olleg <splarv@ya.ru>
` Re: Dependencies on the system view
2024-09-20 13:37 UTC Ron Johnson <ronljohnsonjr@gmail.com>
[3+ messages in thread]
pg_locks in production
2024-09-19 19:08 UTC Wizard Brony <wizardbrony@gmail.com>
` Re: pg_locks in production
2024-09-20 12:33 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[2+ messages in thread]
question on timezone with pgBackRest PITR
2024-09-20 08:01 UTC Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
PgBackRest and WAL archive expiry
2024-09-20 05:46 UTC KK CHN <kkchn.in@gmail.com>
` Re: PgBackRest and WAL archive expiry
2024-09-20 05:52 UTC Christophe Pettus <xof@thebuild.com>
[2+ messages in thread]
Need assistance in converting subqueries to joins
2024-09-20 04:07 UTC Siraj G <tosiraj.g@gmail.com>
` Re: Need assistance in converting subqueries to joins
2024-09-20 04:19 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Need assistance in converting subqueries to joins
2024-09-20 04:28 UTC Siraj G <tosiraj.g@gmail.com>
` Re: Need assistance in converting subqueries to joins
2024-09-20 04:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
CREATE DATABASE command concurrency
2024-09-17 21:52 UTC Wizard Brony <wizardbrony@gmail.com>
` Re: CREATE DATABASE command concurrency
2024-09-18 14:21 UTC Christophe Pettus <xof@thebuild.com>
` Re: CREATE DATABASE command concurrency
2024-09-18 14:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: CREATE DATABASE command concurrency
2024-09-19 03:53 UTC Muhammad Usman Khan <usman.k@bitnine.net>
[4+ messages in thread]
load fom csv
2024-09-16 15:35 UTC Andy Hartman <hartman60home@gmail.com>
` Re: load fom csv
2024-09-16 15:45 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: load fom csv
2024-09-16 15:47 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: load fom csv
2024-09-16 15:51 UTC Francisco Olarte <folarte@peoplecall.com>
` Re: load fom csv
2024-09-16 16:12 UTC Andy Hartman <hartman60home@gmail.com>
` Re: load fom csv
2024-09-16 16:17 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: load fom csv
2024-09-16 16:46 UTC Andy Hartman <hartman60home@gmail.com>
` Re: load fom csv
2024-09-16 16:56 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: load fom csv
2024-09-16 17:00 UTC Andy Hartman <hartman60home@gmail.com>
` Re: load fom csv
2024-09-16 17:10 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: load fom csv
2024-09-17 05:55 UTC Muhammad Usman Khan <usman.k@bitnine.net>
` Re: load fom csv
2024-09-17 12:31 UTC Andy Hartman <hartman60home@gmail.com>
` Re: load fom csv
2024-09-17 15:13 UTC Andy Hartman <hartman60home@gmail.com>
` Re: load fom csv
2024-09-17 15:23 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: load fom csv
2024-09-17 15:35 UTC Andy Hartman <hartman60home@gmail.com>
` Re: load fom csv
2024-09-17 15:39 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: load fom csv
2024-09-17 16:21 UTC Andy Hartman <hartman60home@gmail.com>
` Re: load fom csv
2024-09-17 16:25 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: load fom csv
2024-09-17 19:45 UTC Rob Sargent <robjsargent@gmail.com>
` Re: load fom csv
2024-09-17 23:10 UTC Andy Hartman <hartman60home@gmail.com>
` Re: load fom csv
2024-09-18 12:39 UTC Andy Hartman <hartman60home@gmail.com>
` Re: load fom csv
2024-09-18 13:29 UTC Rob Sargent <robjsargent@gmail.com>
` Re: load fom csv
2024-09-18 14:50 UTC Adrian Klaver <adrian.klaver@aklaver.com>
[23+ messages in thread]
Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-26 21:49 UTC nikhil raj <nikhilraj474@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-26 22:10 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-26 22:41 UTC nikhil raj <nikhilraj474@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 00:32 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 01:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 01:50 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 02:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 06:00 UTC Justin Clift <justin@postgresql.org>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 10:14 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 11:03 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 16:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 21:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 23:03 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 23:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 23:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-27 23:57 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-28 03:30 UTC Richard Guo <guofenglinux@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-28 03:52 UTC Richard Guo <guofenglinux@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-28 06:58 UTC Justin Clift <justin@postgresql.org>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-28 07:08 UTC Richard Guo <guofenglinux@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-28 07:31 UTC Richard Guo <guofenglinux@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-28 20:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-29 01:54 UTC Richard Guo <guofenglinux@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-29 06:49 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-08-29 20:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Significant Execution Time Difference Between PG13.14 and PG16.4 for Query on information_schema Tables.
2024-09-18 06:19 UTC nikhil raj <nikhilraj474@gmail.com>
[26+ messages in thread]
question on plain pg_dump file usage
2024-09-17 12:22 UTC Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
` Re: question on plain pg_dump file usage
2024-09-17 12:43 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: question on plain pg_dump file usage
2024-09-17 13:18 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: question on plain pg_dump file usage
2024-09-17 14:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: question on plain pg_dump file usage
2024-09-17 15:01 UTC Adrian Klaver <adrian.klaver@aklaver.com>
[5+ messages in thread]
WG: question on plain pg_dump file usage
2024-09-17 13:27 UTC Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
WG: [Extern] Re: question on plain pg_dump file usage
2024-09-17 13:16 UTC Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch>
update faster way
2024-09-14 03:13 UTC yudhi s <learnerdatabase99@gmail.com>
` Re: update faster way
2024-09-14 03:29 UTC Igor Korot <ikorot01@gmail.com>
` Re: update faster way
2024-09-14 03:58 UTC yudhi s <learnerdatabase99@gmail.com>
` Re: update faster way
2024-09-14 07:39 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: update faster way
2024-09-14 10:40 UTC yudhi s <learnerdatabase99@gmail.com>
` Re: update faster way
2024-09-14 11:24 UTC Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: update faster way
2024-09-14 14:47 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: update faster way
2024-09-14 14:56 UTC yudhi s <learnerdatabase99@gmail.com>
` Re: update faster way
2024-09-14 17:23 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: update faster way
2024-09-15 02:51 UTC Juan Rodrigo Alejandro Burgos Mella <rodrigoburgosmella@gmail.com>
` Re: update faster way
2024-09-15 22:18 UTC Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: update faster way
2024-09-17 05:36 UTC Muhammad Usman Khan <usman.k@bitnine.net>
` Re: update faster way
2024-09-17 08:28 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
[13+ messages in thread]
Manual query vs trigger during data load
2024-09-13 07:31 UTC yudhi s <learnerdatabase99@gmail.com>
` Manual query vs trigger during data load
2024-09-13 07:49 UTC Thiemo Kellner <thiemo@gelassene-pferde.biz>
` Re: Manual query vs trigger during data load
2024-09-13 09:58 UTC Juan Rodrigo Alejandro Burgos Mella <rodrigoburgosmella@gmail.com>
` Re: Manual query vs trigger during data load
2024-09-13 14:50 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Manual query vs trigger during data load
2024-09-13 14:57 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Manual query vs trigger during data load
2024-09-13 17:22 UTC Rob Sargent <robjsargent@gmail.com>
` Re: Manual query vs trigger during data load
2024-09-13 19:24 UTC yudhi s <learnerdatabase99@gmail.com>
` Re: Manual query vs trigger during data load
2024-09-14 10:47 UTC Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Manual query vs trigger during data load
2024-09-14 15:51 UTC yudhi s <learnerdatabase99@gmail.com>
` Re: Manual query vs trigger during data load
2024-09-15 21:22 UTC Peter J. Holzer <hjp-pgsql@hjp.at>
[10+ messages in thread]
Regarding snapshot generation during creation of logical slot in pgsql14
2024-09-15 16:43 UTC Durgamahesh Manne <maheshpostgres9@gmail.com>
Generate the valid snapshot during creation of for the purpose of taking pg_dump with --snapshot option
2024-09-15 11:44 UTC Durgamahesh Manne <maheshpostgres9@gmail.com>
Reg: Size difference
2024-09-13 12:09 UTC Vinay Oli <olivinay541@gmail.com>
` Re: Reg: Size difference
2024-09-13 13:52 UTC Karsten Hilbert <Karsten.Hilbert@gmx.net>
` Reg: Size difference
2024-09-14 17:19 UTC Vinay Oli <olivinay541@gmail.com>
` Re: Reg: Size difference
2024-09-14 17:29 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Reg: Size difference
2024-09-14 17:30 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Reg: Size difference
2024-09-14 18:00 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Reg: Size difference
2024-09-14 18:10 UTC Vinay Oli <olivinay541@gmail.com>
` Re: Reg: Size difference
2024-09-14 18:11 UTC Vinay Oli <olivinay541@gmail.com>
` Re: Reg: Size difference
2024-09-14 20:16 UTC Adrian Klaver <adrian.klaver@aklaver.com>
[9+ messages in thread]
Will hundred of thousands of this type of query cause Parsing issue
2024-09-13 15:34 UTC Wong, Kam Fook (TR Technology) <kamfook.wong@thomsonreuters.com>
` Re: Will hundred of thousands of this type of query cause Parsing issue
2024-09-13 16:58 UTC David Mullineux <dmullx@gmail.com>
` Re: Will hundred of thousands of this type of query cause Parsing issue
2024-09-13 19:04 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Will hundred of thousands of this type of query cause Parsing issue
2024-09-13 20:08 UTC shammat@gmx.net
[4+ messages in thread]
Functionally dependent columns in SELECT DISTINCT
2024-09-13 05:20 UTC Willow Chargin <postgresql@wchargin.com>
` Re: Functionally dependent columns in SELECT DISTINCT
2024-09-13 06:13 UTC shammat@gmx.net
` Re: Functionally dependent columns in SELECT DISTINCT
2024-09-13 15:26 UTC Willow Chargin <postgresql@wchargin.com>
` Re: Functionally dependent columns in SELECT DISTINCT
2024-09-13 15:43 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Functionally dependent columns in SELECT DISTINCT
2024-09-13 16:12 UTC Willow Chargin <postgresql@wchargin.com>
` Re: Functionally dependent columns in SELECT DISTINCT
2024-09-13 17:46 UTC David G. Johnston <david.g.johnston@gmail.com>
[6+ messages in thread]
DDL issue
2024-09-12 23:01 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: DDL issue
2024-09-12 23:32 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: DDL issue
2024-09-12 23:46 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: DDL issue
2024-09-13 04:43 UTC Muhammad Usman Khan <usman.k@bitnine.net>
` Re: DDL issue
2024-09-13 05:20 UTC Tony Shelver <tshelver@gmail.com>
` Re: DDL issue
2024-09-13 12:36 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: DDL issue
2024-09-13 12:38 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: DDL issue
2024-09-13 12:40 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: DDL issue
2024-09-13 12:42 UTC Rich Shepard <rshepard@appl-ecosys.com>
` Re: DDL issue
2024-09-13 16:27 UTC Rich Shepard <rshepard@appl-ecosys.com>
[10+ messages in thread]
post-bootstrap init : permission denied pg_description
2024-09-12 10:58 UTC François SIMON <francois.simon@free.fr>
` Re: post-bootstrap init : permission denied pg_description
2024-09-12 15:20 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: post-bootstrap init : permission denied pg_description
2024-09-12 16:03 UTC François SIMON <francois.simon@free.fr>
` Re: post-bootstrap init : permission denied pg_description
2024-09-12 16:52 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: post-bootstrap init : permission denied pg_description
2024-09-12 17:06 UTC François SIMON <francois.simon@free.fr>
` Re: post-bootstrap init : permission denied pg_description
2024-09-12 17:15 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: post-bootstrap init : permission denied pg_description
2024-09-12 17:20 UTC François SIMON <francois.simon@free.fr>
` Re: post-bootstrap init : permission denied pg_description
2024-09-12 17:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: post-bootstrap init : permission denied pg_description
2024-09-13 14:15 UTC François SIMON <francois.simon@free.fr>
[9+ messages in thread]
Storing plans with pg_stat_statements
2024-09-13 08:29 UTC Ebubekir Büyüktosun <ebubekir.buyuktosun@primeit.com.tr>
Better way to process records in bash?
2024-09-12 15:08 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Better way to process records in bash?
2024-09-12 15:42 UTC Thiemo Kellner <thiemo@gelassene-pferde.biz>
` Re: Better way to process records in bash?
2024-09-12 16:08 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Better way to process records in bash?
2024-09-12 19:30 UTC Christoph Moench-Tegeder <cmt@burggraben.net>
` Re: Better way to process records in bash?
2024-09-12 19:43 UTC Florents Tselai <florents.tselai@gmail.com>
` Re: Better way to process records in bash?
2024-09-12 19:43 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Better way to process records in bash?
2024-09-13 00:55 UTC Thiemo Kellner <thiemo@gelassene-pferde.biz>
[7+ messages in thread]
[next (older)]
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox