pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSubquery flattening causing sequential scan
2011-12-27 17:29 UTC Jim Crate <jimcfl@gmail.com>
` Re: Subquery flattening causing sequential scan
2011-12-27 18:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Subquery flattening causing sequential scan
2011-12-27 22:21 UTC Ondrej Ivanič <ondrej.ivanic@gmail.com>
` Re: Subquery flattening causing sequential scan
2011-12-28 00:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Subquery flattening causing sequential scan
2011-12-28 08:30 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: Subquery flattening causing sequential scan
2011-12-28 17:22 UTC Jim Crate <jimcfl@gmail.com>
` Re: Subquery flattening causing sequential scan
2012-01-11 00:19 UTC Robert Haas <robertmhaas@gmail.com>
[7+ messages in thread]
Query planner doesn't use index scan on tsvector GIN index if LIMIT is specified
2012-01-10 11:30 UTC darklow <darklow@gmail.com>
` Query planner doesn't use index scan on tsvector GIN index if LIMIT is specifiedQuery planner doesn't use index scan on tsvector GIN index if LIMIT is specified
2012-01-10 12:30 UTC darklow <darklow@gmail.com>
` Re: Query planner doesn't use index scan on tsvector GIN index if LIMIT is specifiedQuery planner doesn't use index scan on tsvector GIN index if LIMIT is specified
2012-01-10 17:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query planner doesn't use index scan on tsvector GIN index if LIMIT is specifiedQuery planner doesn't use index scan on tsvector GIN index if LIMIT is specified
2012-01-10 21:42 UTC Jesper Krogh <jesper@krogh.cc>
[4+ messages in thread]
Re: pg_upgrade failure "contrib" issue?
2011-12-07 23:53 UTC Tory M Blue <tmblue@gmail.com>
` Re: pg_upgrade failure "contrib" issue?
2012-01-10 21:21 UTC Robert Haas <robertmhaas@gmail.com>
[2+ messages in thread]
Duplicate deletion optimizations
2012-01-06 14:35 UTC antoine@inaps.org
` Re: Duplicate deletion optimizations
2012-01-06 15:21 UTC antoine@inaps.org
` Re: Duplicate deletion optimizations
2012-01-06 20:02 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: Duplicate deletion optimizations
2012-01-06 20:22 UTC Marc Eberhard <eberhardma@googlemail.com>
` Re: Duplicate deletion optimizations
2012-01-06 20:38 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: Duplicate deletion optimizations
2012-01-06 22:20 UTC Marc Eberhard <eberhardma@googlemail.com>
` Re: Duplicate deletion optimizations
2012-01-07 00:02 UTC Strange, John W <john.w.strange@jpmorgan.com>
` Re: Duplicate deletion optimizations
2012-01-07 03:28 UTC Misa Simic <misa.simic@gmail.com>
` Re: Duplicate deletion optimizations
2012-01-07 11:57 UTC Jochen Erwied <jochen@pgsql-performance.erwied.eu>
` Re: Duplicate deletion optimizations
2012-01-07 12:20 UTC Pierre C <lists@peufeu.com>
` Re: Duplicate deletion optimizations
2012-01-07 12:21 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: Duplicate deletion optimizations
2012-01-07 14:02 UTC Misa Simic <misa.simic@gmail.com>
` Re: Duplicate deletion optimizations
2012-01-07 14:17 UTC Jochen Erwied <jochen@pgsql-performance.erwied.eu>
` Re: Duplicate deletion optimizations
2012-01-07 14:18 UTC Jochen Erwied <jochen@erwied.eu>
` Re: Duplicate deletion optimizations
2012-01-07 15:31 UTC Pierre C <lists@peufeu.com>
` Re: Duplicate deletion optimizations
2012-01-07 18:54 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Duplicate deletion optimizations
2012-01-07 20:16 UTC Misa Simic <misa.simic@gmail.com>
` Re: Duplicate deletion optimizations
2012-01-07 22:54 UTC Marc Eberhard <eberhardma@googlemail.com>
` Re: Duplicate deletion optimizations
2012-01-08 18:09 UTC Pierre C <lists@peufeu.com>
` Re: Duplicate deletion optimizations
2012-01-09 12:59 UTC antoine@inaps.org
[20+ messages in thread]
Postgresql Replication Performance
2011-12-29 09:33 UTC sgupta <saurabh.b85@gmail.com>
` Re: Postgresql Replication Performance
2011-12-29 14:33 UTC Aleksej Trofimov <aleksej.trofimov@ruptela.lt>
` Re: Postgresql Replication Performance
2011-12-29 15:00 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Postgresql Replication Performance
2011-12-29 15:05 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Postgresql Replication Performance
2011-12-29 16:05 UTC Aleksej Trofimov <aleksej.trofimov@ruptela.lt>
` Re: Postgresql Replication Performance
2012-01-04 10:41 UTC Saurabh <saurabh.b85@gmail.com>
` Re: Postgresql Replication Performance
2012-01-04 11:42 UTC Aleksej Trofimov <aleksej.trofimov@ruptela.lt>
[7+ messages in thread]
Query performance - normal on 9.0.4, slow from 9.0.5 onwards
2011-12-30 16:39 UTC Miguel Silva <miguel.silva@tactis.pt>
` Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards
2011-12-30 17:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards
2011-12-30 17:50 UTC Miguel Silva <miguel.silva@tactis.pt>
` Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards
2011-12-30 19:35 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards
2011-12-30 22:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards
2012-01-02 11:44 UTC Miguel Silva <miguel.silva@tactis.pt>
` Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards
2012-01-02 11:57 UTC Miguel Silva <miguel.silva@tactis.pt>
[7+ messages in thread]
Cost estimate vs. actual - do I care?
2012-01-01 18:59 UTC Jay Levitt <jay.levitt@gmail.com>
` Re: Cost estimate vs. actual - do I care?
2012-01-01 20:00 UTC Mark Mielke <mark@mark.mielke.cc>
[2+ messages in thread]
How to clock the time spent for query parsing and planning?
2011-12-23 19:27 UTC Igor Schtein <ischtein@gmail.com>
` Re: How to clock the time spent for query parsing and planning?
2011-12-27 09:38 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: How to clock the time spent for query parsing and planning?
2011-12-31 00:59 UTC Igor <ischtein@gmail.com>
` Re: How to clock the time spent for query parsing and planning?
2011-12-31 07:49 UTC Pavel Stehule <pavel.stehule@gmail.com>
[4+ messages in thread]
parse - bind take more time than execute
2011-12-27 10:52 UTC MirrorX <mirrorx@gmail.com>
` Re: parse - bind take more time than execute
2011-12-27 11:01 UTC MirrorX <mirrorx@gmail.com>
` Re: parse - bind take more time than execute
2011-12-27 12:01 UTC Filip Rembiałkowski <plk.zuber@gmail.com>
` Re: parse - bind take more time than execute
2011-12-27 13:34 UTC MirrorX <mirrorx@gmail.com>
` Re: parse - bind take more time than execute
2011-12-27 14:01 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: parse - bind take more time than execute
2011-12-27 14:21 UTC MirrorX <mirrorx@gmail.com>
` Re: parse - bind take more time than execute
2011-12-28 23:22 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: parse - bind take more time than execute
2011-12-29 16:12 UTC MirrorX <mirrorx@gmail.com>
` Re: parse - bind take more time than execute
2011-12-29 16:51 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[9+ messages in thread]
PostgreSQL 9.0.4 blocking in lseek?
2011-10-26 15:47 UTC Sören Meyer-Eppler <soerenme@google.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-10-27 07:42 UTC Gregg Jaskiewicz <gryzman@gmail.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-10-27 12:03 UTC Sören Meyer-Eppler <soerenme@google.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-10-27 14:54 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-10-28 00:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-10-28 02:42 UTC Josh Berkus <josh@agliodbs.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-10-31 13:56 UTC Sören Meyer-Eppler <soerenme@google.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-10-31 14:09 UTC Sören Meyer-Eppler <soerenme@google.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-10-31 15:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-10-31 16:17 UTC Sören Meyer-Eppler <soerenme@google.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-12-28 09:57 UTC Matteo Beccati <php@beccati.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-12-28 14:20 UTC Matteo Beccati <php@beccati.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-12-28 18:02 UTC Matteo Beccati <php@beccati.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-12-28 18:07 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-12-28 18:41 UTC Matteo Beccati <php@beccati.com>
` Re: PostgreSQL 9.0.4 blocking in lseek?
2011-12-29 09:03 UTC Matteo Beccati <php@beccati.com>
[16+ messages in thread]
Performance costs of various PL languages
2011-12-27 21:09 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Performance costs of various PL languages
2011-12-27 22:20 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Performance costs of various PL languages
2011-12-27 22:54 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performance costs of various PL languages
2011-12-27 23:11 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Performance costs of various PL languages
2011-12-27 23:38 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
[5+ messages in thread]
Exploring memory usage
2011-12-24 19:22 UTC Michael Smolsky <sitrash@email.com>
` Re: Exploring memory usage
2011-12-27 15:33 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Exploring memory usage
2011-12-27 16:00 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Exploring memory usage
2011-12-27 16:06 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Exploring memory usage
2011-12-27 16:14 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Exploring memory usage
2011-12-27 16:17 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Exploring memory usage
2011-12-27 16:45 UTC Scott Marlowe <scott.marlowe@gmail.com>
[7+ messages in thread]
Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:36 UTC tuanhoanganh <hatuan05@gmail.com>
` Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 03:55 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 04:00 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 06:18 UTC tuanhoanganh <hatuan05@gmail.com>
` Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 07:05 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 07:58 UTC Satoshi Nagayasu <satoshi.nagayasu@gmail.com>
` Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 09:20 UTC Mario Weilguni <roadrunner6@gmx.at>
` Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 12:15 UTC alexandre - aldeia digital <adaldeia@gmail.com>
` Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 15:25 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 15:32 UTC tuanhoanganh <hatuan05@gmail.com>
` Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-23 18:06 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-25 03:13 UTC tuanhoanganh <hatuan05@gmail.com>
` Re: Postgresql 9.0.6 Raid 5 or not please help.
2011-12-25 07:15 UTC Scott Marlowe <scott.marlowe@gmail.com>
[13+ messages in thread]
Dramatic change in memory usage with version 9.1
2011-12-19 15:04 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Dramatic change in memory usage with version 9.1
2011-12-19 15:54 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Dramatic change in memory usage with version 9.1
2011-12-19 16:02 UTC Marti Raudsepp <marti@juffo.org>
` Re: Dramatic change in memory usage with version 9.1
2011-12-20 11:15 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
` Re: Dramatic change in memory usage with version 9.1
2011-12-20 23:48 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Dramatic change in memory usage with version 9.1
2011-12-21 17:41 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Dramatic change in memory usage with version 9.1
2011-12-21 17:50 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Dramatic change in memory usage with version 9.1
2011-12-21 18:18 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Dramatic change in memory usage with version 9.1
2011-12-21 18:54 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Dramatic change in memory usage with version 9.1
2011-12-21 23:29 UTC Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>
` Re: Dramatic change in memory usage with version 9.1
2011-12-22 09:00 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: Dramatic change in memory usage with version 9.1
2011-12-22 09:58 UTC Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>
[12+ messages in thread]
Guidance Requested - Bulk Inserting + Queries
2011-11-30 15:27 UTC Benjamin Johnson <benjamin.johnson@getcarbonblack.com>
` Re: Guidance Requested - Bulk Inserting + Queries
2011-11-30 16:17 UTC Leonardo Francalanci <m_lists@yahoo.it>
` Re: Guidance Requested - Bulk Inserting + Queries
2011-12-01 02:00 UTC Benjamin Johnson <benjamin.johnson@getcarbonblack.com>
` Re: Guidance Requested - Bulk Inserting + Queries
2011-12-01 15:06 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Guidance Requested - Bulk Inserting + Queries
2011-12-22 02:30 UTC Benjamin Johnson <benjamin.johnson@getcarbonblack.com>
` Re: Guidance Requested - Bulk Inserting + Queries
2011-12-22 08:04 UTC Jeff Janes <jeff.janes@gmail.com>
[6+ messages in thread]
Re: OOM-killer issue with a specific query SOLVED
2011-12-21 05:09 UTC nabble.30.miller_2555@spamgourmet.com
Re: OOM-killer issue with a specific query 9 of 20)
2011-12-20 16:46 UTC nabble.30.miller_2555@spamgourmet.com
` Re: OOM-killer issue with a specific query 9 of 20)
2011-12-20 20:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Re: OOM-killer issue with a specific query 11 of 20)
2011-12-20 18:33 UTC nabble.30.miller_2555@spamgourmet.com
OOM-killer issue with a specific query
2011-12-19 15:52 UTC nabble.30.miller_2555@spamgourmet.com
` Re: OOM-killer issue with a specific query
2011-12-20 13:24 UTC Scott Marlowe <scott.marlowe@gmail.com>
[2+ messages in thread]
will the planner ever use an index when the condition is <> ?
2011-12-17 15:30 UTC Roxanne Reid-Bennett <rox@tara-lu.com>
` Re: will the planner ever use an index when the condition is <> ?
2011-12-17 16:24 UTC Filip Rembiałkowski <plk.zuber@gmail.com>
` Re: will the planner ever use an index when the condition is <> ?
2011-12-18 10:41 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: will the planner ever use an index when the condition is <> ?
2011-12-18 14:52 UTC Roxanne Reid-Bennett <rox@tara-lu.com>
` Re: will the planner ever use an index when the condition is <> ?
2011-12-18 18:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: will the planner ever use an index when the condition is <> ?
2011-12-18 20:11 UTC Marti Raudsepp <marti@juffo.org>
` Re: will the planner ever use an index when the condition is <> ?
2011-12-18 20:18 UTC Roxanne Reid-Bennett <rox@tara-lu.com>
[7+ messages in thread]
Is it possible to use index on column for regexp match operator '~'?
2011-12-14 16:05 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Is it possible to use index on column for regexp match operator '~'?
2011-12-14 20:43 UTC Marti Raudsepp <marti@juffo.org>
` Re: Is it possible to use index on column for regexp match operator '~'?
2011-12-15 01:54 UTC Rural Hunter <ruralhunter@gmail.com>
[3+ messages in thread]
Slow query after upgrade from 8.2 to 8.4
2011-12-08 17:29 UTC Kaloyan Iliev Iliev <kaloyan@digsys.bg>
` Re: Slow query after upgrade from 8.2 to 8.4
2011-12-08 17:52 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Slow query after upgrade from 8.2 to 8.4
2011-12-09 03:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query after upgrade from 8.2 to 8.4
2011-12-09 12:23 UTC Kaloyan Iliev Iliev <kaloyan@digsys.bg>
` Re: Slow query after upgrade from 8.2 to 8.4
2011-12-09 15:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query after upgrade from 8.2 to 8.4
2011-12-13 22:13 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Slow query after upgrade from 8.2 to 8.4
2011-12-14 17:48 UTC Kaloyan Iliev Iliev <kaloyan@digsys.bg>
[7+ messages in thread]
Partitions and joins lead to index lookups on all partitions
2011-12-07 15:15 UTC Christiaan Willemsen <cwillemsen@technocon.com>
` Re: Partitions and joins lead to index lookups on all partitions
2011-12-07 21:36 UTC Ondrej Ivanič <ondrej.ivanic@gmail.com>
` Re: Partitions and joins lead to index lookups on all partitions
2011-12-08 13:57 UTC voodooless <cwillemsen@technocon.com>
` Re: Partitions and joins lead to index lookups on all partitions
2011-12-14 16:06 UTC voodooless <cwillemsen@technocon.com>
[4+ messages in thread]
Postgres array parser
2011-12-13 13:55 UTC Aleksej Trofimov <aleksej.trofimov@ruptela.lt>
` Re: Postgres array parser
2011-12-13 14:02 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Postgres array parser
2011-12-13 14:28 UTC Aleksej Trofimov <aleksej.trofimov@ruptela.lt>
` Re: Postgres array parser
2011-12-13 14:42 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Postgres array parser
2011-12-14 09:21 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: Postgres array parser
2011-12-14 09:59 UTC Aleksej Trofimov <aleksej.trofimov@ruptela.lt>
` Re: Postgres array parser
2011-12-14 10:27 UTC Marc Mamin <M.Mamin@intershop.de>
[7+ messages in thread]
select distinct uses index scan vs full table scan
2011-12-13 18:12 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: select distinct uses index scan vs full table scan
2011-12-13 19:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: select distinct uses index scan vs full table scan
2011-12-13 20:17 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
[3+ 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