pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedcpu comparison
2011-07-18 19:48 UTC M. D. <lists@turnkey.bz>
` Re: cpu comparison
2011-07-18 20:11 UTC ktm@rice.edu <ktm@rice.edu>
` Re: cpu comparison
2011-07-18 21:56 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: cpu comparison
2011-07-18 22:03 UTC Josh Berkus <josh@agliodbs.com>
` Re: cpu comparison
2011-07-18 23:19 UTC ktm@rice.edu <ktm@rice.edu>
` Re: cpu comparison
2011-07-19 00:47 UTC Greg Smith <greg@2ndquadrant.com>
` Re: cpu comparison
2011-07-19 01:38 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: cpu comparison
2011-07-19 03:25 UTC M. D. <lists@turnkey.bz>
` Re: cpu comparison
2011-07-19 05:05 UTC Samuel Gendler <sgendler@ideasculptor.com>
[9+ messages in thread]
Statistics and Multi-Column indexes
2011-07-10 21:16 UTC lars <lhofhansl@yahoo.com>
` Re: Statistics and Multi-Column indexes
2011-07-10 21:31 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: Statistics and Multi-Column indexes
2011-07-11 20:32 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Statistics and Multi-Column indexes
2011-07-15 21:40 UTC lars <lhofhansl@yahoo.com>
[4+ messages in thread]
Unexpected seq scans when expected result is 1 row out of milions
2011-07-15 12:57 UTC Svetlin Manavski <svetlin.manavski@gmail.com>
` Re: Unexpected seq scans when expected result is 1 row out of milions
2011-07-15 17:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Inoptimal query plan for max() and multicolumn index
2011-06-20 05:35 UTC Vladimir Kulev <me@lightoze.net>
` Re: Inoptimal query plan for max() and multicolumn index
2011-06-20 15:41 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Inoptimal query plan for max() and multicolumn index
2011-06-20 16:08 UTC Vladimir Kulev <me@lightoze.net>
` Re: Inoptimal query plan for max() and multicolumn index
2011-06-21 10:49 UTC F. BROUARD / SQLpro <sqlpro@club-internet.fr>
` Re: Inoptimal query plan for max() and multicolumn index
2011-07-15 07:14 UTC Gaetano Mendola <mendola@gmail.com>
` Re: Inoptimal query plan for max() and multicolumn index
2011-07-15 07:14 UTC Gaetano Mendola <mendola@gmail.com>
[6+ messages in thread]
Planner choosing NestedLoop, although it is slower...
2011-07-12 18:11 UTC Mario Splivalo <mario.splivalo@megafon.hr>
` Re: Planner choosing NestedLoop, although it is slower...
2011-07-12 19:55 UTC Clem Dickey <dickeycl@us.ibm.com>
` Re: Planner choosing NestedLoop, although it is slower...
2011-07-12 20:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner choosing NestedLoop, although it is slower...
2011-07-12 22:06 UTC Mario Splivalo <mario.splivalo@megafon.hr>
` Re: Planner choosing NestedLoop, although it is slower...
2011-07-12 22:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner choosing NestedLoop, although it is slower...
2011-07-12 23:57 UTC Mario Splivalo <mario.splivalo@megafon.hr>
` Re: Planner choosing NestedLoop, although it is slower...
2011-07-13 00:53 UTC Mario Splivalo <mario.splivalo@megafon.hr>
` Re: Planner choosing NestedLoop, although it is slower...
2011-07-13 02:04 UTC Mario Splivalo <mario.splivalo@megafon.hr>
[8+ messages in thread]
Memory usage of auto-vacuum
2011-07-09 07:25 UTC Gael Le Mignot <gael@pilotsystems.net>
` Re: Memory usage of auto-vacuum
2011-07-09 08:31 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Memory usage of auto-vacuum
2011-07-09 08:33 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: Memory usage of auto-vacuum
2011-07-09 08:39 UTC Gael Le Mignot <gael@pilotsystems.net>
` Re: Memory usage of auto-vacuum
2011-07-09 08:43 UTC Gael Le Mignot <gael@pilotsystems.net>
` Re: Memory usage of auto-vacuum
2011-07-09 08:53 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: Memory usage of auto-vacuum
2011-07-09 09:00 UTC Gael Le Mignot <gael@pilotsystems.net>
` Re: Memory usage of auto-vacuum
2011-07-09 09:06 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: Memory usage of auto-vacuum
2011-07-09 09:27 UTC Gael Le Mignot <gael@pilotsystems.net>
` Re: Memory usage of auto-vacuum
2011-07-09 12:15 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Memory usage of auto-vacuum
2011-07-09 16:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Memory usage of auto-vacuum
2011-07-10 10:06 UTC Gael Le Mignot <gael@pilotsystems.net>
` Re: Memory usage of auto-vacuum
2011-07-12 15:44 UTC Gael Le Mignot <gael@pilotsystems.net>
[13+ messages in thread]
query total time im milliseconds
2011-07-10 11:41 UTC Radhya sahal <rad_cs_2006@yahoo.com>
` query total time im milliseconds
2011-07-10 13:07 UTC Radhya sahal <rad_cs_2006@yahoo.com>
` query total time im milliseconds
2011-07-10 13:08 UTC Radhya sahal <rad_cs_2006@yahoo.com>
` query total time im milliseconds
2011-07-10 16:44 UTC Radhya sahal <rad_cs_2006@yahoo.com>
` Re: query total time im milliseconds
2011-07-10 17:51 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Fw: query total time im milliseconds
2011-07-10 18:26 UTC Radhya sahal <rad_cs_2006@yahoo.com>
` Re: query total time im milliseconds
2011-07-10 22:20 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Fw: query total time im milliseconds
2011-07-10 22:54 UTC Craig Ringer <craig@postnewspapers.com.au>
[8+ messages in thread]
INSERT query times
2011-07-07 15:35 UTC sergio mayoral <smayoral@gmail.com>
` Re: INSERT query times
2011-07-10 08:12 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: INSERT query times
2011-07-10 16:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
issue with query optimizer when joining two partitioned tables
2011-07-08 21:36 UTC Anish Kejariwal <anishkej@gmail.com>
` Re: issue with query optimizer when joining two partitioned tables
2011-07-09 07:54 UTC Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
` Re: issue with query optimizer when joining two partitioned tables
2011-07-09 17:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: issue with query optimizer when joining two partitioned tables
2011-07-10 15:33 UTC Anish Kejariwal <anishkej@gmail.com>
` Re: issue with query optimizer when joining two partitioned tables
2011-07-10 15:46 UTC Jeremy Harris <jgh@wizmail.org>
[5+ messages in thread]
execution time for first INSERT
2011-07-08 11:23 UTC Sergio Mayoral <mayoralstuttgart@yahoo.com>
` Re: execution time for first INSERT
2011-07-09 00:40 UTC Jeff Davis <pgsql@j-davis.com>
[2+ messages in thread]
Just a note about column equivalence disarming the planner
2011-07-08 20:20 UTC Shaun Thomas <sthomas@peak6.com>
"VACUUM FULL ANALYZE" vs. Autovacuum Contention
2011-07-07 20:23 UTC D C <ptradingcom@gmail.com>
` "VACUUM FULL ANALYZE" vs. Autovacuum Contention
2011-07-07 20:30 UTC D C <ptradingcom@gmail.com>
` Re: "VACUUM FULL ANALYZE" vs. Autovacuum Contention
2011-07-07 21:21 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: "VACUUM FULL ANALYZE" vs. Autovacuum Contention
2011-07-07 21:30 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: "VACUUM FULL ANALYZE" vs. Autovacuum Contention
2011-07-08 16:46 UTC D C <ptradingcom@gmail.com>
` Re: "VACUUM FULL ANALYZE" vs. Autovacuum Contention
2011-07-08 17:12 UTC Greg Smith <greg@2ndQuadrant.com>
[6+ messages in thread]
Infinite Cache
2011-07-01 14:43 UTC Anthony Presley <anthony@resolution.com>
` Re: Infinite Cache
2011-07-01 15:54 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Infinite Cache
2011-07-01 22:37 UTC Jim Nasby <jim@nasby.net>
` Re: Infinite Cache
2011-07-02 08:20 UTC Dave Page <dpage@pgadmin.org>
` Re: Infinite Cache
2011-07-03 11:21 UTC Magnus Hagander <magnus@hagander.net>
` Re: Infinite Cache
2011-07-03 18:18 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Infinite Cache
2011-07-05 13:35 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Infinite Cache
2011-07-08 13:34 UTC Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
` Re: Infinite Cache
2011-07-08 13:41 UTC Magnus Hagander <magnus@hagander.net>
[9+ messages in thread]
DELETE taking too much memory
2011-07-07 13:34 UTC vincent dephily <vincent.dephily@mobile-devices.fr>
` Re: [PERFORM] DELETE taking too much memory
2011-07-07 18:54 UTC French, Martin <frenchm@cromwell.co.uk>
` Re: DELETE taking too much memory
2011-07-07 20:26 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: DELETE taking too much memory
2011-07-08 09:05 UTC Dean Rasheed <dean.a.rasheed@gmail.com>
` Re: DELETE taking too much memory
2011-07-08 09:13 UTC Vincent de Phily <vincent.dephily@mobile-devices.fr>
` Re: [PERFORM] DELETE taking too much memory
2011-07-08 09:20 UTC Vincent de Phily <vincent.dephily@mobile-devices.fr>
` Re: [PERFORM] DELETE taking too much memory
2011-07-08 09:31 UTC French, Martin <frenchm@cromwell.co.uk>
` Re: DELETE taking too much memory
2011-07-08 09:44 UTC Vincent de Phily <vincent.dephily@mobile-devices.fr>
` Re: [PERFORM] DELETE taking too much memory
2011-07-08 09:50 UTC Vincent de Phily <vincent.dephily@mobile-devices.fr>
` Re: DELETE taking too much memory
2011-07-08 10:48 UTC Dean Rasheed <dean.a.rasheed@gmail.com>
` Re: [PERFORM] DELETE taking too much memory
2011-07-08 11:09 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: [PERFORM] DELETE taking too much memory
2011-07-08 13:37 UTC Jose Ildefonso Camargo Tolosa <ildefonso.camargo@gmail.com>
[12+ messages in thread]
Very large record sizes and resource usage
2011-07-08 00:02 UTC jtkells@verizon.net
100% CPU Utilization when we run queries.
2011-06-08 04:19 UTC bakkiya <bakkiya@gmail.com>
` Re: 100% CPU Utilization when we run queries.
2011-06-08 05:07 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: 100% CPU Utilization when we run queries.
2011-06-10 07:39 UTC bakkiya <bakkiya@gmail.com>
` Re: 100% CPU Utilization when we run queries.
2011-06-10 09:00 UTC Marti Raudsepp <marti@juffo.org>
` Re: 100% CPU Utilization when we run queries.
2011-06-10 12:37 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: 100% CPU Utilization when we run queries.
2011-06-16 04:35 UTC bakkiya <bakkiya@gmail.com>
` Re: 100% CPU Utilization when we run queries.
2011-07-06 13:30 UTC bakkiya <bakkiya@gmail.com>
` Re: 100% CPU Utilization when we run queries.
2011-07-06 13:47 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: 100% CPU Utilization when we run queries.
2011-07-06 19:04 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: 100% CPU Utilization when we run queries.
2011-07-06 21:05 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: 100% CPU Utilization when we run queries.
2011-07-06 23:36 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: 100% CPU Utilization when we run queries.
2011-07-07 09:45 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: 100% CPU Utilization when we run queries.
2011-07-07 12:49 UTC bakkiya <bakkiya@gmail.com>
[13+ messages in thread]
Query in 9.0.2 not using index in 9.0.0 works fine
2011-07-05 20:50 UTC Matthias Howell <Matthias.Howell@voxco.com>
` Re: Query in 9.0.2 not using index in 9.0.0 works fine
2011-07-06 07:42 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: Query in 9.0.2 not using index in 9.0.0 works fine
2011-07-06 12:50 UTC Matthias Howell <Matthias.Howell@voxco.com>
` Re: Query in 9.0.2 not using index in 9.0.0 works fine
2011-07-06 20:01 UTC Samuel Gendler <sgendler@ideasculptor.com>
[4+ messages in thread]
bitmask index
2011-06-22 21:27 UTC Marcus Engene <mengpg2@engene.se>
` Re: bitmask index
2011-06-22 21:42 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: bitmask index
2011-06-23 15:55 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: bitmask index
2011-07-05 10:15 UTC Marcus Engene <mengpg2@engene.se>
` Re: bitmask index
2011-07-05 17:43 UTC Greg Smith <greg@2ndQuadrant.com>
[5+ messages in thread]
Postgres bulkload without transaction logs
2011-07-05 14:42 UTC shouvik basu <babanomania@gmail.com>
` Re: Postgres bulkload without transaction logs
2011-07-05 17:41 UTC Greg Smith <greg@2ndQuadrant.com>
[2+ messages in thread]
How can retrieve total query run-time with out using explain
2011-07-03 04:13 UTC Radhya sahal <rad_cs_2006@yahoo.com>
` Re: How can retrieve total query run-time with out using explain
2011-07-03 06:09 UTC Craig Ringer <craig@postnewspapers.com.au>
[2+ messages in thread]
near identical queries have vastly different plans
2011-06-30 08:53 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: near identical queries have vastly different plans
2011-06-30 09:40 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: near identical queries have vastly different plans
2011-06-30 20:34 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: near identical queries have vastly different plans
2011-07-01 22:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: near identical queries have vastly different plans
2011-07-02 00:51 UTC Samuel Gendler <sgendler@ideasculptor.com>
[5+ messages in thread]
Poor performance when joining against inherited tables
2011-04-11 20:11 UTC Lucas Madar <madar@samsix.com>
` Re: Poor performance when joining against inherited tables
2011-04-12 13:22 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Poor performance when joining against inherited tables
2011-05-11 16:38 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Poor performance when joining against inherited tables
2011-05-11 17:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor performance when joining against inherited tables
2011-05-11 20:47 UTC Lucas Madar <madar@samsix.com>
` Re: Poor performance when joining against inherited tables
2011-05-12 21:07 UTC Maciek Sakrejda <msakrejda@truviso.com>
` Re: Poor performance when joining against inherited tables
2011-06-30 19:07 UTC Robert Haas <robertmhaas@gmail.com>
[7+ messages in thread]
is parallel union all possible over dblink?
2011-06-29 11:55 UTC Svetlin Manavski <svetlin.manavski@gmail.com>
` Re: is parallel union all possible over dblink?
2011-06-29 18:37 UTC Marinos Yannikos <mjy@geizhals.at>
` Re: is parallel union all possible over dblink?
2011-06-29 19:14 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: is parallel union all possible over dblink?
2011-06-29 19:38 UTC Shaun Thomas <sthomas@peak6.com>
` Re: is parallel union all possible over dblink?
2011-06-30 09:02 UTC Svetlin Manavski <svetlin.manavski@gmail.com>
` Re: is parallel union all possible over dblink?
2011-06-30 12:37 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
[6+ messages in thread]
sequential scan unduly favored over text search gin index
2011-06-20 15:38 UTC Sushant Sinha <sushant354@gmail.com>
` Re: sequential scan unduly favored over text search gin index
2011-06-20 15:58 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: sequential scan unduly favored over text search gin index
2011-06-20 16:04 UTC Sushant Sinha <sushant354@gmail.com>
` Re: sequential scan unduly favored over text search gin index
2011-06-20 18:58 UTC Jesper Krogh <jesper@krogh.cc>
` Re: sequential scan unduly favored over text search gin index
2011-06-20 19:01 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: sequential scan unduly favored over text search gin index
2011-06-21 02:25 UTC Sushant Sinha <sushant354@gmail.com>
` Re: sequential scan unduly favored over text search gin index
2011-06-21 05:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: sequential scan unduly favored over text search gin index
2011-06-30 03:41 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: sequential scan unduly favored over text search gin index
2011-06-30 03:59 UTC Jeff Janes <jeff.janes@gmail.com>
[9+ messages in thread]
[PERFORM] change sample size for statistics
2011-06-10 12:15 UTC Willy-Bas Loos <willybas@gmail.com>
` Re: change sample size for statistics
2011-06-10 19:58 UTC Josh Berkus <josh@agliodbs.com>
` Re: change sample size for statistics
2011-06-10 20:07 UTC Nathan Boley <npboley@gmail.com>
` Re: [PERFORM] change sample size for statistics
2011-06-13 22:33 UTC Willy-Bas Loos <willybas@gmail.com>
` Re: [PERFORM] change sample size for statistics
2011-06-29 02:55 UTC Robert Haas <robertmhaas@gmail.com>
[5+ 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