pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Re: [PERFORM] How to diagnose a “context-switching ” storm problem ? 2010-04-12 21:27 UTC Sergey Konoplev <gray.ru@gmail.com> How check execution plan of a function 2010-04-07 12:47 UTC Sabin Coanda <sabin.coandaSPAMPROTECTION@deuromedia.ro> ` Re: How check execution plan of a function 2010-04-08 06:29 UTC Sabin Coanda <sabin.coandaSPAMPROTECTION@deuromedia.ro> ` Re: How check execution plan of a function 2010-04-08 15:44 UTC Andy Colson <andy@squeakycode.net> ` Re: How check execution plan of a function 2010-04-09 13:18 UTC Sabin Coanda <sabin.coandaSPAMPROTECTION@deuromedia.ro> ` Re: How check execution plan of a function 2010-04-09 13:52 UTC Andy Colson <andy@squeakycode.net> ` Re: How check execution plan of a function 2010-04-12 13:50 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov> [6+ messages in thread] function performs differently with different values 2010-04-10 20:47 UTC Ben Chobot <bench@silentmedia.com> ` Re: function performs differently with different values 2010-04-12 13:21 UTC Robert Haas <robertmhaas@gmail.com> [2+ messages in thread] planer chooses very bad plan 2010-04-11 21:12 UTC Corin <wakathane@gmail.com> ` Re: planer chooses very bad plan 2010-04-11 21:18 UTC Scott Marlowe <scott.marlowe@gmail.com> ` Re: planer chooses very bad plan 2010-04-11 21:22 UTC Luke Lonergan <LLonergan@greenplum.com> ` Re: planer chooses very bad plan 2010-04-11 21:25 UTC Hannu Krosing <hannu@2ndquadrant.com> ` Re: planer chooses very bad plan 2010-04-11 22:41 UTC Corin <wakathane@gmail.com> ` Re: planer chooses very bad plan 2010-04-11 22:44 UTC Corin <wakathane@gmail.com> ` Re: planer chooses very bad plan 2010-04-11 22:49 UTC Scott Marlowe <scott.marlowe@gmail.com> ` Re: planer chooses very bad plan 2010-04-12 10:06 UTC Pierre C <lists@peufeu.com> [8+ messages in thread] How to diagnose a “context-switching ” storm problem ? 2010-04-12 06:35 UTC RD黄永卫 <yongwei_huang@temp.gtmc.com.cn> 答复: [PERFORM] About “context-switching issue on Xeon” test case ？ 2010-04-12 01:10 UTC RD黄永卫 <yongwei_huang@temp.gtmc.com.cn> Re: [PERFORM] About “context-switching issue on Xeon” test case ？ 2010-04-10 05:05 UTC Scott Marlowe <scott.marlowe@gmail.com> ` Re: [PERFORM] About “context-switching issue on Xeon” test case ？ 2010-04-10 05:07 UTC Scott Marlowe <scott.marlowe@gmail.com> ` Re: [PERFORM] About “context-switching issue on Xeon” test case ？ 2010-04-11 15:43 UTC Scott Marlowe <scott.marlowe@gmail.com> [3+ messages in thread] Some question 2010-03-31 15:46 UTC Ľubomír Varga <luvar@plaintext.sk> ` Re: Some question 2010-04-06 18:45 UTC Scott Marlowe <scott.marlowe@gmail.com> ` Re: Some question 2010-04-06 22:11 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov> ` Re: Some question 2010-04-07 07:18 UTC Yeb Havinga <yebhavinga@gmail.com> ` Re: Some question 2010-04-10 21:42 UTC Ľubomír Varga <luvar@plaintext.sk> ` Re: Some question 2010-04-11 12:44 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov> [6+ messages in thread] Re: About “context-switching issue on Xeon” test case ？ 2010-04-10 04:02 UTC Greg Smith <greg@2ndquadrant.com> ` Re: About “context-switching issue on Xeon” test case ？ 2010-04-11 02:22 UTC Greg Smith <greg@2ndquadrant.com> [2+ messages in thread] 3ware vs. MegaRAID 2010-03-30 13:20 UTC Ireneusz Pluta <ipluta@wp.pl> ` Re: 3ware vs. MegaRAID 2010-03-30 16:30 UTC Matteo Beccati <php@beccati.com> ` Re: 3ware vs. MegaRAID 2010-03-30 17:18 UTC Greg Smith <greg@2ndquadrant.com> ` Re: 3ware vs. MegaRAID 2010-03-31 12:43 UTC Matteo Beccati <php@beccati.com> ` Re: 3ware vs. MegaRAID 2010-03-31 16:59 UTC Francisco Reyes <lists@stringsutils.com> ` Re: 3ware vs. MegaRAID 2010-04-06 16:49 UTC Ireneusz Pluta <ipluta@wp.pl> ` Re: 3ware vs. MegaRAID 2010-04-08 03:29 UTC Scott Carey <scott@richrelevance.com> ` Re: 3ware vs. MegaRAID 2010-04-08 03:44 UTC Dave Crooke <dcrooke@gmail.com> ` Re: 3ware vs. MegaRAID 2010-04-08 06:13 UTC Greg Smith <greg@2ndquadrant.com> ` Re: 3ware vs. MegaRAID 2010-04-09 03:28 UTC Scott Carey <scott@richrelevance.com> ` Re: 3ware vs. MegaRAID 2010-04-09 06:32 UTC Jesper Krogh <jesper@krogh.cc> ` Re: 3ware vs. MegaRAID 2010-04-09 15:27 UTC Greg Smith <greg@2ndquadrant.com> ` Re: 3ware vs. MegaRAID 2010-04-09 16:11 UTC Jesper Krogh <jesper@krogh.cc> ` Re: 3ware vs. MegaRAID 2010-04-09 18:22 UTC Greg Smith <greg@2ndquadrant.com> ` Re: 3ware vs. MegaRAID 2010-04-09 19:02 UTC Jesper Krogh <jesper@krogh.cc> ` Re: 3ware vs. MegaRAID 2010-04-09 19:12 UTC Scott Marlowe <scott.marlowe@gmail.com> [16+ messages in thread] About “context-switching issue on Xeon” test case ？ 2010-04-09 07:23 UTC RD黄永卫 <yongwei_huang@temp.gtmc.com.cn> Using high speed swap to improve performance? 2010-04-02 19:15 UTC Christiaan Willemsen <cwillemsen@technocon.com> ` Re: Using high speed swap to improve performance? 2010-04-02 19:53 UTC Arjen van der Meijden <acmmailing@tweakers.net> ` Re: Using high speed swap to improve performance? 2010-04-04 20:52 UTC Robert Haas <robertmhaas@gmail.com> ` Re: Using high speed swap to improve performance? 2010-04-04 20:53 UTC Robert Haas <robertmhaas@gmail.com> ` Re: Using high speed swap to improve performance? 2010-04-04 21:07 UTC Scott Marlowe <scott.marlowe@gmail.com> ` Re: Using high speed swap to improve performance? 2010-04-04 21:17 UTC Lew <noone@lwsc.ehost-services.com> ` Re: Using high speed swap to improve performance? 2010-04-05 14:55 UTC Greg Smith <greg@2ndquadrant.com> ` Re: Using high speed swap to improve performance? 2010-04-06 07:38 UTC Christiaan Willemsen <cwillemsen@technocon.com> ` Re: Using high speed swap to improve performance? 2010-04-06 18:48 UTC Scott Marlowe <scott.marlowe@gmail.com> ` Re: Using high speed swap to improve performance? 2010-04-07 22:09 UTC Lew <noone@lwsc.ehost-services.com> [10+ messages in thread] indexes in partitioned tables - again 2010-04-06 21:37 UTC Samuel Gendler <sgendler@ideasculptor.com> ` Re: indexes in partitioned tables - again 2010-04-07 21:13 UTC Robert Haas <robertmhaas@gmail.com> [2+ messages in thread] query slow; strace output worrisome 2010-04-06 01:01 UTC Brian Cox <brian.cox@ca.com> ` Re: query slow; strace output worrisome 2010-04-06 01:53 UTC Craig Ringer <craig@postnewspapers.com.au> ` Re: query slow; strace output worrisome 2010-04-06 04:04 UTC Brian Cox <brian.cox@ca.com> ` Re: query slow; strace output worrisome 2010-04-06 05:18 UTC Craig Ringer <craig@postnewspapers.com.au> ` Re: query slow; strace output worrisome 2010-04-06 16:24 UTC Brian Cox <brian.cox@ca.com> ` Re: query slow; strace output worrisome 2010-04-07 02:32 UTC Craig Ringer <craig@postnewspapers.com.au> ` Re: query slow; strace output worrisome 2010-04-07 18:39 UTC Robert Haas <robertmhaas@gmail.com> [7+ messages in thread] LIMIT causes planner to do Index Scan using a less optimal index 2010-04-02 18:19 UTC Joel Jacobson <joel@gluefinance.com> ` Re: LIMIT causes planner to do Index Scan using a less optimal index 2010-04-06 18:33 UTC Robert Haas <robertmhaas@gmail.com> ` Re: LIMIT causes planner to do Index Scan using a less optimal index 2010-04-06 22:30 UTC Joel Jacobson <joel@gluefinance.com> ` Re: LIMIT causes planner to do Index Scan using a less optimal index 2010-04-07 00:22 UTC Robert Haas <robertmhaas@gmail.com> ` Re: LIMIT causes planner to do Index Scan using a less optimal index 2010-04-07 12:20 UTC Sherry.CTR.Zhu@faa.gov ` Re: LIMIT causes planner to do Index Scan using a less optimal index 2010-04-07 12:51 UTC Grzegorz Jaśkiewicz <gryzman@gmail.com> ` Re: LIMIT causes planner to do Index Scan using a less optimal index 2010-04-07 13:08 UTC Sherry.CTR.Zhu@faa.gov ` Re: LIMIT causes planner to do Index Scan using a less optimal index 2010-04-07 13:12 UTC Grzegorz Jaśkiewicz <gryzman@gmail.com> ` Re: LIMIT causes planner to do Index Scan using a less optimal index 2010-04-07 13:22 UTC Sherry.CTR.Zhu@faa.gov ` Re: LIMIT causes planner to do Index Scan using a less optimal index 2010-04-07 13:36 UTC Matthew Wakeling <matthew@flymine.org> ` Re: LIMIT causes planner to do Index Scan using a less optimal index 2010-04-07 15:52 UTC Joel Jacobson <joel@gluefinance.com> [11+ messages in thread] Huge table searching optimization 2010-04-05 14:28 UTC Oliver Kindernay <oliver.kindernay@gmail.com> ` Re: Huge table searching optimization 2010-04-05 14:32 UTC hubert depesz lubaczewski <depesz@depesz.com> ` Re: Huge table searching optimization 2010-04-05 16:10 UTC Andres Freund <andres@anarazel.de> ` Re: Huge table searching optimization 2010-04-05 16:22 UTC Tom Lane <tgl@sss.pgh.pa.us> ` Re: Huge table searching optimization 2010-04-05 17:11 UTC Oliver Kindernay <oliver.kindernay@gmail.com> [5+ messages in thread] How to fast the REINDEX 2010-03-31 20:51 UTC raghavendra t <raagavendra.rao@gmail.com> ` Re: How to fast the REINDEX 2010-03-31 21:02 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov> ` Re: How to fast the REINDEX 2010-03-31 21:33 UTC raghavendra t <raagavendra.rao@gmail.com> ` Re: How to fast the REINDEX 2010-03-31 21:40 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov> ` Re: How to fast the REINDEX 2010-03-31 21:47 UTC raghavendra t <raagavendra.rao@gmail.com> ` Re: How to fast the REINDEX 2010-03-31 21:51 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov> ` Re: How to fast the REINDEX 2010-03-31 22:00 UTC raghavendra t <raagavendra.rao@gmail.com> ` Re: How to fast the REINDEX 2010-03-31 22:10 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov> ` Re: How to fast the REINDEX 2010-03-31 22:25 UTC Jaime Casanova <jcasanov@systemguards.com.ec> ` Re: How to fast the REINDEX 2010-03-31 22:57 UTC raghavendra t <raagavendra.rao@gmail.com> ` Re: How to fast the REINDEX 2010-04-01 03:11 UTC Craig Ringer <craig@postnewspapers.com.au> ` Re: How to fast the REINDEX 2010-04-01 10:54 UTC Hannu Krosing <hannu@2ndquadrant.com> ` Re: How to fast the REINDEX 2010-04-01 11:10 UTC Steve Clark <sclark@netwolves.com> ` Re: How to fast the REINDEX 2010-04-01 11:36 UTC Greg Smith <greg@2ndquadrant.com> ` Re: How to fast the REINDEX 2010-04-01 12:25 UTC Pierre C <lists@peufeu.com> ` Re: How to fast the REINDEX 2010-04-01 13:47 UTC raghavendra t <raagavendra.rao@gmail.com> ` Re: How to fast the REINDEX 2010-04-01 13:52 UTC Brad Nicholson <bnichols@ca.afilias.info> ` Re: How to fast the REINDEX 2010-04-01 14:19 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov> ` Re: How to fast the REINDEX 2010-04-05 16:54 UTC Robert Haas <robertmhaas@gmail.com> [19+ messages in thread] temp table "on commit delete rows": transaction overhead 2010-03-30 11:46 UTC Artiom Makarov <artiom.makarov@gmail.com> ` Re: temp table "on commit delete rows": transaction overhead 2010-03-30 17:50 UTC Tom Lane <tgl@sss.pgh.pa.us> ` Re: temp table "on commit delete rows": transaction overhead 2010-03-31 07:42 UTC Artiom Makarov <artiom.makarov@gmail.com> ` Re: temp table "on commit delete rows": transaction overhead 2010-04-01 00:44 UTC Bruce Momjian <bruce@momjian.us> ` Re: temp table "on commit delete rows": transaction overhead 2010-04-05 07:56 UTC Artiom Makarov <artiom.makarov@gmail.com> ` Re: temp table "on commit delete rows": transaction overhead 2010-04-05 12:09 UTC Bruce Momjian <bruce@momjian.us> [6+ messages in thread] ERROR: cache lookup failed for relation X 2010-04-03 16:38 UTC raghavendra t <raagavendra.rao@gmail.com> ` Re: ERROR: cache lookup failed for relation X 2010-04-03 17:04 UTC justin@magwerks.com <justin@magwerks.com> ` Re: ERROR: cache lookup failed for relation X 2010-04-03 17:05 UTC Tom Lane <tgl@sss.pgh.pa.us> ` Re: ERROR: cache lookup failed for relation X 2010-04-04 02:50 UTC raghavendra t <raagavendra.rao@gmail.com> ` Re: ERROR: cache lookup failed for relation X 2010-04-04 02:52 UTC raghavendra t <raagavendra.rao@gmail.com> [5+ messages in thread] How much memory is PostgreSQL using 2010-03-29 14:59 UTC Campbell, Lance <lance@illinois.edu> ` Re: How much memory is PostgreSQL using 2010-03-29 16:53 UTC Greg Smith <greg@2ndquadrant.com> ` Re: How much memory is PostgreSQL using 2010-04-02 20:10 UTC Campbell, Lance <lance@illinois.edu> ` Re: How much memory is PostgreSQL using 2010-04-03 11:58 UTC Guillaume Lelarge <guillaume@lelarge.info> [4+ messages in thread] David Crooke wants to stay in touch on LinkedIn 2010-04-03 05:05 UTC David Crooke <dcrooke@gmail.com> Does the psql executable support a "fetch many" approach when dumping large queries to stdout? 2010-04-02 20:28 UTC Beaver, John E <John_Beaver@hms.harvard.edu> ` Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout? 2010-04-02 22:18 UTC Hannu Krosing <hannu@2ndquadrant.com> ` Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout? 2010-04-02 22:18 UTC John Beaver <john_beaver@hms.harvard.edu> [3+ messages in thread] Database size growing over time and leads to performance impact 2010-03-27 13:00 UTC Gnanakumar <gnanam@zoniac.com> ` Re: Database size growing over time and leads to performance impact 2010-03-27 13:35 UTC Pierre C <lists@peufeu.com> ` Re: Database size growing over time and leads to performance impact 2010-03-27 13:35 UTC Andy Colson <andy@squeakycode.net> ` Re: Database size growing over time and leads to performance impact 2010-03-27 13:47 UTC Tomeh, Husam <HTomeh@facorelogic.com> ` Re: Database size growing over time and leads to performance impact 2010-03-27 14:41 UTC Guillaume Lelarge <guillaume@lelarge.info> ` Re: [PERFORM] Database size growing over time and leads to performance impact 2010-03-29 04:12 UTC Greg Smith <greg@2ndquadrant.com> ` Re: Database size growing over time and leads to performance impact 2010-03-29 04:21 UTC Greg Smith <greg@2ndquadrant.com> ` Re: Database size growing over time and leads to performance impact 2010-03-30 11:17 UTC Gnanakumar <gnanam@zoniac.com> ` Re: Database size growing over time and leads to performance impact 2010-03-30 13:50 UTC Andy Colson <andy@squeakycode.net> ` Re: Database size growing over time and leads to performance impact 2010-03-31 20:37 UTC Scott Carey <scott@richrelevance.com> ` Re: Database size growing over time and leads to performance impact 2010-03-31 20:47 UTC Robert Haas <robertmhaas@gmail.com> ` Re: Database size growing over time and leads to performance impact 2010-03-31 20:47 UTC Alvaro Herrera <alvherre@commandprompt.com> ` Re: Database size growing over time and leads to performance impact 2010-04-01 20:08 UTC Scott Carey <scott@richrelevance.com> ` Re: Database size growing over time and leads to performance impact 2010-04-01 20:42 UTC Tom Lane <tgl@sss.pgh.pa.us> ` Re: Database size growing over time and leads to performance impact 2010-04-01 21:00 UTC Scott Carey <scott@richrelevance.com> [15+ messages in thread] experiments in query optimization 2010-03-25 19:57 UTC Faheem Mitha <faheem@email.unc.edu> ` Re: experiments in query optimization 2010-03-29 18:02 UTC Robert Haas <robertmhaas@gmail.com> ` Re: experiments in query optimization 2010-03-29 18:31 UTC Faheem Mitha <faheem@email.unc.edu> ` Re: experiments in query optimization 2010-03-29 19:55 UTC Robert Haas <robertmhaas@gmail.com> ` Re: experiments in query optimization 2010-03-29 20:22 UTC Faheem Mitha <faheem@email.unc.edu> ` Re: experiments in query optimization 2010-03-30 16:08 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov> ` Re: experiments in query optimization 2010-03-30 16:30 UTC Faheem Mitha <faheem@email.unc.edu> ` Re: experiments in query optimization 2010-03-30 17:19 UTC Faheem Mitha <faheem@email.unc.edu> ` Re: experiments in query optimization 2010-03-30 19:59 UTC Robert Haas <robertmhaas@gmail.com> ` Re: experiments in query optimization 2010-03-31 09:29 UTC Matthew Wakeling <matthew@flymine.org> ` Re: experiments in query optimization 2010-03-31 09:36 UTC Faheem Mitha <faheem@email.unc.edu> ` Re: experiments in query optimization 2010-03-31 10:10 UTC Faheem Mitha <faheem@email.unc.edu> ` Re: experiments in query optimization 2010-03-31 15:04 UTC Robert Haas <robertmhaas@gmail.com> ` Re: experiments in query optimization 2010-04-01 11:46 UTC Faheem Mitha <faheem@email.unc.edu> ` Re: experiments in query optimization 2010-04-01 16:31 UTC Eliot Gable <egable+pgsql-performance@gmail.com> ` Re: experiments in query optimization 2010-04-01 18:15 UTC Faheem Mitha <faheem@email.unc.edu> ` Re: experiments in query optimization 2010-04-01 18:50 UTC Robert Haas <robertmhaas@gmail.com> ` Re: experiments in query optimization 2010-04-01 19:01 UTC Faheem Mitha <faheem@email.unc.edu> ` Re: experiments in query optimization 2010-04-01 19:29 UTC Eliot Gable <egable+pgsql-performance@gmail.com> ` Re: experiments in query optimization 2010-04-01 19:32 UTC Faheem Mitha <faheem@email.unc.edu> [20+ messages in thread] query has huge variance in execution times 2010-03-31 04:11 UTC Brian Cox <brian.cox@ca.com> ` Re: query has huge variance in execution times 2010-03-31 04:37 UTC David Wilson <david.t.wilson@gmail.com> ` Re: query has huge variance in execution times 2010-03-31 18:10 UTC Brian Cox <brian.cox@ca.com> ` Re: query has huge variance in execution times 2010-03-31 18:44 UTC David Wilson <david.t.wilson@gmail.com> [4+ 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