Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group