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-12-01 02:07:52
Message-ID: 017c01c4d74a$90805de0$0100000a@wp2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

From: "BBI Edwin Punzalan" <edwin(at)bluebamboo(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message BBI Edwin Punzalan 2004-12-01 02:33:15 Re: FW: Index usage
Previous Message BBI Edwin Punzalan 2004-12-01 01:50:30 Re: FW: Index usage