pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedautovacuum disk IO
2016-03-02 15:25 UTC Artem Tomyuk <admin@leboutique.com>
` Re: [PERFORM] autovacuum disk IO
2016-03-02 15:31 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: autovacuum disk IO
2016-03-02 15:45 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: autovacuum disk IO
2016-03-02 15:49 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: [SPAM] Re: autovacuum disk IO
2016-03-02 16:11 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: [SPAM] Re: autovacuum disk IO
2016-03-02 16:21 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: [SPAM] Re: autovacuum disk IO
2016-03-02 18:40 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: [SPAM] Re: autovacuum disk IO
2016-03-02 18:54 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: [ADMIN] autovacuum disk IO
2016-03-04 17:28 UTC Jehan-Guillaume de Rorthais <ioguix@free.fr>
[9+ messages in thread]
Filesystem and Disk Partitioning for New Server Setup
2016-02-24 04:28 UTC dstibrany <dstibrany@gmail.com>
` Fwd: Filesystem and Disk Partitioning for New Server Setup
2016-02-24 11:08 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Filesystem and Disk Partitioning for New Server Setup
2016-02-24 14:25 UTC Dave Stibrany <dstibrany@gmail.com>
` Re: Filesystem and Disk Partitioning for New Server Setup
2016-02-24 15:05 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Filesystem and Disk Partitioning for New Server Setup
2016-02-24 15:44 UTC Wes Vaske (wvaske) <wvaske@micron.com>
[5+ messages in thread]
Cloud versus buying my own iron
2016-02-24 05:06 UTC Craig James <cjames@emolecules.com>
` Re: Cloud versus buying my own iron
2016-02-24 09:01 UTC Gunnar "Nick" Bluth <gunnar.bluth.extern@elster.de>
` Fwd: Cloud versus buying my own iron
2016-02-24 11:08 UTC Rick Otten <rottenwindfish@gmail.com>
[3+ messages in thread]
(no subject)
2005-05-03 15:55 UTC Steven Rosenstein <srosenst@us.ibm.com>
` Re:
2005-05-03 16:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re:
2005-05-04 11:08 UTC Mike Rylander <mrylander@gmail.com>
` Why Postgres use a little memory on Windows.
2016-02-20 16:46 UTC tuanhoanganh <hatuan05@gmail.com>
` Re: [GENERAL] Why Postgres use a little memory on Windows.
2016-02-20 18:13 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [GENERAL] Why Postgres use a little memory on Windows.
2016-02-20 18:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why Postgres use a little memory on Windows.
2016-02-20 18:39 UTC Francisco Olarte <folarte@peoplecall.com>
` Re: [GENERAL] Why Postgres use a little memory on Windows.
2016-02-20 18:58 UTC Francisco Olarte <folarte@peoplecall.com>
` Re: [GENERAL] Why Postgres use a little memory on Windows.
2016-02-20 21:49 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: [PERFORM] Why Postgres use a little memory on Windows.
2016-02-21 02:21 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Why Postgres use a little memory on Windows.
2016-02-21 16:45 UTC tuanhoanganh <hatuan05@gmail.com>
[11+ messages in thread]
Primary key index suddenly became very slow
2016-02-08 09:45 UTC Gustav Karlsson <gustav.karlsson@bekk.no>
` Re: Primary key index suddenly became very slow
2016-02-08 10:04 UTC Gustav Karlsson <gustav.karlsson@bekk.no>
` Re: Primary key index suddenly became very slow
2016-02-16 12:52 UTC jaime soler <jaime.soler@gmail.com>
` Re: Primary key index suddenly became very slow
2016-02-16 20:06 UTC Venkata Balaji N <nag1010@gmail.com>
[4+ messages in thread]
Running lots of inserts from selects on 9.4.5
2016-02-10 00:09 UTC Dan Langille <dan@langille.org>
` Re: Running lots of inserts from selects on 9.4.5
2016-02-10 07:47 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Running lots of inserts from selects on 9.4.5
2016-02-10 10:13 UTC Dan Langille <dan@langille.org>
` Re: Running lots of inserts from selects on 9.4.5
2016-02-11 21:41 UTC Dan Langille <dan@langille.org>
` Re: Running lots of inserts from selects on 9.4.5
2016-02-13 15:43 UTC Dan Langille <dan@langille.org>
` Re: Running lots of inserts from selects on 9.4.5
2016-02-13 15:45 UTC Dan Langille <dan@langille.org>
[6+ messages in thread]
bad COPY performance with NOTIFY in a trigger
2016-02-04 21:12 UTC Filip Rembiałkowski <filip.rembialkowski@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-04 22:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-05 08:40 UTC Harald Fuchs <hari.fuchs@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-05 12:45 UTC Filip Rembiałkowski <filip.rembialkowski@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-05 15:33 UTC Filip Rembiałkowski <filip.rembialkowski@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-05 19:52 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-06 12:03 UTC Filip Rembiałkowski <filip.rembialkowski@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-08 14:35 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: bad COPY performance with NOTIFY in a trigger
2016-02-08 22:58 UTC Merlin Moncure <mmoncure@gmail.com>
[9+ messages in thread]
gin performance issue.
2016-02-05 11:28 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: gin performance issue.
2016-02-05 15:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: gin performance issue.
2016-02-08 10:21 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: gin performance issue.
2016-02-08 19:16 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
Bitmap and-ing between btree and gin?
2016-02-04 11:15 UTC Jordi <jmaillists@promani.be>
` Re: Bitmap and-ing between btree and gin?
2016-02-04 16:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bitmap and-ing between btree and gin?
2016-02-04 17:19 UTC Jordi <jmaillists@promani.be>
` Re: Bitmap and-ing between btree and gin?
2016-02-08 18:13 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
PostgreSQL seems to create inefficient plans in simple conditional joins
2016-01-30 12:30 UTC Hedayat Vatankhah <hedayat.fwd@gmail.com>
` Re: PostgreSQL seems to create inefficient plans in simple conditional joins
2016-01-30 15:57 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: PostgreSQL seems to create inefficient plans in simple conditional joins
2016-01-30 17:14 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: PostgreSQL seems to create inefficient plans in simple conditional joins
2016-01-30 17:31 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: PostgreSQL seems to create inefficient plans in simple conditional joins
2016-01-30 18:52 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: PostgreSQL seems to create inefficient plans in simple conditional joins
2016-01-30 21:50 UTC Hedayat Vatankhah <hedayat.fwd@gmail.com>
` Re: PostgreSQL seems to create inefficient plans in simple conditional joins
2016-02-08 08:50 UTC Hedayat Vatankhah <hedayat.fwd@gmail.com>
[7+ messages in thread]
View containing a recursive function
2016-02-01 07:23 UTC Mathieu De Zutter <mathieu@dezutter.org>
` Re: View containing a recursive function
2016-02-01 09:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: View containing a recursive function
2016-02-05 15:43 UTC Mathieu De Zutter <mathieu@dezutter.org>
[3+ messages in thread]
Understanding 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]
[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