Postgres Pro
Downloads
Home   >   mailing lists

Re: FW: Index usage - Mailing list pgsql-performance

From gnari
Subject Re: FW: Index usage
Date
Msg-id 002701c4d259$91b7a330$0100000a@wp2000
Whole thread Raw
In response to Re: FW: Index usage  ("BBI Edwin Punzalan" <edwin@bluebamboo.ph>)
Responses Re: FW: Index usage
List pgsql-performance
Tree view 
From: "BBI Edwin Punzalan" <edwin@bluebamboo.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Group By " index usage
Next
From: Mike Mascari
Date:
Subject: Re: Slow execution time when querying view with WHERE clause