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

From gnari
Subject Re: FW: Index usage
Date
Msg-id 017c01c4d74a$90805de0$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
From: "BBI Edwin Punzalan" <edwin@bluebamboo.ph>


>
> Hi, what do you mean by increasing the statistics on the date column?

alter table chatlogs alter column date set statistics 300;
analyze chatlogs;

> > > Our version is 7.2.1
> >
> > upgrade time ?
>
> We never had any upgrade on it.

7.2 is a bit dated now that 8.0 is in beta

if you want to stay with 7.2, you should at least upgrade
to the latest point release (7.2.6 ?), as several serious bugs
have been fixed

gnari



pgsql-performance by date:

Previous
From: "BBI Edwin Punzalan"
Date:
Subject: Re: FW: Index usage
Next
From: "BBI Edwin Punzalan"
Date:
Subject: Re: FW: Index usage