pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedUnderstanding ANALYZE memory usage with "big" tsvector columns
2016-02-04 09:12 UTC Jérôme Augé <jerome.auge@anakeen.com>
Hash join gets slower as work_mem increases?
2016-01-29 15:17 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Hash join gets slower as work_mem increases?
2016-01-29 15:21 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Hash join gets slower as work_mem increases?
2016-01-30 14:13 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Hash join gets slower as work_mem increases?
2016-02-01 09:38 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Hash join gets slower as work_mem increases?
2016-02-01 09:59 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Hash join gets slower as work_mem increases?
2016-02-01 10:08 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[6+ messages in thread]
jsonb_agg performance
2016-01-29 22:06 UTC jfleming@kispring.com
` Re: jsonb_agg performance
2016-01-29 23:34 UTC Andrew Dunstan <andrew@dunslane.net>
[2+ messages in thread]
Postgres partitions-query scanning all child tables
2016-01-27 22:09 UTC rverghese <riyav@hotmail.com>
` Re: Postgres partitions-query scanning all child tables
2016-01-28 04:30 UTC Corey Huinker <corey.huinker@gmail.com>
` Re: Postgres partitions-query scanning all child tables
2016-01-28 06:10 UTC rverghese <riyav@hotmail.com>
` Re: Postgres partitions-query scanning all child tables
2016-01-28 07:47 UTC Corey Huinker <corey.huinker@gmail.com>
` Re: Postgres partitions-query scanning all child tables
2016-01-28 19:51 UTC rverghese <riyav@hotmail.com>
[5+ messages in thread]
performance issue with inherited foreign table
2016-01-27 23:46 UTC Dzmitry Nikitsin <dzmitry.nikitsin@gmail.com>
Primary key index partially used
2016-01-26 15:52 UTC Florian Gossin <fluancefg@gmail.com>
` Re: Primary key index partially used
2016-01-26 16:01 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Primary key index partially used
2016-01-26 16:02 UTC Igor Neyman <ineyman@perceptron.com>
[3+ messages in thread]
Insert performance
2003-08-16 08:40 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Insert performance
2003-08-16 18:40 UTC Josh Berkus <josh@agliodbs.com>
` Re: Insert performance
2003-08-16 22:22 UTC Christopher Browne <cbbrowne@acm.org>
` Re: Insert performance
2003-08-18 06:21 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Insert performance
2003-08-18 15:52 UTC Hannu Krosing <hannu@tm.ee>
` Re: Insert performance
2003-08-18 16:02 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Insert performance
2003-08-18 16:57 UTC Josh Berkus <josh@agliodbs.com>
` Re: Insert performance
2003-08-18 22:16 UTC Hannu Krosing <hannu@tm.ee>
` Re: Insert performance
2003-08-19 06:28 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Insert performance
2003-08-19 06:33 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Insert performance
2007-02-27 17:10 UTC hatman <joel.winteregg@gmail.com>
` Re: Insert performance
2007-03-06 07:34 UTC Richard Huxton <dev@archonet.com>
` Re: Insert performance
2007-03-06 07:53 UTC joël Winteregg <joel.winteregg@gmail.com>
` Re: Insert performance
2007-03-06 08:08 UTC Richard Huxton <dev@archonet.com>
` Re: Insert performance
2007-03-06 09:19 UTC joël Winteregg <joel.winteregg@gmail.com>
` Re: Insert performance
2007-03-06 09:43 UTC Richard Huxton <dev@archonet.com>
` Re: Insert performance
2007-03-06 12:23 UTC Andreas Kostyrka <andreas@kostyrka.org>
` Re: Insert performance
2007-03-06 12:24 UTC Richard Huxton <dev@archonet.com>
` Re: Insert performance
2007-03-06 12:49 UTC Andreas Kostyrka <andreas@kostyrka.org>
` Re: Insert performance
2007-03-06 15:38 UTC hatman <joel.winteregg@gmail.com>
` Re: Insert performance
2007-03-06 15:46 UTC hatman <joel.winteregg@gmail.com>
` Re: Insert performance
2007-03-06 15:55 UTC Carlos Moreno <moreno_pg@mochima.com>
` Re: Insert performance
2007-03-06 16:02 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Insert performance
2007-03-06 17:54 UTC Carlos Moreno <moreno_pg@mochima.com>
` insert performance
2016-01-10 05:57 UTC Jinhua Luo <luajit.io@gmail.com>
` Re: insert performance
2016-01-10 21:05 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: insert performance
2016-01-11 19:20 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: insert performance
2016-01-13 10:03 UTC Jinhua Luo <luajit.io@gmail.com>
` Re: insert performance
2016-01-13 16:41 UTC Jinhua Luo <luajit.io@gmail.com>
` Re: insert performance
2016-01-19 04:50 UTC Jinhua Luo <luajit.io@gmail.com>
` Re: insert performance
2016-01-22 05:54 UTC Jinhua Luo <luajit.io@gmail.com>
` Re: insert performance
2016-01-24 23:24 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[32+ messages in thread]
High Planning Time
2016-01-22 00:30 UTC Phil S <pjsanders@gmail.com>
` Re: High Planning Time
2016-01-22 07:59 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: High Planning Time
2016-01-22 14:11 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: High Planning Time
2016-01-22 14:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Query order of magnitude slower with slightly different where clause
2016-01-17 21:41 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Query order of magnitude slower with slightly different where clause
2016-01-17 22:42 UTC David Rowley <david.rowley@2ndquadrant.com>
[2+ messages in thread]
Queries getting canceled inside a proc that seems to slow down randomly
2015-11-11 17:57 UTC Skarsol <skarsol@gmail.com>
` Re: Queries getting canceled inside a proc that seems to slow down randomly
2015-11-13 21:50 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Queries getting canceled inside a proc that seems to slow down randomly
2016-01-11 19:32 UTC Skarsol <skarsol@gmail.com>
` Re: Queries getting canceled inside a proc that seems to slow down randomly
2016-01-11 19:39 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Queries getting canceled inside a proc that seems to slow down randomly
2016-01-11 19:41 UTC Skarsol <skarsol@gmail.com>
[5+ messages in thread]
How we made Postgres upserts 2-3* quicker than MongoDB
2016-01-08 16:37 UTC Mark Zealey <mark@allaroundtheworld.fr>
` Re: How we made Postgres upserts 2-3* quicker than MongoDB
2016-01-08 17:07 UTC Nicolas Paris <niparisco@gmail.com>
` Re: How we made Postgres upserts 2-3* quicker than MongoDB
2016-01-08 17:16 UTC Mark Zealey <mark@allaroundtheworld.fr>
` Re: How we made Postgres upserts 2-3* quicker than MongoDB
2016-01-08 17:43 UTC Scott Marlowe <scott.marlowe@gmail.com>
[4+ messages in thread]
Queries intermittently slow
2016-01-06 14:58 UTC Scott Rankin <srankin@motus.com>
` Re: Queries intermittently slow
2016-01-06 15:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries intermittently slow
2016-01-06 15:30 UTC Scott Rankin <srankin@motus.com>
` Re: Queries intermittently slow
2016-01-06 15:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries intermittently slow
2016-01-06 15:56 UTC Scott Rankin <srankin@motus.com>
` Re: Queries intermittently slow
2016-01-06 16:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries intermittently slow
2016-01-06 16:28 UTC Scott Rankin <srankin@motus.com>
` Re: Queries intermittently slow
2016-01-06 16:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries intermittently slow
2016-01-06 18:01 UTC Scott Rankin <srankin@motus.com>
` Re: Queries intermittently slow
2016-01-07 04:14 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Queries intermittently slow
2016-01-07 15:03 UTC Scott Rankin <srankin@motus.com>
` Re: Queries intermittently slow
2016-01-07 15:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries intermittently slow
2016-01-07 15:43 UTC Scott Rankin <srankin@motus.com>
` Re: Queries intermittently slow
2016-01-07 17:51 UTC Scott Rankin <srankin@motus.com>
` Re: Queries intermittently slow
2016-01-07 18:07 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Queries intermittently slow
2016-01-07 18:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries intermittently slow
2016-01-07 19:47 UTC Andres Freund <andres@anarazel.de>
` Re: Queries intermittently slow
2016-01-07 21:04 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[18+ messages in thread]
Slow Query Help
2013-02-05 03:45 UTC Will Platnick <wplatnick@gmail.com>
` Re: Slow Query Help
2013-02-05 13:58 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Slow Query Help
2013-02-06 08:51 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Slow Query Help
2013-02-06 13:17 UTC Will Platnick <wplatnick@gmail.com>
` Re: Slow Query Help
2013-02-06 16:22 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Slow Query Help
2013-02-06 16:24 UTC Will Platnick <wplatnick@gmail.com>
` Re: Slow Query Help
2013-02-06 16:27 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Slow query help
2016-01-07 04:17 UTC Almir de Oliveira Duarte Junior <almirjr@adj.com.br>
` Re: Slow query help
2016-01-07 18:55 UTC Rafael Bernard Rodrigues Araujo <rafael.araujo@endel.com.br>
` Re: Slow query help
2016-01-07 19:15 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: Slow query help
2016-01-07 19:30 UTC Almir de Oliveira Duarte Junior <almirjr@adj.com.br>
[11+ messages in thread]
Materialized view performance problems
2016-01-06 08:08 UTC Tom McLoughlin <tom@dynamiccreative.com>
` Re: Materialized view performance problems
2016-01-06 11:40 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Materialized view performance problems
2016-01-06 13:27 UTC Tom McLoughlin <tom@dynamiccreative.com>
` Re: Materialized view performance problems
2016-01-06 17:23 UTC Andreas Kretschmer <akretschmer@spamfence.net>
[4+ messages in thread]
Proposal for unlogged tables
2016-01-04 09:59 UTC Mark Zealey <mark@allaroundtheworld.fr>
` Re: Proposal for unlogged tables
2016-01-04 14:27 UTC Yves Dorfsman <yves@zioup.com>
` Re: Proposal for unlogged tables
2016-01-04 14:38 UTC Mark Zealey <mark@allaroundtheworld.fr>
` Re: Proposal for unlogged tables
2016-01-04 16:12 UTC Andres Freund <andres@anarazel.de>
` Re: Proposal for unlogged tables
2016-01-04 17:12 UTC Mark Zealey <mark@allaroundtheworld.fr>
` Re: Proposal for unlogged tables
2016-01-04 17:16 UTC Andres Freund <andres@anarazel.de>
[6+ messages in thread]
Plan differences
2015-12-31 10:12 UTC Anton Melser <melser.anton@gmail.com>
` Re: Plan differences
2015-12-31 10:44 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Plan differences
2015-12-31 14:49 UTC Anton Melser <melser.anton@gmail.com>
` Re: Plan differences
2015-12-31 15:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Plan differences
2015-12-31 16:29 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Plan differences
2015-12-31 17:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Plan differences
2015-12-31 20:10 UTC Anton Melser <melser.anton@gmail.com>
` Re: Plan differences
2016-01-01 17:13 UTC Anton Melser <melser.anton@gmail.com>
` Re: Plan differences
2016-01-04 09:04 UTC Adam Pearson <Adam.Pearson@4finance.com>
` Re: Plan differences
2016-01-04 13:30 UTC Anton Melser <melser.anton@gmail.com>
[10+ messages in thread]
Connections "Startup"
2015-12-22 07:59 UTC Artem Tomyuk <admin@leboutique.com>
` Re: Connections "Startup"
2015-12-22 08:09 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Connections "Startup"
2015-12-22 11:36 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Connections "Startup"
2015-12-23 02:32 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: [PERFORM] Connections "Startup"
2015-12-23 03:52 UTC Om Prakash Jaiswal <op12om@yahoo.co.in>
` Re: [ADMIN] Connections "Startup"
2015-12-23 04:50 UTC Pavel Stehule <pavel.stehule@gmail.com>
[6+ messages in thread]
Can't explain db size
2015-12-15 09:52 UTC Matteo Grolla <matteo.grolla@gmail.com>
` Re: Can't explain db size
2015-12-15 10:07 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Can't explain db size
2015-12-15 11:11 UTC Matteo Grolla <matteo.grolla@gmail.com>
` Re: Can't explain db size
2015-12-17 15:12 UTC Matteo Grolla <matteo.grolla@gmail.com>
` Re: Can't explain db size
2015-12-17 17:03 UTC Matteo Grolla <matteo.grolla@gmail.com>
` Re: Can't explain db size
2015-12-20 23:08 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[6+ messages in thread]
Estimation row error
2015-12-11 08:53 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-11 11:35 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-15 08:05 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-15 09:25 UTC Gunnar "Nick" Bluth <gunnar.bluth.extern@elster.de>
` Re: Estimation row error
2015-12-15 09:49 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Estimation row error
2015-12-15 10:21 UTC Gunnar "Nick" Bluth <gunnar.bluth.extern@elster.de>
` Re: Estimation row error
2015-12-17 09:10 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-17 09:14 UTC Matteo Grolla <matteo.grolla@gmail.com>
` Re: Estimation row error
2015-12-17 10:37 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-17 10:58 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-18 15:21 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-18 15:33 UTC Pavel Stehule <pavel.stehule@gmail.com>
[12+ messages in thread]
Selectivity for lopsided foreign key columns
2015-12-17 10:11 UTC Mikkel Lauritsen <renard@tala.dk>
` Re: Selectivity for lopsided foreign key columns
2015-12-17 15:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Selectivity for lopsided foreign key columns
2015-12-17 19:14 UTC Mikkel Lauritsen <renard@tala.dk>
[3+ messages in thread]
Terrible plan choice for view with distinct on clause
2015-12-17 15:44 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Terrible plan choice for view with distinct on clause
2015-12-17 17:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Terrible plan choice for view with distinct on clause
2015-12-17 18:08 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Terrible plan choice for view with distinct on clause
2015-12-17 18:51 UTC Adam Brusselback <adambrusselback@gmail.com>
[4+ messages in thread]
Performance difference between Slon master and slave
2015-12-14 17:16 UTC Matthew Lunnon <mlunnon@rwa-net.co.uk>
` Re: Performance difference between Slon master and slave
2015-12-14 17:49 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Performance difference between Slon master and slave
2015-12-14 21:43 UTC Mattthew Lunnon <mlunnon@rwa-net.co.uk>
[3+ messages in thread]
Getting an optimal plan on the first execution of a pl/pgsql function
2015-12-14 18:53 UTC Pedro França <pedro.franca@golsat.com.br>
` Re: Getting an optimal plan on the first execution of a pl/pgsql function
2015-12-14 19:21 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Getting an optimal plan on the first execution of a pl/pgsql function
2015-12-14 20:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Getting an optimal plan on the first execution of a pl/pgsql function
2015-12-14 20:50 UTC Pedro França <pedro.franca@golsat.com.br>
[4+ messages in thread]
Advise needed for a join query with a where conditional
2015-12-11 04:38 UTC ankur_adwyze <ankur@adwyze.com>
` Re: Advise needed for a join query with a where conditional
2015-12-11 05:04 UTC ankur_adwyze <ankur@adwyze.com>
` Re: Advise needed for a join query with a where conditional
2015-12-11 23:50 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Advise needed for a join query with a where conditional
2015-12-12 16:58 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
partitioned table set and indexes
2015-12-11 19:01 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: partitioned table set and indexes
2015-12-11 19:44 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: partitioned table set and indexes
2015-12-11 20:40 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: partitioned table set and indexes
2015-12-11 21:27 UTC Kevin Grittner <kgrittn@gmail.com>
` Re: partitioned table set and indexes
2015-12-11 21:44 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: partitioned table set and indexes
2015-12-11 22:09 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: partitioned table set and indexes
2015-12-12 00:20 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: partitioned table set and indexes
2015-12-12 00:55 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: partitioned table set and indexes
2015-12-12 03:13 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
[9+ 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