From:
Samuel Gendler <sgendler(at)ideasculptor(dot)com>
To:
Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
Cc:
Andrew Dunstan <andrew(at)dunslane(dot)net>, Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "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>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject:
Re: [HACKERS] Slow count(*) again...
Date:
2011-02-02 03:13:38
Message-ID:
AANLkTikftsY8=sFf9X6XD6B37-LBHykHzY4ByMPNRZFA@mail.gmail.com (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
On Tue, Feb 1, 2011 at 3:44 PM, Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>wrote:
> On 2/1/2011 6:03 PM, Andrew Dunstan wrote:
>
>> 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.
>>
>
> There are many other things to fix first. One of them would be optimizer
> decisions when a temp table is involved. I would also vote for wait event
> interface, tracing and hints, much rather than speeding up count(*). World
> domination will not be achieved by speeding up count(*), it will be achieved
> by providing overall performance akin to what the player who has already
> achieved the world domination. I believe that the company is called "Oracle
> Corp." or something like that?
>
>
> Mladen Gogala
> Sr. Oracle DBA
>
Don't listen to him. He's got an oracle bias. Slashdot already announced
that NoSQL is actually going to dominate the world, so postgres has already
lost that battle. Everything postgres devs do now is just an exercise in
relational masturbation. Trust me.
In response to
Responses
pgsql-performance by date
Next :From: Mladen GogalaDate: 2011-02-02 03:40:16Subject : Re: [HACKERS] Slow count(*) again...Previous :From : Greg SmithDate : 2011-02-02 01:30:20Subject : Re: Are we in the ballpark?
pgsql-hackers by date
Next :From: Luis OchoaDate: 2011-02-02 03:25:34Subject : A postgres parser related questionPrevious :From : Mladen GogalaDate : 2011-02-01 23:44:17Subject : Re: [HACKERS] Slow count(*) again...
