Re: select count(*) performance (vacuum did not help) - Mailing list pgsql-performance

From Gábor Farkas
Subject Re: select count(*) performance (vacuum did not help)
Date
Msg-id 46F7D453.4050908@nekomancer.net
Whole thread Raw
In response to Re: select count(*) performance (vacuum did not help)  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: select count(*) performance (vacuum did not help)
Re: select count(*) performance (vacuum did not help)
Re: select count(*) performance (vacuum did not help)
List 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

pgsql-performance by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: select count(*) performance (vacuum did not help)
Next
From: "Fabiola Fernández"
Date:
Subject: TEXT or LONGTEXT?