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

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

pgsql-performance by date

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

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