pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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  Yavuz Selim Sertoðlu (ETIYA) <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  Yavuz Selim Sertoðlu (ETIYA) <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>

Re: Out of Memory errors are frustrating as heck!
  2019-08-23 13:17 UTC  Gunther <raj@gusw.net>
` Re: Out of Memory errors are frustrating as heck!
  2019-08-23 14:19 UTC  Gunther <raj@gusw.net>
` Re: Out of Memory errors are frustrating as heck!
  2019-08-23 14:20 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Out of Memory errors are frustrating as heck!
  2019-08-24 15:40 UTC  Gunther <raj@gusw.net>
` Re: Out of Memory errors are frustrating as heck!
  2019-10-06 21:06 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Out of Memory errors are frustrating as heck!
  2019-10-06 21:11 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Out of Memory errors are frustrating as heck!
  2019-10-08 17:44 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: Out of Memory errors are frustrating as heck!
  2019-10-08 17:50 UTC  Merlin Moncure <mmoncure@gmail.com>
  [8+ messages in thread]

distinct on extract returns composite type
  2019-09-29 09:46 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: distinct on extract returns composite type
  2019-09-29 10:34 UTC  Félix GERZAGUET <felix.gerzaguet@gmail.com>
` Re: distinct on extract returns composite type
  2019-09-30 13:42 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: distinct on extract returns composite type
  2019-09-30 13:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: distinct on extract returns composite type
  2019-09-30 13:51 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: distinct on extract returns composite type
  2019-10-07 21:53 UTC  Michael Lewis <mlewis@entrata.com>
  [6+ messages in thread]

Slow PostgreSQL 10.6 query
  2019-10-01 12:37 UTC  Behrang Saeedzadeh <behrangsa@gmail.com>
` Re: Slow PostgreSQL 10.6 query
  2019-10-01 13:27 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow PostgreSQL 10.6 query
  2019-10-01 13:42 UTC  Behrang Saeedzadeh <behrangsa@gmail.com>
` Re: Slow PostgreSQL 10.6 query
  2019-10-06 20:37 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Slow PostgreSQL 10.6 query
  2019-10-07 08:27 UTC  Behrang Saeedzadeh <behrangsa@gmail.com>
  [5+ messages in thread]

Delete huge Table under XFS
  2019-09-19 15:59 UTC  Joao Junior <jcoj2006@gmail.com>
` Re: Delete huge Table under XFS
  2019-09-19 16:50 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Delete huge Table under XFS
  2019-09-19 17:00 UTC  Joao Junior <jcoj2006@gmail.com>
` Re: Delete huge Table under XFS
  2019-09-19 17:27 UTC  Christoph Berg <myon@debian.org>
` Re: Delete huge Table under XFS
  2019-10-06 20:54 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  [5+ messages in thread]

Query went slow all of sudden. ON V 11.3
  2019-10-04 10:22 UTC  nikhil raj <nikhilraj474@gmail.com>
` Re: Query went slow all of sudden. ON V 11.3
  2019-10-04 13:20 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Query went slow all of sudden. ON V 11.3
  2019-10-04 13:58 UTC  nikhil raj <nikhilraj474@gmail.com>
` Re: Query went slow all of sudden. ON V 11.3
  2019-10-04 19:07 UTC  Michael Lewis <mlewis@entrata.com>
` Re: Query went slow all of sudden. ON V 11.3
  2019-10-06 20:30 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  [5+ messages in thread]

Some observations on very slow pg_restore operations
  2019-10-03 20:30 UTC  Ogden Brash <info@litika.com>
` Re: Some observations on very slow pg_restore operations
  2019-10-03 21:48 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: Some observations on very slow pg_restore operations
  2019-10-03 23:19 UTC  Ogden Brash <info@litika.com>
` Re: Some observations on very slow pg_restore operations
  2019-10-04 06:03 UTC  Justin Pryzby <pryzby@telsasoft.com>
  [4+ 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