pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedWrong estimations and NL Anti join poor performance
2019-11-18 17:35 UTC Andrew Zakharov <Andrew898@mail.ru>
Out of memory error on automatic vacuum
2019-11-18 11:41 UTC Ekaterina Amez <ekaterina.amez@zunibal.com>
` Re: Out of memory error on automatic vacuum
2019-11-18 12:25 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Out of memory error on automatic vacuum
2019-11-18 14:02 UTC Ekaterina Amez <ekaterina.amez@zunibal.com>
` Re: Out of memory error on automatic vacuum
2019-11-18 14:16 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Out of memory error on automatic vacuum
2019-11-18 14:46 UTC Ekaterina Amez <ekaterina.amez@zunibal.com>
` Re: Out of memory error on automatic vacuum
2019-11-18 15:10 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[6+ messages in thread]
Simple DELETE on modest-size table runs 100% CPU forever
2019-11-14 22:19 UTC Craig James <cjames@emolecules.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
2019-11-14 22:22 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
2019-11-14 22:24 UTC Michael Lewis <mlewis@entrata.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
2019-11-14 22:28 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
2019-11-14 22:29 UTC Andres Freund <andres@anarazel.de>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
2019-11-15 21:06 UTC Craig James <cjames@emolecules.com>
` RE: Simple DELETE on modest-size table runs 100% CPU forever
2019-11-15 21:11 UTC Ravi Rai <ravi.p.rai@live.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
2019-11-15 22:44 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
2019-11-16 00:26 UTC Craig James <cjames@emolecules.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
2019-11-16 15:16 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Simple DELETE on modest-size table runs 100% CPU forever
2019-11-16 17:17 UTC Craig James <cjames@emolecules.com>
[11+ messages in thread]
JSON path
2019-11-14 13:55 UTC Jesper Pedersen <jesper.pedersen@redhat.com>
` Re: JSON path
2019-11-14 18:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: JSON path
2019-11-14 20:46 UTC Jesper Pedersen <jesper.pedersen@redhat.com>
[3+ messages in thread]
Re: parallel query
2019-04-02 11:28 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Parallel Query
2019-11-13 20:16 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Parallel Query
2019-11-13 20:40 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Parallel Query
2019-11-13 20:47 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Parallel Query
2019-11-13 21:04 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Parallel Query
2019-11-13 21:07 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
` Re: Parallel Query
2019-11-13 22:08 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Parallel Query
2019-11-13 22:21 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Parallel Query
2019-11-14 11:14 UTC Luís Roberto Weck <luisroberto@siscobra.com.br>
[9+ messages in thread]
Slow "not in array" operation
2019-11-12 17:29 UTC Marco Colli <collimarco91@gmail.com>
` Re: Slow "not in array" operation
2019-11-12 18:39 UTC Michael Lewis <mlewis@entrata.com>
` Re: Slow "not in array" operation
2019-11-12 19:04 UTC Marco Colli <collimarco91@gmail.com>
` Re: Slow "not in array" operation
2019-11-12 19:20 UTC Michael Lewis <mlewis@entrata.com>
` Re: Slow "not in array" operation
2019-11-12 19:53 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Slow "not in array" operation
2019-11-12 20:06 UTC Marco Colli <collimarco91@gmail.com>
` Re: Slow "not in array" operation
2019-11-12 20:31 UTC Michael Lewis <mlewis@entrata.com>
` Re: Slow "not in array" operation
2019-11-12 20:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow "not in array" operation
2019-11-12 21:40 UTC Marco Colli <collimarco91@gmail.com>
` Re: Slow "not in array" operation
2019-11-12 23:33 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Slow "not in array" operation
2019-11-13 09:20 UTC Marco Colli <collimarco91@gmail.com>
` Re: Slow "not in array" operation
2019-11-13 10:46 UTC Morris de Oryx <morrisdeoryx@gmail.com>
` Re: Slow "not in array" operation
2019-11-13 11:18 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Slow "not in array" operation
2019-11-13 11:30 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Slow "not in array" operation
2019-11-13 11:56 UTC Marco Colli <collimarco91@gmail.com>
` Re: Slow "not in array" operation
2019-11-13 12:18 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Slow "not in array" operation
2019-11-13 16:15 UTC Marco Colli <collimarco91@gmail.com>
[17+ messages in thread]
FPGA optimization ...
2019-11-04 23:33 UTC Gunther <raj@gusw.net>
` Re: FPGA optimization ...
2019-11-05 00:19 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: FPGA optimization ...
2019-11-05 04:52 UTC Gunther <raj@gusw.net>
` Re: FPGA optimization ...
2019-11-06 18:01 UTC AJG <ayden@gera.co.nz>
` Re: FPGA optimization ...
2019-11-06 21:54 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: FPGA optimization ...
2019-11-06 23:15 UTC Andres Freund <andres@anarazel.de>
` Re: FPGA optimization ...
2019-11-07 00:45 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[7+ messages in thread]
Slow planning, fast execution for particular 3-table query
2019-11-04 03:04 UTC David Wheeler <dwheeler@dgitsystems.com>
` Re: Slow planning, fast execution for particular 3-table query
2019-11-04 04:37 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Slow planning, fast execution for particular 3-table query
2019-11-04 04:42 UTC David Wheeler <dwheeler@dgitsystems.com>
` Re: Slow planning, fast execution for particular 3-table query
2019-11-04 04:46 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Slow planning, fast execution for particular 3-table query
2019-11-04 05:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow planning, fast execution for particular 3-table query
2019-11-04 05:17 UTC David Wheeler <dwheeler@dgitsystems.com>
` Re: Slow planning, fast execution for particular 3-table query
2019-11-04 05:53 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Slow planning, fast execution for particular 3-table query
2019-11-06 22:46 UTC David Wheeler <dwheeler@dgitsystems.com>
` Re: Slow planning, fast execution for particular 3-table query
2019-11-06 22:56 UTC Michael Lewis <mlewis@entrata.com>
` Re: Slow planning, fast execution for particular 3-table query
2019-11-06 22:59 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Slow planning, fast execution for particular 3-table query
2019-11-06 23:41 UTC David Wheeler <dwheeler@dgitsystems.com>
` Re: Slow planning, fast execution for particular 3-table query
2019-11-07 00:15 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Slow planning, fast execution for particular 3-table query
2019-11-07 00:18 UTC Justin Pryzby <pryzby@telsasoft.com>
[13+ messages in thread]
Huge shared hit for small table
2019-11-04 19:38 UTC Scott Rankin <srankin@motus.com>
` Re: Huge shared hit for small table
2019-11-04 19:46 UTC Andres Freund <andres@anarazel.de>
` Re: Huge shared hit for small table
2019-11-04 19:56 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Huge shared hit for small table
2019-11-04 19:56 UTC Scott Rankin <srankin@motus.com>
` Re: Huge shared hit for small table
2019-11-04 20:07 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Huge shared hit for small table
2019-11-04 20:17 UTC Andres Freund <andres@anarazel.de>
` Re: Huge shared hit for small table
2019-11-04 20:18 UTC Scott Rankin <srankin@motus.com>
` Re: Huge shared hit for small table
2019-11-04 20:31 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Huge shared hit for small table
2019-11-04 20:34 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Huge shared hit for small table
2019-11-04 20:38 UTC Scott Rankin <srankin@motus.com>
` Re: Huge shared hit for small table
2019-11-04 20:40 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Huge shared hit for small table
2019-11-04 21:00 UTC Scott Rankin <srankin@motus.com>
` Re: Huge shared hit for small table
2019-11-04 21:05 UTC Jeff Janes <jeff.janes@gmail.com>
[13+ messages in thread]
Barman
2019-10-31 17:29 UTC Daulat Ram <Daulat.Ram@exponential.com>
` Re: Barman
2019-10-31 18:56 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` RE: Barman
2019-11-01 09:42 UTC Daulat Ram <Daulat.Ram@exponential.com>
[3+ messages in thread]
GIN index on JSONB not used due to lack of nested statistics
2019-10-30 16:24 UTC Alessandro Baretta <alex@atomifi.com>
` Re: GIN index on JSONB not used due to lack of nested statistics
2019-10-30 22:31 UTC Jeff Janes <jeff.janes@gmail.com>
[2+ messages in thread]
Can you please tell us how set this prefetch attribute in following lines.
2019-10-17 11:16 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
` Re: Can you please tell us how set this prefetch attribute in following lines.
2019-10-17 16:18 UTC Reid Thompson <Reid.Thompson@omnicell.com>
` Re: Can you please tell us how set this prefetch attribute in following lines.
2019-10-17 17:05 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Can you please tell us how set this prefetch attribute in following lines.
2019-10-18 03:43 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
` RE: Can you please tell us how set this prefetch attribute in following lines.
2019-10-18 03:47 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
` Can you please tell us how set this prefetch attribute in following lines.
2019-10-18 03:47 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
` Re: Can you please tell us how set this prefetch attribute in following lines.
2019-10-18 16:15 UTC Justin Pryzby <pryzby@telsasoft.com>
` RE: Can you please tell us how set this prefetch attribute in following lines.
2019-10-30 16:47 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
[8+ messages in thread]
UNION causes horrible plan on JOIN
2019-10-28 22:40 UTC Craig James <cjames@emolecules.com>
` Re: UNION causes horrible plan on JOIN
2019-10-28 22:45 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: UNION causes horrible plan on JOIN
2019-10-28 23:30 UTC Craig James <cjames@emolecules.com>
` Re: UNION causes horrible plan on JOIN
2019-10-28 23:37 UTC Craig James <cjames@emolecules.com>
` Re: UNION causes horrible plan on JOIN
2019-10-29 03:24 UTC Kyotaro Horiguchi <horikyota.ntt@gmail.com>
[5+ messages in thread]
Notifications within triggers seem to compromise performance
2019-10-28 13:42 UTC Grégoire de Turckheim <gdeturckheim@scaleway.com>
` Re: Notifications within triggers seem to compromise performance
2019-10-28 14:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Notifications within triggers seem to compromise performance
2019-10-28 15:39 UTC Grégoire de Turckheim <gdeturckheim@scaleway.com>
` Re: Notifications within triggers seem to compromise performance
2019-10-28 16:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Notifications within triggers seem to compromise performance
2019-10-28 16:35 UTC Grégoire de Turckheim <gdeturckheim@scaleway.com>
[5+ messages in thread]
max_connections
2019-10-22 12:28 UTC Joao Junior <jcoj2006@gmail.com>
` Re: max_connections
2019-10-22 12:39 UTC Pavel Stehule <pavel.stehule@gmail.com>
[2+ messages in thread]
Change in CTE treatment in query plans?
2019-10-15 11:28 UTC David Conlin <dc345@cantab.net>
` Re: Change in CTE treatment in query plans?
2019-10-17 09:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Change in CTE treatment in query plans?
2019-10-21 13:22 UTC David Conlin <dc345@cantab.net>
[3+ messages in thread]
pg_stat_bgwriter
2019-10-14 01:27 UTC dangal <danielito.gallo@gmail.com>
` Re: pg_stat_bgwriter
2019-10-14 18:18 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: pg_stat_bgwriter
2019-10-14 20:12 UTC dangal <danielito.gallo@gmail.com>
` Re: pg_stat_bgwriter
2019-10-14 22:16 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: pg_stat_bgwriter
2019-10-15 00:39 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: pg_stat_bgwriter
2019-10-16 17:37 UTC dangal <danielito.gallo@gmail.com>
` Re: pg_stat_bgwriter
2019-10-16 19:13 UTC dangal <danielito.gallo@gmail.com>
` Re: pg_stat_bgwriter
2019-10-17 23:47 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: pg_stat_bgwriter
2019-10-18 00:50 UTC dangal <danielito.gallo@gmail.com>
` Re: pg_stat_bgwriter
2019-10-18 00:55 UTC dangal <danielito.gallo@gmail.com>
[10+ messages in thread]
Reading explain plans- row estimates/actuals on lower nodes vs next level up
2019-10-17 21:15 UTC Michael Lewis <mlewis@entrata.com>
` Re: Reading explain plans- row estimates/actuals on lower nodes vs next level up
2019-10-18 00:13 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[2+ messages in thread]
Optimising a two column OR check
2019-10-12 14:39 UTC Ivan Voras <ivoras@gmail.com>
` Re: Optimising a two column OR check
2019-10-12 14:43 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Optimising a two column OR check
2019-10-12 15:16 UTC Andrew Gierth <andrew@tao11.riddles.org.uk>
` Re: Optimising a two column OR check
2019-10-12 15:17 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Optimising a two column OR check
2019-10-12 15:27 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Optimising a two column OR check
2019-10-12 15:33 UTC Andrew Gierth <andrew@tao11.riddles.org.uk>
` Re: Optimising a two column OR check
2019-10-12 15:33 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Optimising a two column OR check
2019-10-12 15:35 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Optimising a two column OR check
2019-10-12 15:45 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Optimising a two column OR check
2019-10-12 15:46 UTC Andrew Gierth <andrew@tao11.riddles.org.uk>
` Re: Optimising a two column OR check
2019-10-12 15:54 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Optimising a two column OR check
2019-10-12 16:58 UTC Andrew Gierth <andrew@tao11.riddles.org.uk>
` Re: Optimising a two column OR check
2019-10-13 13:29 UTC Ivan Voras <ivoras@gmail.com>
` Re: Optimising a two column OR check
2019-10-13 13:38 UTC Ivan Voras <ivoras@gmail.com>
[14+ messages in thread]
Modification of data in base folder and very large tables
2019-10-08 20:20 UTC Ogden Brash <info@litika.com>
` Re: Modification of data in base folder and very large tables
2019-10-09 08:42 UTC Andrew Gierth <andrew@tao11.riddles.org.uk>
` Re: Modification of data in base folder and very large tables
2019-10-09 18:42 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Modification of data in base folder and very large tables
2019-10-09 23:05 UTC Jerry Sievers <gsievers19@comcast.net>
` Re: Modification of data in base folder and very large tables
2019-10-10 05:01 UTC Ogden Brash <info@litika.com>
` Re: Modification of data in base folder and very large tables
2019-10-10 12:05 UTC Andrew Gierth <andrew@tao11.riddles.org.uk>
` Re: Modification of data in base folder and very large tables
2019-10-11 01:08 UTC Jeff Janes <jeff.janes@gmail.com>
[7+ messages in thread]
Query slow again after adding an `OR` operation (was: Slow PostgreSQL 10.6 query)
2019-10-09 12:07 UTC Behrang Saeedzadeh <behrangsa@gmail.com>
` Re: Query slow again after adding an `OR` operation (was: Slow PostgreSQL 10.6 query)
2019-10-09 19:36 UTC Michael Lewis <mlewis@entrata.com>
` Re: Query slow again after adding an `OR` operation (was: Slow PostgreSQL 10.6 query)
2019-10-09 22:06 UTC David Rowley <david.rowley@2ndquadrant.com>
[3+ messages in thread]
Would SSD improve Index Only Scan performance by a lot?
2019-10-08 23:37 UTC Arya F <arya6000@gmail.com>
` Re: Would SSD improve Index Only Scan performance by a lot?
2019-10-09 00:12 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Would SSD improve Index Only Scan performance by a lot?
2019-10-09 03:17 UTC Matthew Hall <mhall@mhcomputing.net>
` Re: Would SSD improve Index Only Scan performance by a lot?
2019-10-09 19:54 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
Get the planner used by a query?
2019-10-09 06:21 UTC Behrang Saeedzadeh <behrangsa@gmail.com>
` Re: Get the planner used by a query?
2019-10-09 18:15 UTC David Rowley <david.rowley@2ndquadrant.com>
[2+ messages in thread]
Query slows when used with view
2019-10-09 12:31 UTC =?iso-8859-9?Q?Yavuz_Selim_Serto=F0lu_=28ETIYA=29?= <yavuz.sertoglu@etiya.com>
` Re: Query slows when used with view
2019-10-09 13:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` RE: Query slows when used with view
2019-10-09 14:55 UTC =?iso-8859-9?Q?Yavuz_Selim_Serto=F0lu_=28ETIYA=29?= <yavuz.sertoglu@etiya.com>
` Re: Query slows when used with view
2019-10-09 15:23 UTC Michael Lewis <mlewis@entrata.com>
` Re: Query slows when used with view
2019-10-09 15:24 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Query slows when used with view
2019-10-09 15:32 UTC Michael Lewis <mlewis@entrata.com>
` Re: Query slows when used with view
2019-10-09 16:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
[7+ messages in thread]
Sv: Would SSD improve Index Only Scan performance by a lot?
2019-10-08 23:42 UTC Andreas Joseph Krogh <andreas@visena.com>
[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