From: Joshua D. Drake <jd@commandprompt.com>
To: Luiz K. Matsumura <luiz@planit.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: SELECT * FROM table is too slow
Date: Tue, 22 Jan 2008 12:19:21 -0800
Message-ID: <20080122121921.302c52f4@commandprompt.com> (raw)
In-Reply-To: <479647A1.6010101@planit.com.br>
References: <47656FC5.8060102@wooh.hu>
<47657068.5070200@commandprompt.com>
<479647A1.6010101@planit.com.br>
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, luiz@planit.com.br
Subject: Re: SELECT * FROM table is too slow
In-Reply-To: <20080122121921.302c52f4@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox