pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedVery 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]
Slow performance when querying millions of rows
2011-06-28 21:28 UTC Craig McIlwee <craig.mcilwee@openroadsconsulting.com>
` Re: Slow performance when querying millions of rows
2011-06-28 22:39 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Slow performance when querying millions of rows
2011-06-28 22:42 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Slow performance when querying millions of rows
2011-06-28 23:26 UTC Craig McIlwee <craig.mcilwee@openroadsconsulting.com>
` Re: Slow performance when querying millions of rows
2011-06-28 23:50 UTC Craig McIlwee <craig.mcilwee@openroadsconsulting.com>
` Re: Slow performance when querying millions of rows
2011-06-29 00:03 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Slow performance when querying millions of rows
2011-06-29 00:10 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Slow performance when querying millions of rows
2011-06-29 00:51 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Slow performance when querying millions of rows
2011-06-29 01:01 UTC Greg Smith <greg@2ndQuadrant.com>
[9+ messages in thread]
Re: Long Running Update - My Solution
2011-06-27 15:02 UTC Harry Mantheakis <harry.mantheakis@riskcontrollimited.com>
` Re: Long Running Update - My Solution
2011-06-27 15:12 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Long Running Update - My Solution
2011-06-27 15:37 UTC tv@fuzzy.cz
` Re: Long Running Update - My Solution
2011-06-27 19:29 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: Long Running Update - My Solution
2011-06-28 00:37 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Long Running Update - My Solution
2011-06-28 09:48 UTC Harry Mantheakis <harry.mantheakis@riskcontrollimited.com>
[6+ messages in thread]
Getting rid of a seq scan in query on a large table
2011-06-27 12:46 UTC Jens Hoffrichter <jens.hoffrichter@gmail.com>
` Re: Getting rid of a seq scan in query on a large table
2011-06-27 14:30 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Fw: Getting rid of a seq scan in query on a large table
2011-06-27 23:00 UTC Denis de Bernardy <ddebernardy@yahoo.com>
[3+ messages in thread]
Performance issue with Insert
2011-06-27 14:22 UTC Jenish <jenishvyas@gmail.com>
` Re: Performance issue with Insert
2011-06-27 14:37 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Performance issue with Insert
2011-06-27 15:01 UTC Jenish <jenishvyas@gmail.com>
` Re: Performance issue with Insert
2011-06-27 15:32 UTC tv@fuzzy.cz
` Re: Performance issue with Insert
2011-06-27 15:58 UTC Jenish <jenishvyas@gmail.com>
` Re: Performance issue with Insert
2011-06-27 16:12 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performance issue with Insert
2011-06-27 19:46 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Performance issue with Insert
2011-06-27 19:48 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Performance issue with Insert
2011-06-27 20:14 UTC Jenish <jenishvyas@gmail.com>
` Re: Performance issue with Insert
2011-06-27 20:47 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Performance issue with Insert
2011-06-27 20:56 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[11+ messages in thread]
Cost of creating an emply WAL segment
2011-06-24 14:43 UTC Devrim GÜNDÜZ <devrim@gunduz.org>
` Re: Cost of creating an emply WAL segment
2011-06-24 16:18 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Cost of creating an emply WAL segment
2011-06-24 18:55 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Cost of creating an emply WAL segment
2011-06-24 23:26 UTC Greg Smith <greg@2ndQuadrant.com>
[4+ messages in thread]
Long Running Update
2011-06-23 15:05 UTC Harry Mantheakis <harry.mantheakis@riskcontrollimited.com>
` Re: Long Running Update
2011-06-23 17:18 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Long Running Update
2011-06-23 19:32 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Long Running Update
2011-06-24 11:16 UTC Harry Mantheakis <harry.mantheakis@riskcontrollimited.com>
` Re: Long Running Update
2011-06-24 11:19 UTC Harry Mantheakis <harry.mantheakis@riskcontrollimited.com>
` Re: Long Running Update
2011-06-24 11:39 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Long Running Update
2011-06-24 11:45 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: Long Running Update
2011-06-24 12:39 UTC Harry Mantheakis <harry.mantheakis@riskcontrollimited.com>
` Re: Long Running Update
2011-06-24 12:52 UTC Mark Thornton <mthornton@optrak.com>
` Re: Long Running Update
2011-06-24 13:43 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Long Running Update
2011-06-24 14:00 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Long Running Update
2011-06-24 15:12 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Long Running Update
2011-06-24 16:29 UTC Harry Mantheakis <harry.mantheakis@riskcontrollimited.com>
` Re: Long Running Update
2011-06-24 16:31 UTC Harry Mantheakis <harry.mantheakis@riskcontrollimited.com>
` Re: Long Running Update
2011-06-24 16:41 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Long Running Update
2011-06-24 16:49 UTC Harry Mantheakis <harry.mantheakis@riskcontrollimited.com>
[16+ messages in thread]
seq scan in the case of max() on the primary key column
2011-06-16 13:55 UTC Svetlin Manavski <svetlin.manavski@gmail.com>
` Re: seq scan in the case of max() on the primary key column
2011-06-16 17:03 UTC Jesper Krogh <jesper@krogh.cc>
` Re: seq scan in the case of max() on the primary key column
2011-06-16 17:25 UTC Magnus Hagander <magnus@hagander.net>
` Re: seq scan in the case of max() on the primary key column
2011-06-16 18:36 UTC Shaun Thomas <sthomas@peak6.com>
` Re: seq scan in the case of max() on the primary key column
2011-06-17 11:22 UTC Svetlin Manavski <svetlin.manavski@gmail.com>
` Re: seq scan in the case of max() on the primary key column
2011-06-17 12:43 UTC Shaun Thomas <sthomas@peak6.com>
` Re: seq scan in the case of max() on the primary key column
2011-06-17 18:00 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: seq scan in the case of max() on the primary key column
2011-06-17 20:31 UTC Jim Nasby <jim@nasby.net>
` Re: seq scan in the case of max() on the primary key column
2011-06-21 19:49 UTC Shaun Thomas <sthomas@peak6.com>
` Re: seq scan in the case of max() on the primary key column
2011-06-22 09:55 UTC Marti Raudsepp <marti@juffo.org>
` Re: seq scan in the case of max() on the primary key column
2011-06-22 13:12 UTC Shaun Thomas <sthomas@peak6.com>
` Re: seq scan in the case of max() on the primary key column
2011-06-22 17:01 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: seq scan in the case of max() on the primary key column
2011-06-22 18:12 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: seq scan in the case of max() on the primary key column
2011-06-22 18:15 UTC Shaun Thomas <sthomas@peak6.com>
` Re: seq scan in the case of max() on the primary key column
2011-06-22 21:35 UTC Greg Smith <greg@2ndQuadrant.com>
[15+ messages in thread]
Improve the Postgres Query performance
2011-06-21 20:34 UTC Tripura <k_tripura@hotmail.com>
` Re: Improve the Postgres Query performance
2011-06-22 07:05 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Improve the Postgres Query performance
2011-06-22 20:57 UTC Tripura <k_tripura@hotmail.com>
[3+ messages in thread]
Contemplating SSD Hardware RAID
2011-06-21 03:54 UTC Dan Harris <fbsd@drivefaster.net>
` Re: Contemplating SSD Hardware RAID
2011-06-21 06:33 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Contemplating SSD Hardware RAID
2011-06-21 07:51 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: Contemplating SSD Hardware RAID
2011-06-21 07:55 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: Contemplating SSD Hardware RAID
2011-06-21 11:19 UTC Florian Weimer <fweimer@bfk.de>
` Re: Contemplating SSD Hardware RAID
2011-06-21 15:11 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Contemplating SSD Hardware RAID
2011-06-21 18:29 UTC Anton Rommerskirchen <atr@atrsoft.de>
` Re: Contemplating SSD Hardware RAID
2011-06-21 20:10 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: Contemplating SSD Hardware RAID
2011-06-21 20:25 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: Contemplating SSD Hardware RAID
2011-06-21 20:32 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Contemplating SSD Hardware RAID
2011-06-21 21:35 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Contemplating SSD Hardware RAID
2011-06-21 22:17 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Contemplating SSD Hardware RAID
2011-06-22 15:50 UTC Shaun Thomas <sthomas@peak6.com>
[13+ messages in thread]
Cross Table (Pivot)
2011-06-21 03:35 UTC Mario Guerrero <chimuelo22@yahoo.es>
how to know slowly query in lock postgre
2011-06-20 07:57 UTC Didik Prasetyo <prasetyodidik62@yahoo.com>
` Re: how to know slowly query in lock postgre
2011-06-20 09:45 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: how to know slowly query in lock postgre
2011-06-20 19:09 UTC Tomas Vondra <tv@fuzzy.cz>
[3+ messages in thread]
generating a large XML document
2011-06-16 19:33 UTC Julius Tuskenis <julius@nsoft.lt>
` Re: generating a large XML document
2011-06-20 06:36 UTC Julius Tuskenis <julius@nsoft.lt>
` Re: generating a large XML document
2011-06-20 06:51 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: generating a large XML document
2011-06-20 07:21 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: generating a large XML document
2011-06-20 07:29 UTC Julius Tuskenis <julius@nsoft.lt>
` Re: generating a large XML document
2011-06-20 07:38 UTC Julius Tuskenis <julius@nsoft.lt>
` Re: generating a large XML document
2011-06-20 07:47 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: generating a large XML document
2011-06-20 07:58 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: generating a large XML document
2011-06-20 09:03 UTC Julius Tuskenis <julius@nsoft.lt>
[9+ messages in thread]
Degrading PostgreSQL 8.4 write performance
2011-06-17 12:48 UTC Kabu Taah <kabuutah@hot.ee>
` Re: Degrading PostgreSQL 8.4 write performance
2011-06-17 14:08 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Degrading PostgreSQL 8.4 write performance
2011-06-17 17:54 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Degrading PostgreSQL 8.4 write performance
2011-06-19 23:05 UTC Pierre C <lists@peufeu.com>
[4+ messages in thread]
Performance advice for a new low(er)-power server
2011-06-16 15:09 UTC Haestan <haestan@gmail.com>
` Re: Performance advice for a new low(er)-power server
2011-06-16 18:19 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performance advice for a new low(er)-power server
2011-06-16 18:29 UTC Jesper Krogh <jesper@krogh.cc>
` Re: Performance advice for a new low(er)-power server
2011-06-16 18:43 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Performance advice for a new low(er)-power server
2011-06-16 18:52 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Performance advice for a new low(er)-power server
2011-06-16 19:04 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performance advice for a new low(er)-power server
2011-06-16 22:12 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Performance advice for a new low(er)-power server
2011-06-16 22:44 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performance advice for a new low(er)-power server
2011-06-17 08:42 UTC Haestan <haestan@gmail.com>
` Re: Performance advice for a new low(er)-power server
2011-06-17 09:13 UTC Haestan <haestan@gmail.com>
` Re: Performance advice for a new low(er)-power server
2011-06-17 09:30 UTC jesper@krogh.cc
` Re: Performance advice for a new low(er)-power server
2011-06-17 13:29 UTC Merlin Moncure <mmoncure@gmail.com>
[12+ 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