From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Greg Smith <greg(at)2ndquadrant(dot)com>
Cc:
Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>, 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-03 02:01:07
Message-ID:
AANLkTik1TqM4cBKGm--pfZZ8p7j-70-Z6ocbJTRGDNfo@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 Wed, Feb 2, 2011 at 7:03 PM, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> Given limited resources as a development community, it's hard to justify
> working on hinting--which has its own complexity to do right--when there are
> so many things that I think are more likely to help *everyone* that could be
> done instead. The unfortunate situation we're in, unlike Oracle, is that
> there isn't a practically infinite amount of money available to fund every
> possible approach here, then see which turn out to work later after our
> customers suffer through the bad ones for a while.
There are actually very few queries where I actually want to force the
planner to use a particular index, which is the sort of thing Oracle
lets you do. If it's a simple query and
random_page_cost/seq_page_cost are reasonably well adjusted, the
planner's choice is very, very likely to be correct. If it's a
complex query, the planner has more likelihood of going wrong, but
forcing it to use an index on one table isn't going to help much if
that table is being used on the inner side of a hash join. You almost
need to be able to force the entire plan into the shape you've chosen,
and that's a lot of work and not terribly robust. The most common
type of "hard to fix" query problem - by far - is a bad selectivity
estimate. Being able to hint that would be worth more than any number
of hints about which indexes to use, in my book.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
In response to
pgsql-performance by date
Next :From: Marcos OrtizDate: 2011-02-03 02:19:12Subject : Re: Server ConfigurationPrevious :From : Craig RingerDate : 2011-02-03 02:00:33Subject : Re: Which RAID Controllers to pick/avoid?
pgsql-hackers by date
Next :From: Robert HaasDate: 2011-02-03 02:12:10Subject : Re: log_checkpoints and restartpointPrevious :From : Itagaki TakahiroDate : 2011-02-03 01:16:21Subject : Re: log_checkpoints and restartpoint
