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: (view raw or whole thread)
Lists: pgsql-performance
"Luiz K. Matsumura" <luiz 'at'> 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-2015 The PostgreSQL Global Development Group