Re: count(*) performance

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "G=?ISO-8859-1?B?4Q==?=briel =?ISO-8859-1?B?wQ==?=kos" <akos(dot)gabriel(at)i-logic(dot)hu>, pgsql-performance(at)postgresql(dot)org
Subject: Re: count(*) performance
Date: 2006-03-27 18:14:45
Message-ID: C04D6B95.20285%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Gabriel,

On 3/27/06 10:05 AM, "Gábriel Ákos" <akos(dot)gabriel(at)i-logic(dot)hu> wrote:

> That gave me an idea. I thought that autovacuum is doing it right, but I
> issued a vacuum full analyze verbose , and it worked all the day.
> After that I've tweaked memory settings a bit too (more fsm_pages)

Oops! I replied to your disk speed before I saw this.

The only thing is - you probably don't want to do a "vacuum full", but
rather a simple "vacuum" should be enough.

- Luke

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gábriel Ákos 2006-03-27 18:21:57 Re: count(*) performance
Previous Message Gábriel Ákos 2006-03-27 18:05:31 Re: count(*) performance