From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc:
Bruce Momjian <bruce(at)momjian(dot)us>,
Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>,
"david(at)lang(dot)hm" <david(at)lang(dot)hm>,
Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>,
Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>,
PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject:
Re: [PERFORM] Slow count(*) again...
Date:
2011-02-01 23:12:44
Message-ID:
5100.1296601964@sss.pgh.pa.us (view raw or flat )
Thread:
2010-10-09 23:26:18 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-10 01:47:34 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2010-10-10 03:02:12 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-10 06:56:15 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2010-10-10 10:29:42 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-10 15:02:32 from Reid Thompson <reid(dot)thompson(at)ateb(dot)com>
2010-10-10 18:33:04 from Reid Thompson <reid(dot)thompson(at)ateb(dot)com>
2010-10-10 15:30:09 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2010-10-10 12:02:03 from Віталій Тимчишин <tivv00(at)gmail(dot)com>
2010-10-10 21:59:48 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-11 17:46:17 from Craig James <craig_james(at)emolecules(dot)com>
2010-10-11 19:54:57 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-11 20:58:37 from Mladen Gogala <mgogala(at)vmsinfo(dot)com>
2010-10-11 22:03:38 from Samuel Gendler <sgendler(at)ideasculptor(dot)com>
2010-10-11 23:50:36 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-12 02:36:45 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-12 13:56:33 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-10-12 14:19:57 from Joe Uhl <joeuhl(at)gmail(dot)com>
2010-10-12 15:48:34 from david(at)lang(dot)hm
2010-10-12 22:21:31 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-12 21:35:01 from "Pierre C" <lists(at)peufeu(dot)com>
2010-10-12 22:30:38 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-12 23:19:33 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-13 07:46:25 from "Pierre C" <lists(at)peufeu(dot)com>
2010-10-12 07:56:13 from Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
2010-10-12 08:14:58 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2010-10-12 08:22:39 from david(at)lang(dot)hm
2010-10-12 11:44:59 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2010-10-12 15:54:24 from david(at)lang(dot)hm
2010-10-12 16:46:08 from Scott Carey <scott(at)richrelevance(dot)com>
2010-10-12 16:50:40 from Scott Carey <scott(at)richrelevance(dot)com>
2010-10-13 10:41:52 from Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
2010-10-12 12:27:26 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-12 13:07:46 from Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
2010-10-12 13:18:34 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-10-12 13:20:14 from Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
2010-10-12 15:29:22 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-10-12 13:19:52 from Luca Tettamanti <kronos(dot)it(at)gmail(dot)com>
2010-10-12 13:55:39 from Mladen Gogala <mgogala(at)vmsinfo(dot)com>
2010-10-12 13:56:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-12 14:04:18 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-12 17:07:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-12 18:22:01 from Jesper Krogh <jesper(at)krogh(dot)cc>
2010-10-12 18:58:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-13 10:54:19 from Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
2010-10-21 04:47:24 from Scott Carey <scott(at)richrelevance(dot)com>
2010-10-21 18:13:24 from Jesper Krogh <jesper(at)krogh(dot)cc>
2010-10-21 23:11:22 from Scott Carey <scott(at)richrelevance(dot)com>
2010-10-13 06:45:16 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-01 22:47:06 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-01 23:03:39 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-02-01 23:12:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-02-02 16:03:37 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-01 23:44:17 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-02 03:13:38 from Samuel Gendler <sgendler(at)ideasculptor(dot)com>
2011-02-02 03:40:16 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-02 04:07:47 from Samuel Gendler <sgendler(at)ideasculptor(dot)com>
2011-02-02 17:19:08 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-02 18:11:33 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-02 18:19:20 from Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
2011-02-02 18:32:28 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-03 09:54:49 from Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
2011-02-03 10:11:58 from david(at)lang(dot)hm
2011-02-03 13:41:42 from Kenneth Marshall <ktm(at)rice(dot)edu>
2011-02-03 14:20:01 from Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
2011-02-03 15:35:43 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-03 20:54:02 from david(at)lang(dot)hm
2011-02-03 22:35:12 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-02-03 23:29:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-04 00:29:22 from Jeremy Harris <jgh(at)wizmail(dot)org>
2011-02-04 00:39:12 from david(at)lang(dot)hm
2011-02-04 01:29:14 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-04 01:37:14 from david(at)lang(dot)hm
2011-02-04 02:05:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-04 02:12:57 from Conor Walsh <ctw(at)adverb(dot)ly>
2011-02-04 02:33:30 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2011-02-04 02:45:09 from Conor Walsh <ctw(at)adverb(dot)ly>
2011-02-04 03:31:35 from Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
2011-02-04 15:41:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-02-05 01:50:13 from Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
2011-02-10 17:51:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-04 03:13:22 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2011-02-04 05:06:18 from David Wilson <david(dot)t(dot)wilson(at)gmail(dot)com>
2011-02-04 06:36:20 from Samuel Gendler <sgendler(at)ideasculptor(dot)com>
2011-02-04 14:52:20 from Kenneth Marshall <ktm(at)rice(dot)edu>
2011-02-04 14:33:15 from Kenneth Marshall <ktm(at)rice(dot)edu>
2011-02-04 14:38:30 from Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
2011-02-04 18:48:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-05 05:46:30 from david(at)lang(dot)hm
2011-02-05 06:37:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-05 08:38:40 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2011-02-05 08:49:05 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-02-04 07:08:59 from Віталій Тимчишин <tivv00(at)gmail(dot)com>
2011-02-04 07:32:47 from david(at)lang(dot)hm
2011-02-04 07:39:38 from Віталій Тимчишин <tivv00(at)gmail(dot)com>
2011-02-04 07:59:06 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-02-03 15:31:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-03 15:43:47 from Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
2011-02-02 18:20:59 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-02 18:47:21 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-02-02 20:54:26 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-02 21:11:25 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-02 21:14:06 from Kenneth Marshall <ktm(at)rice(dot)edu>
2011-02-02 21:59:50 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-02 21:25:00 from Justin Pitts <justinpitts(at)gmail(dot)com>
2011-02-02 22:03:28 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-03 00:29:20 from Justin Pitts <justinpitts(at)gmail(dot)com>
2011-02-03 00:03:06 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-02-03 00:13:44 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-03 02:01:07 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-03 02:45:19 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-03 06:16:36 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-02-03 16:38:14 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-03 16:56:56 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-03 17:28:29 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-03 17:46:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-02-03 16:57:30 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-03 17:10:06 from Shaun Thomas <sthomas(at)peak6(dot)com>
2011-02-03 21:01:40 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-03 21:18:41 from Chris Browne <cbbrowne(at)acm(dot)org>
2011-02-03 21:50:20 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-03 22:04:06 from Ben Chobot <bench(at)silentmedia(dot)com>
2011-02-03 22:05:50 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2011-02-04 03:01:10 from Jeff Davis <pgsql(at)j-davis(dot)com>
2011-02-04 23:17:12 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-03 22:08:00 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-02-03 22:12:07 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-03 22:13:09 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-04 07:24:20 from Віталій Тимчишин <tivv00(at)gmail(dot)com>
2011-02-03 22:17:06 from Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
2011-02-03 22:40:17 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-04 14:55:01 from Nick Lello <nick(dot)lello(at)rentrakmail(dot)com>
2011-02-03 22:19:04 from Michael Glaesemann <grzm(at)seespotcode(dot)net>
2011-02-03 21:29:25 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-02-03 21:34:19 from Shaun Thomas <sthomas(at)peak6(dot)com>
2011-02-03 22:03:07 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-03 22:09:33 from Maciek Sakrejda <msakrejda(at)truviso(dot)com>
2011-02-03 22:39:06 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-03 23:00:37 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-02-03 23:25:02 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-10 15:50:40 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-10 16:45:20 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-02-10 17:01:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-02-10 17:09:18 from Shaun Thomas <sthomas(at)peak6(dot)com>
2011-02-10 17:56:10 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-02-10 18:26:44 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-02-10 17:19:34 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-10 17:27:18 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-02-10 17:02:58 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-10 17:25:37 from Chris Browne <cbbrowne(at)acm(dot)org>
2011-02-13 20:40:09 from Rob Wultsch <wultsch(at)gmail(dot)com>
2011-02-13 22:29:32 from Josh Berkus <josh(at)agliodbs(dot)com>
2011-02-13 22:52:22 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2011-02-14 07:01:37 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2011-02-10 17:06:42 from Shaun Thomas <sthomas(at)peak6(dot)com>
2011-02-10 17:21:51 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-02-10 17:30:46 from Shaun Thomas <sthomas(at)peak6(dot)com>
2011-02-10 17:44:29 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-02-10 18:32:31 from Craig James <craig_james(at)emolecules(dot)com>
2011-06-06 08:14:43 from Robert Klemme <shortcutter(at)googlemail(dot)com>
2011-02-16 21:22:26 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-23 02:22:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-06-05 15:25:39 from pasman pasmański <pasman(dot)p(at)gmail(dot)com>
2011-02-10 20:55:29 from Tobias Brox <tobixen(at)gmail(dot)com>
2011-02-10 21:12:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-02-11 08:19:01 from Віталій Тимчишин <tivv00(at)gmail(dot)com>
2011-02-11 09:29:06 from Tobias Brox <tobixen(at)gmail(dot)com>
2011-02-11 09:44:05 from Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
2011-02-11 11:26:01 from Tobias Brox <tobixen(at)gmail(dot)com>
2011-02-11 11:33:22 from Andrea Suisani <sickpig(at)opinioni(dot)net>
2011-02-11 14:51:44 from "Pierre C" <lists(at)peufeu(dot)com>
2011-02-03 23:00:50 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-02-03 23:33:21 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-03 23:56:57 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2011-02-04 00:13:17 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-04 00:30:50 from Shaun Thomas <sthomas(at)peak6(dot)com>
2011-02-04 00:08:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-04 00:39:42 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-04 01:18:28 from Grant Johnson <grant(at)amadensor(dot)com>
2011-02-04 01:36:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-02-04 02:59:46 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2011-02-04 03:40:31 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-02-04 03:48:46 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2011-02-04 03:56:12 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-02-04 04:00:01 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2011-02-04 04:10:41 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-02-10 01:58:12 from Gorshkov <gorshkovlists(at)gmail(dot)com>
2011-02-04 13:05:33 from Grant Johnson <grant(at)amadensor(dot)com>
2011-02-04 16:05:32 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2011-02-05 00:17:10 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-05 04:45:05 from Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
2011-02-04 08:43:23 from Torsten Zühlsdorff <foo(at)meisterderspiele(dot)de>
2011-02-03 22:10:52 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2011-02-04 00:08:10 from Craig James <craig_james(at)emolecules(dot)com>
2011-02-03 21:51:24 from Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
2011-02-04 00:49:52 from Jeremy Harris <jgh(at)wizmail(dot)org>
2011-02-04 01:28:08 from Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
2011-02-03 17:27:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-02-03 17:44:23 from Chris Browne <cbbrowne(at)acm(dot)org>
2011-02-03 19:09:35 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2011-02-03 19:24:42 from "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
2011-02-03 18:17:08 from Greg Smith <greg(at)2ndquadrant(dot)com>
2011-02-04 22:58:17 from Bruce Momjian <bruce(at)momjian(dot)us>
2011-02-01 23:21:04 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-12 15:52:48 from david(at)lang(dot)hm
2010-10-12 17:36:46 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-12 08:34:22 from Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>
2010-10-12 16:35:46 from Scott Carey <scott(at)richrelevance(dot)com>
2010-10-10 01:54:15 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-10 02:10:38 from Joe Conway <mail(at)joeconway(dot)com>
2010-10-10 02:44:14 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-10 03:07:00 from Samuel Gendler <sgendler(at)ideasculptor(dot)com>
2010-10-10 07:14:18 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2010-10-10 17:14:22 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-10 22:41:16 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2010-10-11 00:27:53 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2010-10-11 00:51:43 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2010-10-11 03:14:43 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-11 03:21:54 from Joshua Tolley <eggyknap(at)gmail(dot)com>
2010-10-11 04:11:58 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2010-10-12 02:19:04 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-10-12 03:58:45 from Samuel Gendler <sgendler(at)ideasculptor(dot)com>
2010-10-12 04:06:07 from Scott Carey <scott(at)richrelevance(dot)com>
2010-10-12 04:21:59 from Samuel Gendler <sgendler(at)ideasculptor(dot)com>
2010-10-12 04:35:25 from david(at)lang(dot)hm
2010-10-12 16:02:39 from Scott Carey <scott(at)richrelevance(dot)com>
2010-10-12 16:23:06 from Samuel Gendler <sgendler(at)ideasculptor(dot)com>
2010-10-12 16:38:12 from Jesper Krogh <jesper(at)krogh(dot)cc>
2010-10-13 11:42:00 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
2010-10-12 16:03:57 from Chris Browne <cbbrowne(at)acm(dot)org>
2010-10-12 06:39:32 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-10-11 04:15:56 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-13 06:47:19 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-13 07:19:26 from Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
2010-10-13 08:38:38 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-13 08:50:23 from Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
2010-10-13 10:16:11 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-13 13:28:43 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-13 17:59:48 from Jesper Krogh <jesper(at)krogh(dot)cc>
2010-10-14 02:18:14 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-14 04:22:16 from "mark" <dvlhntr(at)gmail(dot)com>
2010-10-14 15:29:40 from Jesper Krogh <jesper(at)krogh(dot)cc>
2010-10-14 19:56:05 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-15 05:04:43 from Jesper Krogh <jesper(at)krogh(dot)cc>
2010-10-16 03:28:29 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-10-13 21:07:07 from Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
2010-10-13 13:27:34 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-13 20:19:06 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-13 19:09:22 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-10-13 08:44:09 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-13 21:48:21 from Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
2010-10-13 08:40:53 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-13 13:45:00 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2010-10-13 13:49:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-13 18:17:19 from Alex Hunsaker <badalex(at)gmail(dot)com>
2010-10-13 19:37:45 from david(at)lang(dot)hm
2010-10-10 22:50:22 from Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
2010-10-12 02:02:51 from Scott Carey <scott(at)richrelevance(dot)com>
2010-10-12 02:21:04 from Scott Carey <scott(at)richrelevance(dot)com>
2010-10-12 02:23:46 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-12 03:42:42 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-12 06:32:09 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-10-12 15:39:19 from Dan Harris <fbsd(at)drivefaster(dot)net>
2010-10-12 16:44:02 from Scott Carey <scott(at)richrelevance(dot)com>
2010-10-12 17:06:47 from Dan Harris <fbsd(at)drivefaster(dot)net>
2010-10-13 12:12:19 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-10-13 12:33:28 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
2010-10-13 13:02:21 from Greg Smith <greg(at)2ndquadrant(dot)com>
2010-10-15 08:36:26 from Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
2010-10-13 20:08:26 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-12 22:33:33 from Neil Whelchel <neil(dot)whelchel(at)gmail(dot)com>
2010-10-13 00:00:11 from Dan Harris <fbsd(at)drivefaster(dot)net>
2010-10-11 10:09:02 from "Pierre C" <lists(at)peufeu(dot)com>
2010-10-12 15:12:53 from bricklen <bricklen(at)gmail(dot)com>
2010-10-21 04:07:22 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-hackers pgsql-performance
Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> On 02/01/2011 05:47 PM, Bruce Momjian wrote:
>> Tom Lane wrote:
>>> At this point what we've got is 25% of the runtime in nodeAgg.c overhead,
>>> and it's difficult to see how to get any real improvement without tackling
>>> that.
>> Do we want a TODO about optimizing COUNT(*) to avoid aggregate
>> processing overhead?
> Whether or not it's bad application design, it's ubiquitous, and we
> should make it work as best we can, IMNSHO. This often generates
> complaints about Postgres, and if we really plan for world domination
> this needs to be part of it.
I don't think that saving ~25% on COUNT(*) runtime will help that at all.
The people who complain about it expect it to be instantaneous.
If this sort of hack were free, I'd be all for doing it anyway; but I'm
concerned that adding tests to enable a fast path will slow down every
other aggregate, or else duplicate a lot of code that we'll then have to
maintain.
regards, tom lane
In response to
Responses
pgsql-performance by date
Next :From: Mladen GogalaDate: 2011-02-01 23:21:04Subject : Re: [PERFORM] Slow count(*) again...Previous :From : Andrew DunstanDate : 2011-02-01 23:03:39Subject : Re: [PERFORM] Slow count(*) again...
pgsql-hackers by date
Next :From: Mladen GogalaDate: 2011-02-01 23:21:04Subject : Re: [PERFORM] Slow count(*) again...Previous :From : Thom BrownDate : 2011-02-01 23:08:55Subject : Re: Issues with generate_series using integer boundaries
