pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedFPGA 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