From:
Greg Smith <greg(at)2ndquadrant(dot)com>
To:
Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
Cc:
Robert Haas <robertmhaas(at)gmail(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-02 18:47:21
Message-ID:
4D49A6B9.4060608@2ndquadrant.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
Mladen Gogala wrote:
> People are complaining about the optimizer not using the indexes all
> over the place, there should be a way to
> make the optimizer explicitly prefer the indexes, like was the case
> with Oracle's venerable RBO (rules based
> optimizer). RBO didn't use statistics, it had a rank of access method
> and used the access method with the highest
> rank of all available access methods. In practice, it translated into:
> if an index exists - use it.
Given that even Oracle kicked out the RBO a long time ago, I'm not so
sure longing for those good old days will go very far. I regularly see
queries that were tweaked to always use an index run at 1/10 or less the
speed of a sequential scan against the same data. The same people
complaining "all over the place" about this topic are also the sort who
write them. There are two main fallacies at play here that make this
happen:
1) Even if you use an index, PostgreSQL must still retrieve the
associated table data to execute the query in order to execute its
version of MVCC
2) The sort of random I/O done by index lookups can be as much as 50X as
expensive on standard hard drives as sequential, if every block goes to
physical hardware.
If I were to work on improving this area, it would be executing on some
plans a few of us have sketched out for exposing some notion about what
indexes are actually in memory to the optimizer. There are more obvious
fixes to the specific case of temp tables though.
--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
In response to
Responses
pgsql-performance by date
Next :From: Greg SmithDate: 2011-02-02 18:58:48Subject : Re: Exhaustive list of what takes what locksPrevious :From : Robert HaasDate : 2011-02-02 18:32:28Subject : Re: [HACKERS] Slow count(*) again...
pgsql-hackers by date
Next :From: John R PierceDate: 2011-02-02 19:06:01Subject : Re: Why "copy ... from stdio" does not return immediately
when reading invalid data?Previous :From : Dimitri FontaineDate : 2011-02-02 18:39:49Subject : Re: ALTER EXTENSION UPGRADE, v3
