Re: FW: Index usage

From: "gnari" <gnari(at)simnet(dot)is>
To: "BBI Edwin Punzalan" <edwin(at)bluebamboo(dot)ph>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: FW: Index usage
Date: 2004-11-24 19:12:41
Message-ID: 002701c4d259$91b7a330$0100000a@wp2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

From: "BBI Edwin Punzalan" <edwin(at)bluebamboo(dot)ph>
>
> Yes, the database is being vacuum-ed and analyzed on a daily basis.
>

then you should consider increating the statistics on the date column,
as the estimates were a bit off in the plan

> Our version is 7.2.1

upgrade time ?

gnari

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mike Mascari 2004-11-24 22:51:13 Re: Slow execution time when querying view with WHERE clause
Previous Message Bo Stewart 2004-11-24 17:58:06 Hardware purchase question