From: Guillaume Cottenceau <gc@mnc.ch>
To: Luiz K. Matsumura <luiz@planit.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: SELECT * FROM table is too slow
Date: Wed, 23 Jan 2008 09:47:42 +0100
Message-ID: <877ii1ylld.fsf@mnc.ch> (raw)
In-Reply-To: <479647A1.6010101@planit.com.br>
References: <47656FC5.8060102@wooh.hu>
<47657068.5070200@commandprompt.com>
<479647A1.6010101@planit.com.br>
"Luiz K. Matsumura" <luiz 'at' planit.com.br> writes:
> If we run the commands "vacumm full analyze"
If you're using the cost based vacuum delay, don't forget that it
will probably take long; possibly, you may deactivate it locally
before running VACUUM FULL, in case the locked table is mandatory
for your running application(s).
--
Guillaume Cottenceau, MNC Mobile News Channel SA
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gc@mnc.ch, luiz@planit.com.br
Subject: Re: SELECT * FROM table is too slow
In-Reply-To: <877ii1ylld.fsf@mnc.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox