pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedExtremely slow when query uses GIST exclusion index
2018-08-29 03:31 UTC David <dchau+postgresql@hioscar.com>
` Re: Extremely slow when query uses GIST exclusion index
2018-08-29 10:50 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Extremely slow when query uses GIST exclusion index
2018-08-29 11:25 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Extremely slow when query uses GIST exclusion index
2018-08-29 18:10 UTC David <dchau+postgresql@hioscar.com>
` Re: Extremely slow when query uses GIST exclusion index
2018-08-29 18:48 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
[5+ messages in thread]
Bi-modal streaming replication throughput
2018-08-14 13:18 UTC Alexis Lê-Quôc <alq@datadoghq.com>
` Re: Bi-modal streaming replication throughput
2018-08-14 14:51 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Bi-modal streaming replication throughput
2018-08-14 17:46 UTC Andres Freund <andres@anarazel.de>
` Re: Bi-modal streaming replication throughput
2018-08-14 17:50 UTC Andres Freund <andres@anarazel.de>
` Re: Bi-modal streaming replication throughput
2018-08-17 13:21 UTC Alexis Lê-Quôc <alq@datadoghq.com>
` Re: Bi-modal streaming replication throughput
2018-08-17 13:46 UTC Andres Freund <andres@anarazel.de>
[6+ messages in thread]
increase insert into local table from remote oracle table preformance
2018-08-13 20:34 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Fwd: increase insert into local table from remote oracle table preformance
2018-08-13 20:35 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: Fwd: increase insert into local table from remote oracle table preformance
2018-08-13 21:03 UTC legrand legrand <legrand_legrand@hotmail.com>
` Re: increase insert into local table from remote oracle table preformance
2018-08-14 05:21 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: increase insert into local table from remote oracle table preformance
2018-08-14 07:12 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Fwd: increase insert into local table from remote oracle table preformance
2018-08-14 11:33 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: Fwd: increase insert into local table from remote oracle table preformance
2018-08-14 22:28 UTC legrand legrand <legrand_legrand@hotmail.com>
` Re: Fwd: increase insert into local table from remote oracle table preformance
2018-08-15 08:43 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: increase insert into local table from remote oracle table preformance
2018-08-15 11:42 UTC Andrew Kerber <andrew.kerber@gmail.com>
` Re: increase insert into local table from remote oracle table preformance
2018-08-15 15:52 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: Fwd: increase insert into local table from remote oracle table preformance
2018-08-15 20:26 UTC legrand legrand <legrand_legrand@hotmail.com>
[11+ messages in thread]
Calculating how much redo log space has been used
2018-08-14 18:51 UTC Reza Taheri <rtaheri@vmware.com>
` Re: Calculating how much redo log space has been used
2018-08-14 19:31 UTC Andres Freund <andres@anarazel.de>
` RE: Calculating how much redo log space has been used
2018-08-15 20:03 UTC Reza Taheri <rtaheri@vmware.com>
[3+ messages in thread]
Query with "ILIKE ALL" does not use the index
2018-07-26 15:53 UTC Nicolas Even <neven@ztel.org>
` Re: Query with "ILIKE ALL" does not use the index
2018-07-26 16:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query with "ILIKE ALL" does not use the index
2018-07-26 17:22 UTC Matthew Hall <mhall@mhcomputing.net>
` Re: Query with "ILIKE ALL" does not use the index
2018-07-26 19:17 UTC Nicolas Even <neven@ztel.org>
` Re: Query with "ILIKE ALL" does not use the index
2018-07-26 19:32 UTC Nicolas Even <neven@ztel.org>
[5+ messages in thread]
Automated bottleneck detection
2018-07-26 11:27 UTC Thomas Güttler <guettliml@thomas-guettler.de>
` Re: Automated bottleneck detection
2018-07-26 12:05 UTC MichaelDBA <MichaelDBA@sqlexec.com>
[2+ messages in thread]
Profile what the production server is doing
2018-07-23 11:18 UTC Thomas Güttler <guettliml@thomas-guettler.de>
` Re: Profile what the production server is doing
2018-07-23 11:38 UTC Julien Rouhaud <rjuju123@gmail.com>
` Re: Profile what the production server is doing
2018-07-23 14:01 UTC Baron Schwartz <baron.schwartz@gmail.com>
` Re: Profile what the production server is doing
2018-07-23 15:16 UTC Flo Rance <trourance@gmail.com>
` Re: Profile what the production server is doing
2018-07-25 09:14 UTC Thomas Güttler <guettliml@thomas-guettler.de>
` Re: Profile what the production server is doing
2018-07-25 09:17 UTC Thomas Güttler <guettliml@thomas-guettler.de>
` Re: Profile what the production server is doing
2018-07-25 09:39 UTC Thomas Güttler <guettliml@thomas-guettler.de>
` Re: Profile what the production server is doing
2018-07-25 09:49 UTC Flo Rance <trourance@gmail.com>
` Re: Profile what the production server is doing
2018-07-25 10:25 UTC Julien Rouhaud <rjuju123@gmail.com>
[9+ messages in thread]
Why HDD performance is better than SSD in this case
2018-07-17 05:00 UTC Neto pr <netopr9@gmail.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 05:17 UTC Benjamin Scherrey <scherrey@proteus-tech.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 05:43 UTC winston cheung <winston_cheung@163.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 06:07 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 07:40 UTC Robert Zenz <robert.zenz@sibvisions.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 08:08 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 13:04 UTC Neto pr <netopr9@gmail.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 13:19 UTC Neto pr <netopr9@gmail.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 13:28 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 13:44 UTC Nicolas Charles <nicolas.charles@normation.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 13:50 UTC Robert Zenz <robert.zenz@sibvisions.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 13:55 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 14:00 UTC Neto pr <netopr9@gmail.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 14:05 UTC Neto pr <netopr9@gmail.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 14:08 UTC Nicolas Charles <nicolas.charles@normation.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 14:16 UTC Nicolas Charles <nicolas.charles@normation.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 14:43 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 23:04 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Why HDD performance is better than SSD in this case
2018-07-17 23:28 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Why HDD performance is better than SSD in this case
2018-07-18 01:13 UTC Neto pr <netopr9@gmail.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-18 01:16 UTC Neto pr <netopr9@gmail.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-18 01:24 UTC Neto pr <netopr9@gmail.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-18 07:46 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: Why HDD performance is better than SSD in this case
2018-07-18 09:33 UTC Nicolas Charles <nicolas.charles@normation.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-18 09:35 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Why HDD performance is better than SSD in this case
2018-07-18 16:44 UTC George Neuner <gneuner2@comcast.net>
` Re: Why HDD performance is better than SSD in this case
2018-07-18 17:35 UTC Imre Samu <pella.samu@gmail.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-19 23:30 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Why HDD performance is better than SSD in this case
2018-07-20 00:33 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Why HDD performance is better than SSD in this case
2018-07-20 00:52 UTC Neto pr <netopr9@gmail.com>
` Re: Why HDD performance is better than SSD in this case
2018-07-20 01:49 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Why HDD performance is better than SSD in this case
2018-07-23 00:07 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[32+ messages in thread]
Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM)
2017-12-08 21:44 UTC Andres Freund <andres@anarazel.de>
` Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM)
2018-07-07 20:01 UTC Andres Freund <andres@anarazel.de>
` Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM)
2018-07-18 18:34 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM)
2018-07-19 20:32 UTC Andres Freund <andres@anarazel.de>
` Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM)
2018-07-20 12:27 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM)
2018-07-20 16:45 UTC Andres Freund <andres@anarazel.de>
[6+ messages in thread]
Improving Performance of Query ~ Filter by A, Sort by B
2018-07-10 15:07 UTC Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Improving Performance of Query ~ Filter by A, Sort by B
2018-07-11 21:41 UTC legrand legrand <legrand_legrand@hotmail.com>
` Re: Improving Performance of Query ~ Filter by A, Sort by B
2018-07-11 23:31 UTC Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Improving Performance of Query ~ Filter by A, Sort by B
2018-07-12 03:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Improving Performance of Query ~ Filter by A, Sort by B
2018-07-15 03:25 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Improving Performance of Query ~ Filter by A, Sort by B
2018-07-16 21:29 UTC Lincoln Swaine-Moore <lswainemoore@gmail.com>
` Re: Improving Performance of Query ~ Filter by A, Sort by B
2018-07-17 15:59 UTC Jeff Janes <jeff.janes@gmail.com>
[7+ messages in thread]
Special bloom index of INT, BIGINT, BIT, VARBIT for bitwise operation
2018-07-11 06:02 UTC Takao Magoori <mago@magomago.jp>
` Re: Special bloom index of INT, BIGINT, BIT, VARBIT for bitwise operation
2018-07-17 14:57 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[2+ messages in thread]
HDD vs SSD without explanation
2018-01-14 20:44 UTC Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-14 21:40 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: HDD vs SSD without explanation
2018-01-14 23:59 UTC Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-15 02:25 UTC Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-15 02:36 UTC Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-15 03:09 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: HDD vs SSD without explanation
2018-01-15 11:04 UTC Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-15 12:35 UTC Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-15 18:32 UTC Georg H. <georg-h@silentrunner.de>
` Re: HDD vs SSD without explanation
2018-01-15 19:46 UTC Brian Busch <bdbuschg@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-15 19:55 UTC Fernando Hevia <fhevia@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-15 23:10 UTC Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-15 23:25 UTC Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-16 00:18 UTC Fernando Hevia <fhevia@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-16 01:19 UTC Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-16 01:58 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: HDD vs SSD without explanation
2018-01-16 02:25 UTC Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-16 04:04 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: HDD vs SSD without explanation
2018-01-16 10:14 UTC Neto pr <netopr9@gmail.com>
` Re: HDD vs SSD without explanation
2018-01-16 15:08 UTC Nicolas Charles <nicolas.charles@normation.com>
` Re: HDD vs SSD without explanation
2018-01-16 21:24 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: HDD vs SSD without explanation
2018-07-17 12:47 UTC Neto pr <netopr9@gmail.com>
[22+ messages in thread]
High concurrency but simple updating causes deadlock
2018-07-11 14:16 UTC =?gb18030?B?t+M=?= <liufeng_leo@qq.com>
` Re: High concurrency but simple updating causes deadlock
2018-07-12 10:55 UTC Roman Konoval <rkonoval@gmail.com>
[2+ messages in thread]
Suggestion to optimize performance of the PLSQL procedure.
2018-07-12 03:18 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))
2018-05-25 01:00 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))
2018-06-20 15:13 UTC Bruce Momjian <bruce@momjian.us>
` Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))
2018-06-22 09:23 UTC Amit Kapila <amit.kapila16@gmail.com>
` Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))
2018-07-09 15:19 UTC Bruce Momjian <bruce@momjian.us>
[4+ messages in thread]
where can I download the binaries of plpython extension
2018-07-08 13:06 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: where can I download the binaries of plpython extension
2018-07-08 13:20 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: where can I download the binaries of plpython extension
2018-07-08 13:24 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: where can I download the binaries of plpython extension
2018-07-08 13:33 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: where can I download the binaries of plpython extension
2018-07-08 13:38 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: where can I download the binaries of plpython extension
2018-07-08 13:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: where can I download the binaries of plpython extension
2018-07-08 13:43 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: where can I download the binaries of plpython extension
2018-07-08 13:46 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: where can I download the binaries of plpython extension
2018-07-08 14:18 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: where can I download the binaries of plpython extension
2018-07-08 14:36 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: where can I download the binaries of plpython extension
2018-07-08 17:25 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: where can I download the binaries of plpython extension
2018-07-09 06:18 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
[12+ messages in thread]
Problems with installing pgwatch2 without docker
2018-07-08 14:22 UTC Mariel Cherkassky <MarielC@bezeqint.co.il>
` Re: Problems with installing pgwatch2 without docker
2018-07-08 16:35 UTC Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
[2+ messages in thread]
Trigger overhead/performance and alternatives?
2018-07-01 09:31 UTC AJG <ayden@gera.co.nz>
` Re: Trigger overhead/performance and alternatives?
2018-07-07 07:47 UTC Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
[2+ messages in thread]
tcp_keepalives
2018-07-04 13:19 UTC José Mello Júnior <jose.mello.junior@gmail.com>
` Re: tcp_keepalives
2018-07-05 03:56 UTC Justin Pryzby <pryzby@telsasoft.com>
[2+ messages in thread]
Bug in PostgreSQL
2018-06-27 15:30 UTC Rambabu V <ram.wissen@gmail.com>
` Re: Bug in PostgreSQL
2018-06-27 15:50 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: Bug in PostgreSQL
2018-06-27 15:53 UTC Joseph Curtin <jbcurtincode@gmail.com>
` Re: Bug in PostgreSQL
2018-06-28 06:55 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Bug in PostgreSQL
2018-06-28 16:13 UTC Andres Freund <andres@anarazel.de>
[5+ messages in thread]
Queue table that quickly grows causes query planner to choose poor plan
2018-06-27 03:45 UTC David Wheeler <dwheeler@dgitsystems.com>
` Re: Queue table that quickly grows causes query planner to choose poor plan
2018-06-27 18:05 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Queue table that quickly grows causes query planner to choose poor plan
2018-06-27 18:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queue table that quickly grows causes query planner to choose poor plan
2018-06-28 00:00 UTC David Wheeler <dwheeler@dgitsystems.com>
[4+ messages in thread]
Slow join
2018-06-25 15:55 UTC Roman Kushnir <roman.kushnir@ad2games.com>
` Re: Slow join
2018-06-25 16:45 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Slow join
2018-06-25 19:39 UTC Roman Kushnir <roman.kushnir@ad2games.com>
` Re: Slow join
2018-06-27 08:19 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Slow join
2018-06-27 09:02 UTC Roman Kushnir <roman.kushnir@ad2games.com>
[5+ messages in thread]
"set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench
2018-06-26 12:21 UTC Elvir Kurić <elvirkuric@gmail.com>
` Re: "set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench
2018-06-26 12:41 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: "set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench
2018-06-26 12:51 UTC Elvir Kurić <elvirkuric@gmail.com>
[3+ messages in thread]
Slow query when pg_trgm is in inner lopp
2018-06-20 13:21 UTC Sasa Vilic <sasavilic@gmail.com>
` Re: Slow query when pg_trgm is in inner lopp
2018-06-20 13:29 UTC Matthew Hall <mhall@mhcomputing.net>
` Re: Slow query when pg_trgm is in inner lopp
2018-06-20 14:13 UTC Sasa Vilic <sasavilic@gmail.com>
` Re: Slow query when pg_trgm is in inner lopp
2018-06-20 14:53 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Slow query when pg_trgm is in inner lopp
2018-06-20 15:38 UTC Sasa Vilic <sasavilic@gmail.com>
[5+ messages in thread]
[PERFORM] Dissuade the use of exclusion constraint index
2018-04-06 16:30 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: [PERFORM] Dissuade the use of exclusion constraint index
2018-04-11 05:59 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: [PERFORM] Dissuade the use of exclusion constraint index
2018-04-11 09:41 UTC Dave Cramer <pg@fastcrypt.com>
` Re: [PERFORM] Dissuade the use of exclusion constraint index
2018-04-11 14:47 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: [PERFORM] Dissuade the use of exclusion constraint index
2018-06-13 15:59 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: [PERFORM] Dissuade the use of exclusion constraint index
2018-06-19 19:50 UTC Adam Brusselback <adambrusselback@gmail.com>
[6+ 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