pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedThe same query - much different runtimes
2014-04-07 10:25 UTC Johann Spies <johann.spies@gmail.com>
` Re: The same query - much different runtimes
2014-04-07 10:58 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
[2+ messages in thread]
Slow Count-Distinct Query
2014-03-30 19:45 UTC Christopher Jackson <crjackso@gmail.com>
` Re: Slow Count-Distinct Query
2014-03-31 13:17 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Slow Count-Distinct Query
2014-03-31 14:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow Count-Distinct Query
2014-03-31 15:53 UTC Christopher Jackson <crjackso@gmail.com>
` Re: Slow Count-Distinct Query
2014-04-02 00:34 UTC bricklen <bricklen@gmail.com>
` Re: Slow Count-Distinct Query
2014-04-02 04:22 UTC Christopher Jackson <crjackso@gmail.com>
` Re: Slow Count-Distinct Query
2014-04-02 04:48 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: Slow Count-Distinct Query
2014-04-02 04:54 UTC Christopher Jackson <crjackso@gmail.com>
` Fwd: Slow Count-Distinct Query
2014-04-04 09:31 UTC Varadharajan Mukundan <srinathsmn@gmail.com>
` Re: Fwd: Slow Count-Distinct Query
2014-04-04 17:59 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Fwd: Slow Count-Distinct Query
2014-04-05 01:13 UTC Varadharajan Mukundan <srinathsmn@gmail.com>
` Slow Count-Distinct Query
2014-04-06 17:26 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Slow Count-Distinct Query
2014-04-07 02:34 UTC Varadharajan Mukundan <srinathsmn@gmail.com>
[13+ messages in thread]
Sudden crazy high CPU usage
2014-03-31 10:25 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
` Re: Sudden crazy high CPU usage
2014-03-31 13:47 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Sudden crazy high CPU usage
2014-03-31 14:24 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
` Re: Sudden crazy high CPU usage
2014-03-31 14:36 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Sudden crazy high CPU usage
2014-03-31 14:50 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Sudden crazy high CPU usage
2014-03-31 17:16 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
` Re: Sudden crazy high CPU usage
2014-03-31 17:21 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
` Re: Sudden crazy high CPU usage
2014-03-31 17:36 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: Sudden crazy high CPU usage
2014-03-31 20:01 UTC Will Platnick <wplatnick@gmail.com>
` Re: Sudden crazy high CPU usage
2014-04-01 21:50 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
` Re: Sudden crazy high CPU usage
2014-04-01 22:16 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Sudden crazy high CPU usage
2014-04-03 00:00 UTC Michael Paquier <michael.paquier@gmail.com>
[12+ messages in thread]
Connection pooling - Number of connections
2014-03-21 14:49 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Connection pooling - Number of connections
2014-03-21 15:49 UTC David Johnston <polobo@yahoo.com>
` Re: Connection pooling - Number of connections
2014-03-21 16:05 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Connection pooling - Number of connections
2014-03-21 16:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Connection pooling - Number of connections
2014-03-21 17:51 UTC Sethu Prasad <sethuprasad.in@gmail.com>
` Re: Connection pooling - Number of connections
2014-03-21 18:36 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Connection pooling - Number of connections
2014-03-21 18:38 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Connection pooling - Number of connections
2014-03-21 18:41 UTC David Johnston <polobo@yahoo.com>
` Re: Connection pooling - Number of connections
2014-03-21 19:04 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Connection pooling - Number of connections
2014-03-22 11:26 UTC Brett Wooldridge <brett.wooldridge@gmail.com>
` Connection pooling - Number of connections
2014-03-24 13:27 UTC Brett Wooldridge <brett.wooldridge@gmail.com>
` Re: Connection pooling - Number of connections
2014-03-24 20:24 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Connection pooling - Number of connections
2014-03-25 00:23 UTC Brett Wooldridge <brett.wooldridge@gmail.com>
` Re: Connection pooling - Number of connections
2014-03-25 01:42 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Connection pooling - Number of connections
2014-03-25 02:45 UTC Brett Wooldridge <brett.wooldridge@gmail.com>
` Re: Connection pooling - Number of connections
2014-03-27 00:35 UTC Josh Berkus <josh@agliodbs.com>
` Re: Connection pooling - Number of connections
2014-03-29 21:20 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Connection pooling - Number of connections
2014-03-30 03:41 UTC Brett Wooldridge <brett.wooldridge@gmail.com>
[18+ messages in thread]
Partitions and prepared statements?
2014-03-27 20:42 UTC Dave Johansen <davejohansen@gmail.com>
RE : Stalls on PGSemaphoreLock
2014-03-25 17:45 UTC Pavy Philippe <Philippe.Pavy@worldline.com>
pg_dump vs pg_basebackup
2014-03-25 04:45 UTC gianfranco caca <limpcaca@yahoo.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 07:11 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 07:19 UTC gianfranco caca <limpcaca@yahoo.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 07:33 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 07:39 UTC David Johnston <polobo@yahoo.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 12:05 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 14:56 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 15:10 UTC desmodemone <desmodemone@gmail.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 15:18 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 15:21 UTC Magnus Hagander <magnus@hagander.net>
` Re: pg_dump vs pg_basebackup
2014-03-25 15:22 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 15:29 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 15:37 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 15:40 UTC Magnus Hagander <magnus@hagander.net>
` Re: pg_dump vs pg_basebackup
2014-03-25 15:41 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 15:48 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: pg_dump vs pg_basebackup
2014-03-25 15:55 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: pg_dump vs pg_basebackup
2014-03-25 16:12 UTC Alan Hodgson <ahodgson@simkin.ca>
` Re: pg_dump vs pg_basebackup
2014-03-25 16:46 UTC Claudio Freire <klaussfreire@gmail.com>
[19+ messages in thread]
slow join not using index properly
2014-03-20 23:56 UTC Stefan Amshey <sramshey@gmail.com>
` Re: slow join not using index properly
2014-03-21 06:02 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: slow join not using index properly
2014-03-21 08:17 UTC Vincent <vinny@xs4all.nl>
` Re: slow join not using index properly
2014-03-24 18:40 UTC Stefan Amshey <sramshey@gmail.com>
` Re: slow join not using index properly
2014-03-25 07:05 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
[5+ messages in thread]
Suboptimal query plan when using expensive BCRYPT functions
2014-03-22 00:59 UTC Erik van Zijst <erik.van.zijst@gmail.com>
` Re: Suboptimal query plan when using expensive BCRYPT functions
2014-03-22 20:51 UTC bricklen <bricklen@gmail.com>
` Re: Suboptimal query plan when using expensive BCRYPT functions
2014-03-22 22:27 UTC Erik van Zijst <erik.van.zijst@gmail.com>
` Re: Suboptimal query plan when using expensive BCRYPT functions
2014-03-22 22:56 UTC bricklen <bricklen@gmail.com>
` Re: Suboptimal query plan when using expensive BCRYPT functions
2014-03-23 03:37 UTC Erik van Zijst <erik.van.zijst@gmail.com>
` Re: Suboptimal query plan when using expensive BCRYPT functions
2014-03-23 03:56 UTC bricklen <bricklen@gmail.com>
` Re: Suboptimal query plan when using expensive BCRYPT functions
2014-03-23 06:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Suboptimal query plan when using expensive BCRYPT functions
2014-03-23 18:30 UTC Erik van Zijst <erik.van.zijst@gmail.com>
` Re: Suboptimal query plan when using expensive BCRYPT functions
2014-03-24 07:08 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Suboptimal query plan when using expensive BCRYPT functions
2014-03-24 17:37 UTC Erik van Zijst <erik.van.zijst@gmail.com>
[10+ messages in thread]
semaphore waits and performance stall
2014-03-24 14:37 UTC Matthew Spilich <mspilich@tripadvisor.com>
Query taking long time
2014-02-26 15:41 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-02-27 10:31 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-03-03 10:17 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-03-03 17:17 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: Query taking long time
2014-03-03 23:28 UTC Venkata Balaji Nagothi <vbnpgc@gmail.com>
` Re: Query taking long time
2014-03-04 10:10 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-03-04 11:23 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-03-04 23:35 UTC Venkata Balaji Nagothi <vbnpgc@gmail.com>
` Re: Query taking long time
2014-03-06 10:47 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-03-06 13:11 UTC desmodemone <desmodemone@gmail.com>
` Re: Query taking long time
2014-03-06 14:45 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-03-07 09:39 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Query taking long time
2014-03-07 09:46 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-03-07 10:03 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Query taking long time
2014-03-07 10:18 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-03-10 14:45 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Query taking long time
2014-03-10 16:30 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-03-10 19:49 UTC Venkata Balaji Nagothi <vbnpgc@gmail.com>
` Re: Query taking long time
2014-03-10 20:22 UTC desmodemone <desmodemone@gmail.com>
` Re: Query taking long time
2014-03-11 15:56 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-03-11 23:12 UTC Evgeny Shishkin <itparanoia@gmail.com>
` Re: Query taking long time
2014-03-19 11:09 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-03-19 23:30 UTC Venkata Balaji Nagothi <vbnpgc@gmail.com>
` Re: Query taking long time
2014-03-20 10:17 UTC acanada <acanada@cnio.es>
` Re: Query taking long time
2014-03-23 06:10 UTC Venkata Balaji Nagothi <vbnpgc@gmail.com>
[25+ messages in thread]
Performance of UNION vs IN
2014-03-20 16:57 UTC Jean-Max Reymond <jmreymond@free.fr>
` Re: Performance of UNION vs IN
2014-03-20 17:13 UTC Torsten Förtsch <torsten.foertsch@gmx.net>
` Re: Performance of UNION vs IN
2014-03-21 05:33 UTC Jean-Max Reymond <jmreymond@free.fr>
[3+ messages in thread]
long lasting select, no io nor cpu usage ?
2014-03-20 13:51 UTC Franck Routier <franck.routier@axege.com>
` Re: long lasting select, no io nor cpu usage ?
2014-03-20 13:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: long lasting select, no io nor cpu usage ?
2014-03-20 14:07 UTC Franck Routier <franck.routier@axege.com>
` Re: long lasting select, no io nor cpu usage ?
2014-03-20 14:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: long lasting select, no io nor cpu usage ?
2014-03-20 16:27 UTC Franck Routier <franck.routier@axege.com>
[5+ messages in thread]
slave wal is ahead of master
2014-03-19 17:10 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: slave wal is ahead of master
2014-03-19 18:11 UTC Sethu Prasad <sethuprasad.in@gmail.com>
` Re: slave wal is ahead of master
2014-03-19 20:01 UTC Evgeny Shishkin <itparanoia@gmail.com>
[3+ messages in thread]
question about partial index
2014-03-18 21:26 UTC Yu Zhao <yzhao81@gmail.com>
` Re: question about partial index
2014-03-18 21:51 UTC Szymon Guz <mabewlun@gmail.com>
[2+ messages in thread]
Help me understand why my subselect is an order of magnitude faster than my nested joins
2014-03-03 18:24 UTC Eli Naeher <enaeher@gmail.com>
` Re: Help me understand why my subselect is an order of magnitude faster than my nested joins
2014-03-18 21:20 UTC Vincent <vinny@xs4all.nl>
[2+ messages in thread]
Very slow query in PostgreSQL 9.3.3
2014-03-13 19:26 UTC fburgess@radiantblue.com
` Re: [BUGS] Very slow query in PostgreSQL 9.3.3
2014-03-13 19:36 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: [BUGS] Very slow query in PostgreSQL 9.3.3
2014-03-13 22:12 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: [PERFORM] Very slow query in PostgreSQL 9.3.3
2014-03-14 02:19 UTC Ian Lawrence Barwick <barwick@gmail.com>
[4+ messages in thread]
How can I get the query planner to use a bitmap index scap instead of an index scan ?
2014-03-08 02:46 UTC Mohan Krishnan <mohangk@gmail.com>
` Re: How can I get the query planner to use a bitmap index scap instead of an index scan ?
2014-03-09 21:46 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: How can I get the query planner to use a bitmap index scap instead of an index scan ?
2014-03-10 08:14 UTC Mohan Krishnan <mohangk@gmail.com>
[3+ messages in thread]
Optimal settings for RAID controller - optimized for writes
2014-02-16 17:49 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
` Optimal settings for RAID controller - optimized for writes
2014-02-17 15:03 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-17 15:29 UTC DFE <mimmopasticcio@gmail.com>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-17 15:40 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-17 15:54 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-18 01:23 UTC KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-18 04:04 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-18 14:25 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-18 20:41 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-19 02:45 UTC KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-19 15:13 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-19 18:09 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-20 00:13 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-20 00:18 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-20 00:26 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-20 01:10 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-20 01:47 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-20 08:29 UTC KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
` Re: Optimal settings for RAID controller - optimized for writes
2014-02-20 23:58 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Optimal settings for RAID controller - optimized for writes
2014-03-06 00:34 UTC Merlin Moncure <mmoncure@gmail.com>
[20+ messages in thread]
Help with optimizing a query over hierarchical data
2014-02-28 20:01 UTC Damon Snyder <damon@huddler-inc.com>
` Re: Help with optimizing a query over hierarchical data
2014-03-02 01:02 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Help with optimizing a query over hierarchical data
2014-03-03 17:55 UTC Damon Snyder <damon@huddler-inc.com>
` Re: Help with optimizing a query over hierarchical data
2014-03-03 21:52 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Help with optimizing a query over hierarchical data
2014-03-04 01:12 UTC Damon Snyder <damon@huddler-inc.com>
` Re: Help with optimizing a query over hierarchical data
2014-03-04 04:20 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Help with optimizing a query over hierarchical data
2014-03-04 17:06 UTC Damon Snyder <damon@huddler-inc.com>
[7+ messages in thread]
Subselect an order of magnitude faster than nested joins
2014-03-03 18:55 UTC Eli Naeher <enaeher@gmail.com>
Inefficient filter order in query plan
2014-02-27 16:57 UTC Tom Coogan <nocera@gmail.com>
` Re: Inefficient filter order in query plan
2014-02-27 17:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Inefficient filter order in query plan
2014-02-27 18:24 UTC Stephen Frost <sfrost@snowman.net>
` Re: Inefficient filter order in query plan
2014-02-27 19:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Inefficient filter order in query plan
2014-02-27 20:34 UTC Tom Coogan <nocera@gmail.com>
` Re: Inefficient filter order in query plan
2014-02-27 20:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Inefficient filter order in query plan
2014-02-28 18:29 UTC Tom Coogan <nocera@gmail.com>
[7+ messages in thread]
not using my GIN index in JOIN expression
2014-02-27 14:06 UTC Jean-Max Reymond <jmreymond@free.fr>
` Re: not using my GIN index in JOIN expression
2014-02-27 14:19 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: not using my GIN index in JOIN expression
2014-02-27 14:46 UTC Jean-Max Reymond <jmreymond@free.fr>
[3+ messages in thread]
Postgresql tunning-- help needed
2014-02-21 12:22 UTC Ashutosh Durugkar <dba.ashutosh@gmail.com>
` Re: Postgresql tunning-- help needed
2014-02-26 23:59 UTC Tomas Vondra <tv@fuzzy.cz>
[2+ messages in thread]
9.2.4 specified item offset is too large, now what?
2014-02-26 15:17 UTC Tory M Blue <tmblue@gmail.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