pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRE: Inefficient full seq scan on pg_largeobject instead of index scan
2018-01-23 14:08 UTC Jean-Marc Lessard <Jean-Marc.Lessard@ultra-ft.com>
query execution time (with cache)
2018-01-21 18:43 UTC Neto pr <netopr9@gmail.com>
pgaudit and create postgis extension logs a lot inserts
2018-01-18 12:12 UTC Svensson Peter <peter.svensson@smhi.se>
` Re: pgaudit and create postgis extension logs a lot inserts
2018-01-18 16:54 UTC Joe Conway <mail@joeconway.com>
` Re: pgaudit and create postgis extension logs a lot inserts
2018-01-19 11:05 UTC Magnus Hagander <magnus@hagander.net>
` RE: pgaudit and create postgis extension logs a lot inserts
2018-01-19 12:24 UTC Karen Stone <kstone@eldocomp.com>
` Re: pgaudit and create postgis extension logs a lot inserts
2018-01-19 13:41 UTC David Steele <david@pgmasters.net>
` Re: pgaudit and create postgis extension logs a lot inserts
2018-01-19 13:51 UTC David Steele <david@pgmasters.net>
` Re: pgaudit and create postgis extension logs a lot inserts
2018-01-20 13:05 UTC Magnus Hagander <magnus@hagander.net>
[7+ messages in thread]
PGadmin error while connecting with database.
2018-01-12 04:55 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: PGadmin error while connecting with database.
2018-01-12 08:44 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: Re: PGadmin error while connecting with database.
2018-01-14 04:10 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
[3+ messages in thread]
Slow queries after Windows startup
2018-01-11 08:19 UTC POUSSEL, Guillaume <guillaume.poussel@sogeti.com>
` Re: Slow queries after Windows startup
2018-01-11 09:01 UTC Robert Zenz <robert.zenz@sibvisions.com>
` RE: Slow queries after Windows startup
2018-01-11 09:06 UTC POUSSEL, Guillaume <guillaume.poussel@sogeti.com>
` Re: Slow queries after Windows startup
2018-01-11 09:54 UTC Robert Zenz <robert.zenz@sibvisions.com>
` RE: Slow queries after Windows startup
2018-01-11 13:36 UTC POUSSEL, Guillaume <guillaume.poussel@sogeti.com>
` RE: Slow queries after Windows startup
2018-01-11 21:08 UTC Éric Fontaine <efontaine2@yahoo.fr>
[6+ messages in thread]
Disjunctions and sequential scans
2018-01-11 16:30 UTC Ronuk Raval <ronuk.raval@gmail.com>
PG 9.5 2 tables same DDL with diff size
2018-01-09 22:54 UTC ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
` RE: PG 9.5 2 tables same DDL with diff size
2018-01-10 15:14 UTC Igor Neyman <ineyman@perceptron.com>
` RE: PG 9.5 2 tables same DDL with diff size
2018-01-10 15:48 UTC Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
` RE: PG 9.5 2 tables same DDL with diff size
2018-01-10 16:10 UTC Igor Neyman <ineyman@perceptron.com>
` Re: PG 9.5 2 tables same DDL with diff size
2018-01-10 18:49 UTC ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
[5+ messages in thread]
View preformance oracle to postgresql
2018-01-09 21:32 UTC Reddygari, Pavan <pkreddy@amazon.com>
` Re: View preformance oracle to postgresql
2018-01-10 10:41 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: View preformance oracle to postgresql
2018-01-10 13:58 UTC Merlin Moncure <mmoncure@gmail.com>
[3+ messages in thread]
Unable to connect Postgres using psql while postgres is already running.
2018-01-10 09:01 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Unable to connect Postgres using psql while postgres is already running.
2018-01-10 09:10 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` RE: Re: Unable to connect Postgres using psql while postgres is already running.
2018-01-10 12:42 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
[3+ messages in thread]
Performance of a Query
2018-01-09 21:18 UTC Kumar, Virendra <Virendra.Kumar@guycarp.com>
` Re: Performance of a Query
2018-01-09 22:08 UTC Scott Marlowe <scott.marlowe@gmail.com>
` RE: Performance of a Query
2018-01-09 22:25 UTC Kumar, Virendra <Virendra.Kumar@guycarp.com>
` Re: Performance of a Query
2018-01-09 22:59 UTC Scott Marlowe <scott.marlowe@gmail.com>
` RE: Performance of a Query
2018-01-09 23:09 UTC Kumar, Virendra <Virendra.Kumar@guycarp.com>
` Re: Performance of a Query
2018-01-09 23:25 UTC Scott Marlowe <scott.marlowe@gmail.com>
` RE: Performance of a Query
2018-01-10 03:29 UTC Danylo Hlynskyi <abcz2.uprola@gmail.com>
` Re: Performance of a Query
2018-01-10 08:51 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[8+ messages in thread]
Need Help on wal_compression
2018-01-09 06:53 UTC Rambabu V <ram.wissen@gmail.com>
` Re: Need Help on wal_compression
2018-01-09 16:53 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Need Help on wal_compression
2018-01-09 20:39 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Need Help on wal_compression
2018-01-09 21:33 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Need Help on wal_compression
2018-01-10 01:24 UTC Michael Paquier <michael.paquier@gmail.com>
[5+ messages in thread]
Batch insert heavily affecting query performance.
2017-12-24 19:51 UTC Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
2017-12-24 23:52 UTC MichaelDBA@sqlexec.com <michaeldba@sqlexec.com>
` Re: Batch insert heavily affecting query performance.
2017-12-25 00:09 UTC Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
2017-12-25 01:30 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Batch insert heavily affecting query performance.
2017-12-25 02:59 UTC Danylo Hlynskyi <abcz2.uprola@gmail.com>
` Re: Batch insert heavily affecting query performance.
2017-12-25 03:10 UTC Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
2017-12-27 15:13 UTC Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
2017-12-27 15:38 UTC Rick Otten <rottenwindfish@gmail.com>
` RE: Batch insert heavily affecting query performance.
2017-12-27 15:58 UTC Mike Sofen <msofen@runbox.com>
` Re: Batch insert heavily affecting query performance.
2017-12-27 16:02 UTC Jeremy Finzel <finzelj@gmail.com>
` Re: Batch insert heavily affecting query performance.
2017-12-27 16:23 UTC Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
2017-12-27 16:23 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Batch insert heavily affecting query performance.
2017-12-27 16:34 UTC Jean Baro <jfbaro@gmail.com>
` RE: Batch insert heavily affecting query performance.
2017-12-27 16:36 UTC Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
2017-12-27 16:37 UTC Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
2017-12-27 17:02 UTC Jean Baro <jfbaro@gmail.com>
` Re: Batch insert heavily affecting query performance.
2017-12-27 17:09 UTC Alvaro Hernandez <aht@ongres.com>
` RE: Batch insert heavily affecting query performance.
2017-12-27 17:10 UTC Mike Sofen <msofen@runbox.com>
` Re: Batch insert heavily affecting query performance.
2017-12-27 17:15 UTC David Miller <miller392@yahoo.com>
` Re: Batch insert heavily affecting query performance.
2018-01-09 19:45 UTC Claudio Freire <klaussfreire@gmail.com>
[20+ messages in thread]
Updating a large table
2017-12-22 16:46 UTC Timokhin Maxim <ncx2@yandex.com>
` Re: Updating a large table
2017-12-23 11:31 UTC salah jubeh <s_jubeh@yahoo.com>
` Re: Updating a large table
2017-12-23 20:58 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Updating a large table
2018-01-09 12:18 UTC Timokhin Maxim <ncx2@yandex.com>
` Re: Updating a large table
2018-01-09 12:53 UTC Sergei Kornilov <sk@zsrv.org>
` Re: Updating a large table
2018-01-09 16:31 UTC Timokhin Maxim <ncx2@yandex.com>
[6+ messages in thread]
seeing lag in postgresql replication
2018-01-08 09:21 UTC Rambabu V <ram.wissen@gmail.com>
` Re: seeing lag in postgresql replication
2018-01-08 10:31 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
[2+ messages in thread]
GEQO and join_collapse_limit correlation
2018-01-05 14:30 UTC Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
` Re: GEQO and join_collapse_limit correlation
2018-01-05 16:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: GEQO and join_collapse_limit correlation
2018-01-05 20:17 UTC Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
` Re: GEQO and join_collapse_limit correlation
2018-01-05 20:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: GEQO and join_collapse_limit correlation
2018-01-06 11:31 UTC Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
[5+ messages in thread]
primary key hash index
2018-01-02 14:02 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: primary key hash index
2018-01-02 14:09 UTC Magnus Hagander <magnus@hagander.net>
` Re: primary key hash index
2018-01-04 20:01 UTC Jeff Janes <jeff.janes@gmail.com>
[3+ messages in thread]
Restoring a table is ten times slower on Ubuntu 14.04 than on Ubuntu 16.04
2018-01-02 13:27 UTC Hans Braxmeier <hans.braxmeier@outlook.com>
` Re: Restoring a table is ten times slower on Ubuntu 14.04 than on Ubuntu 16.04
2018-01-02 13:30 UTC Vasilis Ventirozos <v.ventirozos@gmail.com>
[2+ messages in thread]
Re: partitioning an existing table - efficient pg_dump
2017-12-30 18:42 UTC Justin Pryzby <pryzby@telsasoft.com>
partitioning an existing table
2017-12-30 04:37 UTC Robert Blayzor <rblayzor.bulk@inoc.net>
` Re: partitioning an existing table
2017-12-30 05:38 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: partitioning an existing table
2017-12-30 14:19 UTC Robert Blayzor <rblayzor.bulk@inoc.net>
[3+ messages in thread]
analyze stats: child vs parent
2017-12-30 05:56 UTC Justin Pryzby <pryzby@telsasoft.com>
Re: Table performance with millions of rows (partitioning)
2017-12-28 01:20 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Table performance with millions of rows (partitioning)
2017-12-28 01:27 UTC Robert Blayzor <rblayzor.bulk@inoc.net>
` Re: Table performance with millions of rows (partitioning)
2017-12-28 02:22 UTC pinker <pinker@onet.eu>
[3+ messages in thread]
Table performance with millions of rows
2017-12-28 00:54 UTC Robert Blayzor <rblayzor.bulk@inoc.net>
Autoanalyze CPU usage
2017-12-19 16:47 UTC Habib Nahas <habibnahas@gmail.com>
` Re: Autoanalyze CPU usage
2017-12-19 17:09 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Autoanalyze CPU usage
2017-12-19 22:03 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Autoanalyze CPU usage
2017-12-19 22:53 UTC Habib Nahas <habibnahas@gmail.com>
` Re: Autoanalyze CPU usage
2017-12-19 22:53 UTC Habib Nahas <habibnahas@gmail.com>
` Re: Autoanalyze CPU usage
2017-12-19 22:55 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Autoanalyze CPU usage
2017-12-20 01:10 UTC Michaeldba@sqlexec.com <Michaeldba@sqlexec.com>
` Re: Autoanalyze CPU usage
2017-12-20 07:15 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Autoanalyze CPU usage
2017-12-20 08:24 UTC Nikolay Samokhvalov <samokhvalov@gmail.com>
` Re: Autoanalyze CPU usage
2017-12-20 14:38 UTC Habib Nahas <habibnahas@gmail.com>
[10+ messages in thread]
WHERE IN for JOIN subquery?
2017-12-19 00:00 UTC Dave Johansen <davejohansen@gmail.com>
` Re: WHERE IN for JOIN subquery?
2017-12-19 00:10 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: WHERE IN for JOIN subquery?
2017-12-19 00:29 UTC Dave Johansen <davejohansen@gmail.com>
[3+ messages in thread]
Re: Bitmap scan is undercosted? - overestimated correlation and cost_index
2017-12-06 21:46 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Bitmap scan is undercosted? - overestimated correlation and cost_index
2017-12-12 09:29 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Bitmap scan is undercosted? - overestimated correlation and cost_index
2017-12-15 20:54 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Bitmap scan is undercosted? - overestimated correlation and cost_index
2017-12-16 19:18 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Bitmap scan is undercosted? - overestimated correlation and cost_index
2017-12-17 02:37 UTC Justin Pryzby <pryzby@telsasoft.com>
[5+ 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