Re: select count(*) performance (vacuum did not help)

From: Gábor Farkas <gabor(at)nekomancer(dot)net>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: select count(*) performance (vacuum did not help)
Date: 2007-09-24 15:14:27
Message-ID: 46F7D453.4050908@nekomancer.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Heikki Linnakangas wrote:
> Gábor Farkas wrote:
>>
>> if i do a full vacuum to that table only, will the database still serve
>> data from the other tables at a normal speed?
>
> Yes. The extra I/O load vacuum full generates while it's running might
> disrupt other activity, though.
>

i see.

will i achieve the same thing by simply dropping that table and
re-creating it?

gabor

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Fabiola Fernández 2007-09-24 15:21:25 TEXT or LONGTEXT?
Previous Message Heikki Linnakangas 2007-09-24 15:07:51 Re: select count(*) performance (vacuum did not help)