Re: SELECT * FROM table is too slow

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: SELECT * FROM table is too slow
Дата
Msg-id 20080122121921.302c52f4@commandprompt.com
обсуждение исходный текст
Ответ на Re: SELECT * FROM table is too slow  ("Luiz K. Matsumura" <luiz@planit.com.br>)
Список pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 22 Jan 2008 17:44:33 -0200
"Luiz K. Matsumura" <luiz@planit.com.br> wrote:

> >
> 
> Joshua D. Drake wrote:Hi,
> 
> If we run the commands "vacumm full analyze" and "reindex table",
> this can be considered as equivalent to making a dump / restore in
> this case ?

Yes. 

Joshua D. Drake

- -- 
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ 
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHlk/LATb/zqfZUUQRAua0AKCsZrWrkf0d+jKUa9KK3aTqzuZTZACbBiD5
z3aIswcgRSwywxlhD+dgSHE=
=vdeQ
-----END PGP SIGNATURE-----

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Luiz K. Matsumura"
Дата:
Сообщение: Re: SELECT * FROM table is too slow
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Optimizing queries that use temporary tables