From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
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-02 18:32:28
Message-ID:
AANLkTin7A_Q=Yc9Wf_5=POp2mVqmaiwqUDsFMLG68H45@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 1:19 PM, Jon Nelson <jnelson+pgsql(at)jamponi(dot)net> wrote:
> However, sometimes using an index results in a HORRIBLE HORRIBLE plan.
> I recently encountered the issue myself, and plopping an ANALYZE
> $tablename in there, since I was using a temporary table anyway, make
> all the difference. The planner switched from an index-based query to
> a sequential scan, and a sequential scan was (is) vastly more
> efficient in this particular case.
Yep...
> Personally, I'd get rid of autovacuum/autoanalyze support on temporary
> tables
We don't have any such support, which I think is the root of Mladen's complaint.
> (they typically have short lives and are often accessed
> immediately after creation preventing the auto* stuff from being
> useful anyway), *AND* every time I ask I'm always told "make sure
> ANALYZE the table before you use it".
Yeah. Any kind of bulk load into an empty table can be a problem,
even if it's not temporary. When you load a bunch of data and then
immediately plan a query against it, autoanalyze hasn't had a chance
to do its thing yet, so sometimes you get a lousy plan. In the case
of temporary tables, this can happen even if there's a delay before
you use the data. Some sort of fix for this - where the first query
that needs the stats does an analyze first - seems like it could be
quite useful (although it would suck if the transaction that took it
upon itself to do the analyze then rolled back, losing the stats and
forcing the next guy to do it all over again).
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
In response to
Responses
pgsql-performance by date
Next :From: Greg SmithDate: 2011-02-02 18:47:21Subject : Re: [HACKERS] Slow count(*) again...Previous :From : Kenneth MarshallDate : 2011-02-02 18:32:17Subject : Re: Server Configuration
pgsql-hackers by date
Next :From: Dimitri FontaineDate: 2011-02-02 18:39:49Subject : Re: ALTER EXTENSION UPGRADE, v3Previous :From : David E. WheelerDate : 2011-02-02 18:29:28Subject : Re: ALTER EXTENSION UPGRADE, v3
