Re: Index Scans become Seq Scans after VACUUM ANALYSE

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Curt Sampson <cjs(at)cynic(dot)net>
Cc:	Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Michael Loftis <mloftis(at)wgops(dot)com>, mlw <markw(at)mohawksoft(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Index Scans become Seq Scans after VACUUM ANALYSE
Date:	2002-06-21 14:14:21
Message-ID:	19332.1024668861@sss.pgh.pa.us
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2002-04-16 14:03:53 from Louis-David Mitterrand <vindex(at)apartia(dot)org>  2002-04-16 14:41:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2002-04-16 15:04:58 from Louis-David Mitterrand <vindex(at)apartia(dot)org> 📎    2002-04-17 00:22:41 from Michael Loftis <mloftis(at)wgops(dot)com>     2002-04-17 00:31:13 from Michael Loftis <mloftis(at)wgops(dot)com>      2002-04-17 00:47:08 from Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>      2002-04-17 03:58:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2002-04-17 03:52:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2002-04-17 04:44:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2002-04-17 05:06:22 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>      2002-04-17 05:26:24 from mlw <markw(at)mohawksoft(dot)com>       2002-04-17 05:40:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>        2002-04-17 05:51:18 from mlw <markw(at)mohawksoft(dot)com>         2002-04-17 06:07:20 from Oliver Elphick <olly(at)lfix(dot)co(dot)uk>         2002-04-17 06:07:21 from Oliver Elphick <olly(at)lfix(dot)co(dot)uk>          2002-04-17 06:15:46 from mlw <markw(at)mohawksoft(dot)com>           2002-04-17 07:30:08 from "Luis Alberto Amigo Navarro" <lamigo(at)atc(dot)unican(dot)es>            2002-04-17 15:16:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>             2002-04-17 17:15:40 from Hannu Krosing <hannu(at)tm(dot)ee>              2002-04-17 17:28:04 from Hannu Krosing <hannu(at)tm(dot)ee>               2002-04-17 17:43:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2002-04-17 20:15:50 from Hannu Krosing <hannu(at)tm(dot)ee>                2002-04-18 07:37:46 from Adrian 'Dagurashibanipal' von Bidder <avbidder(at)fortytwo(dot)ch>                 2002-04-18 14:06:30 from mlw <markw(at)mohawksoft(dot)com>                  2002-04-19 06:41:52 from Curt Sampson <cjs(at)cynic(dot)net>             2002-04-18 01:49:03 from Mark Pritchard <mark(at)tangent(dot)net(dot)au> 📎              2002-04-18 01:51:38 from Mark Pritchard <mark(dot)pritchard(at)tangent(dot)net(dot)au>              2002-04-18 14:43:21 from Michael Loftis <mloftis(at)wgops(dot)com>               2002-04-18 14:56:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2002-04-18 16:10:37 from Michael Loftis <mloftis(at)wgops(dot)com>                 2002-04-19 00:18:31 from Michael Loftis <mloftis(at)wgops(dot)com>                2002-04-18 21:41:47 from Mark Pritchard <mark(at)tangent(dot)net(dot)au>          2002-04-17 09:44:46 from Michael Loftis <mloftis(at)wgops(dot)com>         2002-04-17 09:17:50 from Michael Loftis <mloftis(at)wgops(dot)com>         2002-04-17 14:15:26 from Thomas Lockhart <thomas(at)fourpalms(dot)org>          2002-04-17 14:24:04 from Michael Loftis <mloftis(at)wgops(dot)com>           2002-04-17 21:41:43 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>          2002-04-17 14:31:21 from mlw <markw(at)mohawksoft(dot)com>           2002-04-17 14:55:36 from Thomas Lockhart <thomas(at)fourpalms(dot)org>           2002-04-17 19:15:36 from "Rod Taylor" <rbt(at)zort(dot)ca>          2002-04-17 14:56:20 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>          2002-04-17 14:59:48 from Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>           2002-04-17 15:01:06 from Thomas Lockhart <thomas(at)fourpalms(dot)org>            2002-04-17 15:11:18 from Michael Loftis <mloftis(at)wgops(dot)com>            2002-04-17 15:22:37 from mlw <markw(at)mohawksoft(dot)com>             2002-04-17 16:10:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2002-04-17 16:35:13 from mlw <markw(at)mohawksoft(dot)com>               2002-04-17 17:45:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2002-04-17 17:49:16 from mlw <markw(at)mohawksoft(dot)com>                 2002-04-17 18:32:19 from Peter Eisentraut <peter_e(at)gmx(dot)net>                  2002-04-17 18:50:38 from mlw <markw(at)mohawksoft(dot)com>                2002-04-18 00:54:44 from Sean Chittenden <sean(at)chittenden(dot)org>               2002-04-17 18:08:58 from Andrew Sullivan <andrew(at)libertyrms(dot)info>                2002-04-17 18:41:28 from mlw <markw(at)mohawksoft(dot)com>                 2002-04-17 20:28:03 from mlw <markw(at)mohawksoft(dot)com>                  2002-04-17 20:55:26 from Andrew Sullivan <andrew(at)libertyrms(dot)info>                   2002-04-17 21:10:30 from mlw <markw(at)mohawksoft(dot)com>                    2002-04-17 21:13:04 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                  2002-04-17 20:56:06 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                   2002-04-17 21:16:23 from mlw <markw(at)mohawksoft(dot)com>                    2002-04-17 21:39:04 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                     2002-04-17 21:56:15 from mlw <markw(at)mohawksoft(dot)com>                   2002-04-17 21:44:13 from mlw <markw(at)mohawksoft(dot)com>                    2002-04-17 21:54:21 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                     2002-04-17 22:01:09 from mlw <markw(at)mohawksoft(dot)com>                      2002-04-17 22:04:09 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                    2002-04-17 21:55:14 from Doug McNaught <doug(at)wireboard(dot)com>                    2002-04-17 21:56:44 from "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>                     2002-04-17 22:05:54 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                    2002-04-18 14:35:50 from Michael Loftis <mloftis(at)wgops(dot)com>                     2002-04-19 06:58:11 from Curt Sampson <cjs(at)cynic(dot)net>                      2002-04-24 03:02:26 from mlw <markw(at)mohawksoft(dot)com>                       2002-04-24 04:38:06 from Curt Sampson <cjs(at)cynic(dot)net>                        2002-04-24 12:28:35 from mlw <markw(at)mohawksoft(dot)com>                         2002-04-25 04:12:10 from Curt Sampson <cjs(at)cynic(dot)net>                          2002-04-25 05:52:47 from Michael Loftis <mloftis(at)wgops(dot)com>                           2002-04-25 06:05:48 from Curt Sampson <cjs(at)cynic(dot)net>                            2002-04-25 15:34:28 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                             2002-04-25 18:13:40 from mlw <markw(at)mohawksoft(dot)com>                             2002-04-26 02:51:43 from Curt Sampson <cjs(at)cynic(dot)net>                              2002-06-21 01:58:15 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                               2002-06-21 02:18:14 from Curt Sampson <cjs(at)cynic(dot)net>                                2002-06-21 14:14:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                 2002-06-22 08:41:30 from Curt Sampson <cjs(at)cynic(dot)net>                               2002-06-22 22:22:58 from "J(dot) R(dot) Nield" <jrnield(at)usol(dot)com>                                2002-06-22 23:17:11 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                 2002-06-23 12:37:53 from "J(dot) R(dot) Nield" <jrnield(at)usol(dot)com>                                  2002-06-23 13:33:07 from Curt Sampson <cjs(at)cynic(dot)net>                                   2002-06-23 15:19:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                    2002-06-23 16:10:26 from Curt Sampson <cjs(at)cynic(dot)net>                                     2002-06-23 18:15:17 from "J(dot) R(dot) Nield" <jrnield(at)usol(dot)com>                                    2002-06-23 17:57:19 from "J(dot) R(dot) Nield" <jrnield(at)usol(dot)com>                                     2002-06-23 18:15:01 from Curt Sampson <cjs(at)cynic(dot)net>                                      2002-06-23 19:36:54 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                       2002-06-24 00:09:30 from Curt Sampson <cjs(at)cynic(dot)net>                                        2002-06-24 14:06:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                         2002-06-24 16:40:31 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                          2002-06-24 17:11:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                       2002-06-24 01:29:23 from "J(dot) R(dot) Nield" <jrnield(at)usol(dot)com>                                        2002-06-24 01:58:31 from "J(dot) R(dot) Nield" <jrnield(at)usol(dot)com>                                        2002-06-24 02:46:44 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                        2002-06-24 03:40:51 from Curt Sampson <cjs(at)cynic(dot)net>                                         2002-06-24 20:49:42 from "J(dot) R(dot) Nield" <jrnield(at)usol(dot)com>                                          2002-06-24 21:16:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                           2002-06-25 00:28:00 from "J(dot) R(dot) Nield" <jrnield(at)usol(dot)com>                                           2002-06-25 05:08:59 from Curt Sampson <cjs(at)cynic(dot)net>                                            2002-06-25 13:22:05 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                          2002-06-24 21:25:14 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                           2002-06-24 21:31:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                            2002-06-24 21:33:43 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                          2002-06-25 03:32:05 from Curt Sampson <cjs(at)cynic(dot)net>                                          2002-06-25 05:05:45 from Curt Sampson <cjs(at)cynic(dot)net>                                           2002-06-25 13:52:14 from Curt Sampson <cjs(at)cynic(dot)net>                                            2002-06-25 14:09:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                             2002-06-25 14:17:30 from Larry Rosenman <ler(at)lerctr(dot)org>                                             2002-06-25 14:20:15 from Curt Sampson <cjs(at)cynic(dot)net>                                              2002-06-25 14:29:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                               2002-06-25 14:56:58 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                                2002-06-25 15:00:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                 2002-06-25 15:02:05 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                               2002-06-26 04:13:42 from Curt Sampson <cjs(at)cynic(dot)net>                                                2002-06-26 13:21:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                 2002-06-26 17:11:19 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                                 2002-06-27 03:37:18 from Curt Sampson <cjs(at)cynic(dot)net>                                             2002-06-25 14:20:29 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                              2002-06-25 14:24:44 from Curt Sampson <cjs(at)cynic(dot)net>                                              2002-06-25 14:32:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                               2002-06-25 14:55:54 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                             2002-06-25 14:20:49 from Lee Kindness <lkindness(at)csl(dot)co(dot)uk>                                      2002-06-24 00:24:47 from Dave Cramer <dave(at)fastcrypt(dot)com>                                       2002-06-24 14:02:32 from "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>                                     2002-06-23 19:34:55 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                           2002-04-25 15:01:02 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                            2002-04-26 02:37:08 from Curt Sampson <cjs(at)cynic(dot)net>                  2002-04-18 04:01:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                   2002-04-18 04:32:59 from mlw <markw(at)mohawksoft(dot)com>                    2002-04-18 05:00:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2002-04-18 11:52:35 from mlw <markw(at)mohawksoft(dot)com>                     2002-04-18 13:38:42 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                    2002-04-18 13:35:15 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                     2002-04-18 14:48:34 from mlw <markw(at)mohawksoft(dot)com>                      2002-04-18 15:16:52 from Thomas Lockhart <lockhart(at)fourpalms(dot)org>                      2002-04-18 15:17:14 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                      2002-04-18 15:43:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                      2002-04-20 04:10:23 from Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>                       2002-04-20 04:16:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2002-04-22 10:13:39 from "Luis Alberto Amigo Navarro" <lamigo(at)atc(dot)unican(dot)es>                         2002-04-23 16:42:28 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                          2002-04-24 16:32:52 from "Luis Alberto Amigo Navarro" <lamigo(at)atc(dot)unican(dot)es>                        2002-04-22 11:58:52 from "Luis Alberto Amigo Navarro" <lamigo(at)atc(dot)unican(dot)es> 📎                       2002-04-23 16:41:45 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                        2002-04-24 07:12:46 from Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>                         2002-04-24 07:51:29 from Curt Sampson <cjs(at)cynic(dot)net>                          2002-04-24 14:08:49 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                           2002-04-25 01:40:37 from Curt Sampson <cjs(at)cynic(dot)net>                            2002-04-25 01:56:41 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                             2002-04-25 03:19:14 from Curt Sampson <cjs(at)cynic(dot)net>                              2002-04-25 03:30:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                               2002-04-25 03:34:29 from Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>                               2002-04-25 05:43:11 from Michael Loftis <mloftis(at)wgops(dot)com>                               2002-04-25 07:28:51 from Curt Sampson <cjs(at)cynic(dot)net>                                2002-04-25 09:19:02 from Curt Sampson <cjs(at)cynic(dot)net>                                2002-04-25 13:54:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                 2002-04-26 00:40:53 from Kyle <kaf(at)nwlink(dot)com>                                  2002-04-26 02:18:47 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                                 2002-04-26 02:27:17 from Curt Sampson <cjs(at)cynic(dot)net>                                2002-04-25 14:55:58 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                              2002-04-25 04:04:24 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>                               2002-04-25 07:55:50 from Curt Sampson <cjs(at)cynic(dot)net>                              2002-04-25 08:33:36 from Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>                               2002-04-25 10:47:13 from Curt Sampson <cjs(at)cynic(dot)net>                                2002-04-25 17:41:19 from Hannu Krosing <hannu(at)tm(dot)ee>                       2002-04-24 02:50:43 from mlw <markw(at)mohawksoft(dot)com>                 2002-04-18 07:16:34 from "Luis Alberto Amigo Navarro" <lamigo(at)atc(dot)unican(dot)es>        2002-04-17 22:20:08 from Bill Cunningham <billc(at)ballydev(dot)com>       2002-04-17 05:42:34 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>        2002-04-17 06:00:24 from mlw <markw(at)mohawksoft(dot)com>         2002-04-17 06:36:09 from Hannu Krosing <hannu(at)krosing(dot)net>         2002-04-17 06:53:48 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>         2002-04-17 10:15:03 from Jean-Paul ARGUDO <jean-paul(dot)argudo(at)idealx(dot)com>          2002-04-17 14:34:57 from Thomas Lockhart <thomas(at)fourpalms(dot)org>           2002-04-17 15:30:16 from Mike Mascari <mascarm(at)mascari(dot)com>           2002-04-17 15:46:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2002-04-18 02:06:45 from Thomas Lockhart <lockhart(at)fourpalms(dot)org>             2002-04-18 02:30:54 from Justin Clift <justin(at)postgresql(dot)org>              2002-04-18 02:38:09 from Thomas Lockhart <lockhart(at)fourpalms(dot)org>               2002-04-18 02:39:03 from Justin Clift <justin(at)postgresql(dot)org>         2002-04-17 13:55:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2002-04-17 14:08:27 from Michael Loftis <mloftis(at)wgops(dot)com>          2002-04-17 14:11:47 from Michael Loftis <mloftis(at)wgops(dot)com>          2002-04-17 14:57:17 from mlw <markw(at)mohawksoft(dot)com>      2002-04-17 10:55:23 from tycho(at)fruru(dot)com       2002-04-17 13:52:02 from Thomas Lockhart <thomas(at)fourpalms(dot)org>     2002-04-17 13:52:07 from Louis-David Mitterrand <vindex(at)apartia(dot)org>      2002-04-17 14:38:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2002-04-17 15:26:33 from Louis-David Mitterrand <vindex(at)apartia(dot)org>        2002-04-17 16:14:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:	pgsql-hackers

In response to

• Re: Index Scans become Seq Scans after VACUUM ANALYSE at 2002-06-21 02:18:14 from Curt Sampson

Responses

• Re: Index Scans become Seq Scans after VACUUM ANALYSE at 2002-06-22 08:41:30 from Curt Sampson

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Bruce Momjian	2002-06-21 14:15:03	Re: Our archive searching stinks
Previous Message	Bruce Momjian	2002-06-21 14:11:09	Re: Reduce heap tuple header size