Skip site navigation (1) Skip section navigation (2)

Re: SELECT * FROM table is too slow

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 (view raw or flat)
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-----

In response to

pgsql-performance by date

Next:From: Scott MarloweDate: 2008-01-22 20:34:15
Subject: Re: Optimizing queries that use temporary tables
Previous:From: Luiz K. MatsumuraDate: 2008-01-22 19:44:33
Subject: Re: SELECT * FROM table is too slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group