| From: | Sam Tregar <sam(at)tregar(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Indexes not being used. |
| Date: | 2001-06-22 17:39:22 |
| Message-ID: | Pine.LNX.4.30.0106221337380.20091-100000@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 22 Jun 2001, Tom Lane wrote:
> Sam Tregar <sam(at)tregar(dot)com> writes:
> > Better yet, Postgres could be modified to automatically VACUUM ANALYZE
> > after a CREATE INDEX.
>
> Doesn't seem like a good idea --- what if you need to create several
> indexes?
A NOVACUUM option? It seems like the general case - creating an index and
then wanting to use it - should be automatic. I've never used an RDBMs
that required me to do a special dance to an index I just created!
Grumble, grumble.
-sam
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt Beauregard | 2001-06-22 17:45:48 | Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer |
| Previous Message | David Wheeler | 2001-06-22 17:37:48 | Newbie Inheritance Question |