| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| 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-22 20:19:21 |
| Message-ID: | 20080122121921.302c52f4@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Tue, 22 Jan 2008 17:44:33 -0200
"Luiz K. Matsumura" <luiz(at)planit(dot)com(dot)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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-01-22 20:34:15 | Re: Optimizing queries that use temporary tables |
| Previous Message | Luiz K. Matsumura | 2008-01-22 19:44:33 | Re: SELECT * FROM table is too slow |