pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedProcessing of subqueries in union
2013-03-01 06:32 UTC Markus Hervén <markus.herven@gmail.com>
SELECT is slow on smaller table?
2013-02-28 15:11 UTC Ao Jianwang <aojw2008@gmail.com>
` Re: SELECT is slow on smaller table?
2013-02-28 15:19 UTC Julien Cigar <jcigar@ulb.ac.be>
` Re: SELECT is slow on smaller table?
2013-03-01 00:30 UTC Ao Jianwang <aojw2008@gmail.com>
[3+ messages in thread]
Wrong actual number of rows in the Query Plan
2013-02-21 07:24 UTC Vahe Evoyan <vahe.evoyan@gmail.com>
` Re: Wrong actual number of rows in the Query Plan
2013-02-28 17:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Estimation question...
2013-02-26 19:35 UTC Matt Daw <matt@shotgunsoftware.com>
` Re: Estimation question...
2013-02-27 17:08 UTC Matt Daw <matt@shotgunsoftware.com>
` Re: Estimation question...
2013-02-28 16:31 UTC Matt Daw <matt@shotgunsoftware.com>
[3+ messages in thread]
Server stalls, all CPU 100% system time
2013-02-24 14:08 UTC Andre <pg@darix.de>
` Re: Server stalls, all CPU 100% system time
2013-02-24 14:13 UTC Bèrto ëd Sèra <berto.d.sera@gmail.com>
` Re: Server stalls, all CPU 100% system time
2013-02-24 14:39 UTC Andre <pg@darix.de>
` Re: Server stalls, all CPU 100% system time
2013-02-24 14:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Server stalls, all CPU 100% system time
2013-02-24 16:43 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Server stalls, all CPU 100% system time
2013-02-26 12:53 UTC Andre <pg@darix.de>
` Re: Server stalls, all CPU 100% system time
2013-02-26 23:29 UTC Josh Berkus <josh@agliodbs.com>
` Re: Server stalls, all CPU 100% system time
2013-02-27 01:02 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Server stalls, all CPU 100% system time
2013-02-27 10:52 UTC Andre <pg@darix.de>
` Re: Server stalls, all CPU 100% system time
2013-02-27 23:07 UTC Josh Berkus <josh@agliodbs.com>
[10+ messages in thread]
seqscan on UNION'ed views
2013-02-27 10:03 UTC Dmitry Karasik <dmitry@karasik.eu.org>
` Re: seqscan on UNION'ed views
2013-02-27 14:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-12 17:25 UTC Dan Kogan <dan@iqtell.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-12 19:59 UTC Dan Kogan <dan@iqtell.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-13 01:28 UTC Dan Kogan <dan@iqtell.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-13 19:24 UTC Josh Berkus <josh@agliodbs.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-14 00:25 UTC Josh Berkus <josh@agliodbs.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-14 01:30 UTC Dan Kogan <dan@iqtell.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-14 14:07 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-14 17:27 UTC Dan Kogan <dan@iqtell.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-14 18:38 UTC Josh Berkus <josh@agliodbs.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-14 20:41 UTC Dan Kogan <dan@iqtell.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-14 23:57 UTC Josh Berkus <josh@agliodbs.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-15 04:32 UTC Dan Kogan <dan@iqtell.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-15 04:47 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-15 18:26 UTC Josh Berkus <josh@agliodbs.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-15 18:52 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-19 00:19 UTC Josh Berkus <josh@agliodbs.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-19 00:39 UTC Josh Berkus <josh@agliodbs.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-19 00:46 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-19 00:51 UTC Josh Berkus <josh@agliodbs.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-19 03:41 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-19 04:28 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-19 17:51 UTC Josh Berkus <josh@agliodbs.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-19 23:17 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-19 23:24 UTC Josh Berkus <josh@agliodbs.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-19 23:37 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-20 03:15 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-20 22:44 UTC Josh Berkus <josh@agliodbs.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-21 01:15 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-21 03:14 UTC Josh Berkus <josh@agliodbs.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-21 11:24 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-25 22:30 UTC Jeff Frost <jeff@pgexperts.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-26 21:30 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: High CPU usage / load average after upgrading to Ubuntu 12.04
2013-02-26 21:46 UTC Scott Marlowe <scott.marlowe@gmail.com>
[33+ messages in thread]
Very slow update statement on 40mio rows
2013-02-15 14:30 UTC Florian Schröck <fschroeck@aycan.de>
` Re: Very slow update statement on 40mio rows
2013-02-15 14:59 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Very slow update statement on 40mio rows
2013-02-15 15:32 UTC Florian Schröck <fschroeck@aycan.de>
` Re: Very slow update statement on 40mio rows
2013-02-19 20:04 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Very slow update statement on 40mio rows
2013-02-26 08:01 UTC Florian Schröck <fschroeck@aycan.de>
[5+ messages in thread]
Avoiding Recheck Cond when using Select Distinct
2013-02-22 16:36 UTC jackrg <jack@groundbreakingsoftware.com>
` Re: Avoiding Recheck Cond when using Select Distinct
2013-02-22 17:19 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Avoiding Recheck Cond when using Select Distinct
2013-02-22 17:59 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: Avoiding Recheck Cond when using Select Distinct
2013-02-22 19:06 UTC Maciek Sakrejda <m.sakrejda@gmail.com>
` Re: Avoiding Recheck Cond when using Select Distinct
2013-02-23 23:53 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Avoiding Recheck Cond when using Select Distinct
2013-02-25 18:11 UTC Maciek Sakrejda <m.sakrejda@gmail.com>
` Re: Avoiding Recheck Cond when using Select Distinct
2013-02-25 18:48 UTC Jeff Janes <jeff.janes@gmail.com>
[7+ messages in thread]
BUG: endless lseek(.., SEEK_END) from select queries on x64 builds
2013-02-22 08:25 UTC Markus Schulz <msc@antzsystem.de>
` Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds
2013-02-22 13:35 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds
2013-02-22 13:37 UTC Stephen Frost <sfrost@snowman.net>
` Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds
2013-02-22 18:10 UTC Markus Schulz <msc@antzsystem.de>
` Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds
2013-02-23 15:54 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds
2013-02-23 16:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
Bad query plan with high-cardinality column
2013-02-21 19:44 UTC Alexander Staubo <alex@bengler.no>
` Bad query plan with high-cardinality column
2013-02-22 18:22 UTC Alexander Staubo <alex@bengler.no>
` Re: Bad query plan with high-cardinality column
2013-02-22 20:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bad query plan with high-cardinality column
2013-02-22 20:47 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Bad query plan with high-cardinality column
2013-02-22 21:31 UTC Alexander Staubo <alex@bengler.no>
` Re: Bad query plan with high-cardinality column
2013-02-22 21:34 UTC Alexander Staubo <alex@bengler.no>
` Re: Bad query plan with high-cardinality column
2013-02-22 22:17 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Bad query plan with high-cardinality column
2013-02-23 10:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
[8+ messages in thread]
Using a window function in a view
2013-02-21 23:37 UTC Chris Hanks <christopher.m.hanks@gmail.com>
Speed of exist
2013-02-19 06:34 UTC Bastiaan Olij <bastiaan@basenlily.me>
` Re: Speed of exist
2013-02-19 07:31 UTC Andy <andy.gumbrecht@orprovision.com>
` Re: Speed of exist
2013-02-19 07:36 UTC Bastiaan Olij <bastiaan@basenlily.me>
` Re: Speed of exist
2013-02-19 07:39 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Speed of exist
2013-02-19 10:18 UTC Bastiaan Olij <bastiaan@basenlily.me>
[5+ messages in thread]
slow query plans caused by under-estimation of CTE cardinality
2013-02-18 16:45 UTC John Lumby <johnlumby@hotmail.com>
` Re: slow query plans caused by under-estimation of CTE cardinality
2013-02-18 20:40 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: slow query plans caused by under-estimation of CTE cardinality
2013-02-18 23:26 UTC John Lumby <johnlumby@hotmail.com>
` Re: slow query plans caused by under-estimation of CTE cardinality
2013-02-19 10:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Surprising no use of indexes - low performance
2013-02-14 15:35 UTC Nicolas Charles <nicolas.charles@normation.com>
` Re: Surprising no use of indexes - low performance
2013-02-14 18:25 UTC Ireneusz Pluta <ipluta@wp.pl>
` Re: Surprising no use of indexes - low performance
2013-02-14 19:27 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Surprising no use of indexes - low performance
2013-02-15 09:00 UTC Nicolas Charles <nicolas.charles@normation.com>
` Re: Surprising no use of indexes - low performance
2013-02-15 18:04 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Surprising no use of indexes - low performance
2013-02-15 21:27 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Surprising no use of indexes - low performance
2013-02-16 09:25 UTC Nicolas Charles <nicolas.charles@normation.com>
[7+ messages in thread]
temp tablespaces and SSDs, etc..
2013-02-08 20:52 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: temp tablespaces and SSDs, etc..
2013-02-16 00:32 UTC Bruce Momjian <bruce@momjian.us>
[2+ messages in thread]
Partition insert trigger using C language
2013-01-10 18:45 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-01-10 18:54 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Partition insert trigger using C language
2013-01-10 19:11 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-01-10 19:14 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Partition insert trigger using C language
2013-01-10 19:22 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Partition insert trigger using C language
2013-01-10 19:48 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-01-10 19:57 UTC Charles Gomes <charlesrg@outlook.com>
` Re: Partition insert trigger using C language
2013-01-11 10:19 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Partition insert trigger using C language
2013-01-11 10:36 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-01-11 10:57 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-01-11 11:02 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Partition insert trigger using C language
2013-01-11 11:55 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-02-11 15:24 UTC Ali Pouya <alipouya2@gmail.com>
` Re: Partition insert trigger using C language
2013-02-13 11:00 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-02-15 08:47 UTC Ali Pouya <alipouya2@gmail.com>
[15+ messages in thread]
700K Inserts in transaction
2013-02-14 10:28 UTC Asmir Mustafic <goetas@lignano.it>
` Re: 700K Inserts in transaction
2013-02-14 11:51 UTC nik9000@gmail.com
[2+ messages in thread]
PG_XLOG 27028 files running out of space
2013-02-14 10:49 UTC Tory M Blue <tmblue@gmail.com>
` Re: PG_XLOG 27028 files running out of space
2013-02-14 11:01 UTC Ian Lawrence Barwick <barwick@gmail.com>
` Re: PG_XLOG 27028 files running out of space
2013-02-14 11:06 UTC Tory M Blue <tmblue@gmail.com>
` Re: PG_XLOG 27028 files running out of space
2013-02-14 11:08 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: PG_XLOG 27028 files running out of space
2013-02-14 11:09 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: PG_XLOG 27028 files running out of space
2013-02-14 11:11 UTC Tory M Blue <tmblue@gmail.com>
[6+ messages in thread]
connection poolers' db connections
2013-02-13 13:47 UTC Yetkin Öztürk <yetkin85@gmail.com>
` Re: connection poolers' db connections
2013-02-13 14:56 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: connection poolers' db connections
2013-02-13 15:35 UTC Yetkin Öztürk <yetkin85@gmail.com>
[3+ messages in thread]
numerical primary key vs alphanumerical primary key
2013-02-04 21:52 UTC Anne Rosset <arosset@collab.net>
` Re: numerical primary key vs alphanumerical primary key
2013-02-04 21:57 UTC Виктор Егоров <vyegorov@gmail.com>
` Re: numerical primary key vs alphanumerical primary key
2013-02-12 13:06 UTC Julien Cigar <jcigar@ulb.ac.be>
` Re: numerical primary key vs alphanumerical primary key
2013-02-12 15:05 UTC Grant Johnson <grant@amadensor.com>
` Re: numerical primary key vs alphanumerical primary key
2013-02-12 15:14 UTC Florent Guillaume <fg@nuxeo.com>
` Re: numerical primary key vs alphanumerical primary key
2013-02-12 16:26 UTC Claudio Freire <klaussfreire@gmail.com>
[6+ messages in thread]
postgresql.conf recommendations
2013-02-05 22:02 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-05 22:37 UTC Josh Krupka <jkrupka@gmail.com>
` Re: postgresql.conf recommendations
2013-02-05 23:46 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 04:23 UTC Josh Krupka <jkrupka@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 06:00 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 06:18 UTC ac@hsk.hk <ac@hsk.hk>
` Re: postgresql.conf recommendations
2013-02-06 12:49 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: postgresql.conf recommendations
2013-02-06 15:42 UTC David Whittaker <dave@iradix.com>
` Re: postgresql.conf recommendations
2013-02-06 18:20 UTC Josh Krupka <jkrupka@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 19:13 UTC David Whittaker <dave@iradix.com>
` Re: postgresql.conf recommendations
2013-02-06 19:33 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 19:45 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 19:47 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 20:12 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 20:27 UTC Josh Krupka <jkrupka@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 21:12 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: postgresql.conf recommendations
2013-02-07 12:06 UTC Strahinja Kustudić <strahinjak@nordeus.com>
` Re: postgresql.conf recommendations
2013-02-07 14:41 UTC Charles Gomes <charlesrg@outlook.com>
` Re: postgresql.conf recommendations
2013-02-07 17:29 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-07 17:49 UTC Josh Krupka <jkrupka@gmail.com>
` Re: postgresql.conf recommendations
2013-02-09 13:19 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-09 13:24 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-09 14:51 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: postgresql.conf recommendations
2013-02-09 19:37 UTC Josh Krupka <jkrupka@gmail.com>
` Re: postgresql.conf recommendations
2013-02-09 20:16 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: postgresql.conf recommendations
2013-02-09 21:03 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: postgresql.conf recommendations
2013-02-10 04:02 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: postgresql.conf recommendations
2013-02-11 14:57 UTC Charles Gomes <charlesrg@outlook.com>
` Re: postgresql.conf recommendations
2013-02-11 22:10 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-11 22:57 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: postgresql.conf recommendations
2013-02-11 23:29 UTC Will Platnick <wplatnick@gmail.com>
` Re: postgresql.conf recommendations
2013-02-12 02:54 UTC Scott Marlowe <scott.marlowe@gmail.com>
[32+ messages in thread]
Is it correct to optimize a query with subselect in the "where"?
2013-02-11 12:52 UTC Alexandre Riveira <alexandre@objectdata.com.br>
Slow query even with aggressive auto analyze
2013-02-08 12:36 UTC Karolis Pocius <kpocius@northplains.com>
` Re: Slow query even with aggressive auto analyze
2013-02-10 06:52 UTC Amit kapila <amit.kapila@huawei.com>
[2+ messages in thread]
Query Time is Slow
2013-02-08 22:13 UTC Foster, Kristian B (HSC) <kristian-foster@ouhsc.edu>
` Re: Query Time is Slow
2013-02-08 22:45 UTC Kevin Grittner <kgrittn@ymail.com>
[2+ 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