Re: SELECT * FROM table is too slow

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: "Luiz K(dot) Matsumura" <luiz(at)planit(dot)com(dot)br>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SELECT * FROM table is too slow
Date: 2008-01-23 08:47:42
Message-ID: 877ii1ylld.fsf@mnc.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Guillaume Smet 2008-01-23 09:05:53 Re: Workaround for cross column stats dependency
Previous Message Scott Marlowe 2008-01-23 05:20:43 Re: Making the most of memory?