Re: count * performance issue

From:	"sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>
To:	"Dave Cramer" <pg(at)fastcrypt(dot)com>
Cc:	pgsql-performance(at)postgresql(dot)org
Subject:	Re: count * performance issue
Date:	2008-03-06 12:43:50
Message-ID:	f966c2ee0803060443j3d9c1b66x5f59e00d084e841c@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2008-03-06 05:43:01 from "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>  2008-03-06 05:48:19 from Chris <dmagick(at)gmail(dot)com>  2008-03-06 06:08:29 from "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>   2008-03-06 06:15:06 from "Shoaib Mir" <shoaibmir(at)gmail(dot)com>    2008-03-06 06:19:08 from "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>     2008-03-06 06:26:07 from "Shoaib Mir" <shoaibmir(at)gmail(dot)com>      2008-03-06 06:31:09 from "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>       2008-03-06 06:32:50 from "Shoaib Mir" <shoaibmir(at)gmail(dot)com>    2008-03-06 06:26:46 from Mark Mielke <mark(at)mark(dot)mielke(dot)cc>     2008-03-06 06:36:44 from "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>      2008-03-06 06:43:17 from "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>       2008-03-06 06:54:40 from "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>       2008-03-06 11:50:17 from Dave Cramer <pg(at)fastcrypt(dot)com>        2008-03-06 12:13:57 from Dave Cramer <pg(at)fastcrypt(dot)com>         2008-03-06 12:43:50 from "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>          2008-03-06 12:48:25 from "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>          2008-03-06 12:49:06 from "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>          2008-03-06 12:49:08 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>          2008-03-06 13:18:17 from Greg Smith <gsmith(at)gregsmith(dot)com>           2008-03-06 15:28:50 from Craig James <craig_james(at)emolecules(dot)com>            2008-03-06 15:33:25 from Bruce Momjian <bruce(at)momjian(dot)us>            2008-03-06 15:36:39 from "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>             2008-03-06 15:49:33 from Greg Smith <gsmith(at)gregsmith(dot)com>              2008-03-06 16:05:59 from "Dave Page" <dpage(at)pgadmin(dot)org>            2008-03-06 15:41:20 from Bill Moran <wmoran(at)collaborativefusion(dot)com>            2008-03-06 16:16:31 from "Mark Lewis" <mark(dot)lewis(at)mir3(dot)com>            2008-03-06 16:31:44 from "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>            2008-03-06 17:29:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2008-03-07 03:00:17 from Craig James <craig_james(at)emolecules(dot)com>              2008-03-07 05:38:48 from paul rivers <rivers(dot)paul(at)gmail(dot)com>              2008-03-07 23:51:19 from Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>              2008-03-13 04:55:18 from Craig James <craig_james(at)emolecules(dot)com>               2008-03-13 05:31:51 from "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>               2008-03-13 05:55:54 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>                2008-03-13 14:54:34 from Craig James <craig_james(at)emolecules(dot)com>                 2008-03-13 16:01:50 from Greg Smith <gsmith(at)gregsmith(dot)com>                  2008-03-13 21:06:18 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>                   2008-03-13 21:27:09 from Greg Smith <gsmith(at)gregsmith(dot)com>                    2008-03-14 15:16:02 from Michael Stone <mstone+postgres(at)mathom(dot)us>                   2008-03-13 22:53:04 from "justin" <justin(at)emproshunts(dot)com>                    2008-03-14 06:09:15 from "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>               2008-03-13 08:11:59 from "Justin Graf" <justin(at)emproshunts(dot)com>                2008-03-13 12:11:10 from Doug Knight <dknight(at)wsi(dot)com>                 2008-03-13 14:36:47 from Craig James <craig_james(at)emolecules(dot)com>                2008-03-13 13:11:06 from Will Weaver <will(at)myemma(dot)com>                 2008-03-13 13:55:55 from "Justin Graf" <justin(at)emproshunts(dot)com>                2008-03-13 14:29:23 from Craig James <craig_james(at)emolecules(dot)com>                 2008-03-13 21:09:26 from "justin" <justin(at)emproshunts(dot)com>                  2008-03-14 06:12:27 from "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>                   2008-03-14 06:17:10 from Jesper Krogh <jesper(at)krogh(dot)cc>                    2008-03-14 06:19:40 from "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>                     2008-03-14 06:23:28 from "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>                     2008-03-14 06:29:31 from Jesper Krogh <jesper(at)krogh(dot)cc>                     2008-03-14 08:31:29 from Justin <justin(at)emproshunts(dot)com>                      2008-03-14 08:19:25 from Greg Smith <gsmith(at)gregsmith(dot)com>                       2008-03-14 10:49:54 from Justin <justin(at)emproshunts(dot)com>                        2008-03-16 06:19:37 from Justin <justin(at)emproshunts(dot)com>                         2008-03-16 11:25:41 from Dave Cramer <pg(at)fastcrypt(dot)com>                          2008-03-16 19:04:44 from Craig James <craig_james(at)emolecules(dot)com>                           2008-03-16 19:08:06 from Craig James <craig_james(at)emolecules(dot)com>                           2008-03-16 19:36:33 from Dave Cramer <pg(at)fastcrypt(dot)com>                            2008-03-16 20:56:26 from "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>                            2008-03-17 07:36:58 from Justin <justin(at)emproshunts(dot)com>                             2008-03-17 07:14:03 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>                              2008-03-17 16:31:15 from Justin <justin(at)emproshunts(dot)com>                             2008-03-17 08:02:18 from "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>                             2008-03-17 09:11:26 from Tino Wildenhain <tino(at)wildenhain(dot)de>                           2008-03-17 18:50:36 from Justin <justin(at)emproshunts(dot)com>                            2008-03-17 18:12:03 from Dave Cramer <pg(at)fastcrypt(dot)com>                             2008-03-17 19:12:45 from Justin <justin(at)emproshunts(dot)com>                              2008-03-17 18:33:28 from Craig James <craig_james(at)emolecules(dot)com>                               2008-03-17 19:38:19 from Justin <justin(at)emproshunts(dot)com>                                2008-03-17 20:58:31 from Enrico Sirola <enrico(dot)sirola(at)gmail(dot)com>                                 2008-03-17 21:57:20 from "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>                                2008-03-18 07:08:58 from James Mansion <james(at)mansionfamily(dot)plus(dot)com>                           2008-03-18 11:04:21 from Michael Stone <mstone+postgres(at)mathom(dot)us>             2008-03-08 01:27:35 from Josh Berkus <josh(at)agliodbs(dot)com>              2008-03-08 01:38:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2008-03-08 05:08:39 from Greg Smith <gsmith(at)gregsmith(dot)com>                2008-03-08 06:13:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2008-03-10 15:16:08 from Gregory Stark <stark(at)enterprisedb(dot)com>                2008-03-10 20:54:23 from "Joe Mirabal" <jmmirabal(at)gmail(dot)com>                 2008-03-10 21:28:26 from Bill Moran <wmoran(at)collaborativefusion(dot)com>                  2008-03-10 21:52:40 from Greg Smith <gsmith(at)gregsmith(dot)com>                 2008-03-10 22:21:42 from "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>                 2008-03-10 23:01:43 from Greg Smith <gsmith(at)gregsmith(dot)com>                  2008-03-11 02:57:05 from "Robins Tharakan" <tharakan(at)gmail(dot)com>                   2008-03-11 03:01:51 from Mark Mielke <mark(at)mark(dot)mielke(dot)cc>                   2008-03-11 03:08:44 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>                   2008-03-11 03:11:27 from "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>                    2008-03-11 08:34:30 from Albert Cervera Areny <albert(at)sedifa(dot)com>                   2008-03-11 13:35:37 from Bill Moran <wmoran(at)collaborativefusion(dot)com>                    2008-03-11 13:57:03 from Matthew <matthew(at)flymine(dot)org>                     2008-03-11 14:01:06 from Tino Wildenhain <tino(at)wildenhain(dot)de>                      2008-03-11 14:19:09 from Matthew <matthew(at)flymine(dot)org>                       2008-03-11 14:31:18 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>                       2008-03-11 14:34:39 from Andrew Sullivan <ajs(at)crankycanuck(dot)ca>              2008-03-08 05:31:42 from Mark Mielke <mark(at)mark(dot)mielke(dot)cc>               2008-03-08 07:11:19 from paul rivers <rivers(dot)paul(at)gmail(dot)com>            2008-03-07 02:40:45 from Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>            2008-03-08 08:04:31 from Arjen van der Meijden <acmmailing(at)tweakers(dot)net>      2008-03-06 06:48:25 from "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>      2008-03-06 06:57:50 from "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>       2008-03-06 07:06:48 from "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>        2008-03-06 07:18:15 from "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>        2008-03-06 13:27:14 from Greg Smith <gsmith(at)gregsmith(dot)com>       2008-03-06 13:10:35 from Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
Lists:	pgsql-performance

In response to

• Re: count * performance issue at 2008-03-06 12:13:57 from Dave Cramer

Responses

• Re: count * performance issue at 2008-03-06 12:48:25 from Harald Armin Massa
• Re: count * performance issue at 2008-03-06 12:49:06 from A. Kretschmer
• Re: count * performance issue at 2008-03-06 12:49:08 from Alvaro Herrera
• Re: count * performance issue at 2008-03-06 13:18:17 from Greg Smith

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Harald Armin Massa	2008-03-06 12:48:25	Re: count * performance issue
Previous Message	Dave Cramer	2008-03-06 12:13:57	Re: count * performance issue