Re: FW: Index usage

From: gnari
Subject: Re: FW: Index usage
Date: ,
Msg-id: 017c01c4d74a$90805de0$0100000a@wp2000
(view: Whole thread, Raw)
In response to: Re: FW: Index usage  ("BBI Edwin Punzalan")
Responses: Re: FW: Index usage  ("BBI Edwin Punzalan")
List: pgsql-performance

Tree view

FW: FW: Index usage  ("BBI Edwin Punzalan", )
 Re: FW: Index usage  ("gnari", )
  Re: FW: Index usage  ("BBI Edwin Punzalan", )
   Re: FW: Index usage  ("gnari", )
    Re: FW: Index usage  ("BBI Edwin Punzalan", )
     Re: FW: Index usage  ("gnari", )
      Re: FW: Index usage  ("BBI Edwin Punzalan", )
       Re: FW: Index usage  ("Iain", )
        Re: FW: Index usage  ("BBI Edwin Punzalan", )
         Re: FW: Index usage  ("Iain", )
       Re: FW: Index usage  ("gnari", )
 Re: FW: FW: Index usage  (Richard Huxton, )
  Re: FW: FW: Index usage  ("BBI Edwin Punzalan", )
   Re: FW: FW: Index usage  (Richard Huxton, )

From: "BBI Edwin Punzalan" <>


>
> 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:

From: "Hyun-Sung, Jang"
Date:
Subject: Re: Using "LIMIT" is much faster even though, searching
From: "gnari"
Date:
Subject: Re: FW: Index usage