Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT * FROM table is too slow - Mailing list pgsql-performance

From Guillaume Cottenceau
Subject Re: SELECT * FROM table is too slow
Date
Msg-id 877ii1ylld.fsf@mnc.ch
Whole thread Raw
In response to Re: SELECT * FROM table is too slow  ("Luiz K. Matsumura" <luiz@planit.com.br>)
List pgsql-performance
Tree view 
"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

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Making the most of memory?
Next
From: "Guillaume Smet"
Date:
Subject: Re: Workaround for cross column stats dependency