Re: FW: Index usage

From: gnari
Subject: Re: FW: Index usage
Date: ,
Msg-id: 002701c4d259$91b7a330$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" <>
>
> 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:

From: Mike Mascari
Date:
Subject: Re: Slow execution time when querying view with WHERE clause
From: "Steinar H. Gunderson"
Date:
Subject: Re: Postgres vs. MySQL