Home > mailing lists

Re: Improve Query - Mailing list pgsql-performance

From	Grzegorz Jaśkiewicz
Subject	Re: Improve Query
Date	May 27, 2009 16:32:53
Msg-id	2f4958ff0905270932i18f05e4aie3701321075652@mail.gmail.com Whole thread Raw
In response to	Re: Improve Query (Zach Calvert <zachcalvert@hemerasoftware.com>)
Responses	Re: Improve Query
List	pgsql-performance

you have to vacuum analyze after you've created index, afaik.
No, count(*) is still counting rows.

From: Zach Calvert
Date: 27 May 2009, 16:25:22
Subject: Re: Improve Query

From: Zach Calvert
Date: 27 May 2009, 16:42:56
Subject: Re: Improve Query