Leonardo Francalanci writes:
>> I also recommend reindexing any table that has been VACUUM FULLed.
> Mmmh, from the docs I get that in 9.0 a "vacuum full" rewrites the whole
> table,
> so I expect the indexes to be re-created anyway... so a reindexing would
> be totally useless.
Any discussio
> I also recommend reindexing any table that has been VACUUM FULLed.
Mmmh, from the docs I get that in 9.0 a "vacuum full" rewrites the whole table,
so I expect the indexes to be re-created anyway... so a reindexing would
be totally useless.
Am I wrong?
--
Sent via pgsql-general mailing
In response to Szymon Guz :
> 2010/10/7 Devrim GÜNDÜZ
>
> > On Thu, 2010-10-07 at 17:38 +0600, AI Rumman wrote:
> > > MayVACUUM FULL on a table improve perfromance of the system?
> >
> > No, it will make things worse.
>
> That's not true, I'd rather say that it depends. The whole performance is
2010/10/7 Devrim GÜNDÜZ
> On Thu, 2010-10-07 at 17:38 +0600, AI Rumman wrote:
> > MayVACUUM FULL on a table improve perfromance of the system?
>
> No, it will make things worse.
>
That's not true, I'd rather say that it depends. The whole performance is
not just about the vacuum full.
regards
S
> > MayVACUUM FULL on a table improve perfromance of the system?
>
> No, it will make things worse.
???
Why?
"The FULL option is not recommended for routine use, but might be useful
in special cases. An example is when you have deleted or updated most
of the rows in a table and would like th
On Thu, 2010-10-07 at 17:38 +0600, AI Rumman wrote:
> MayVACUUM FULL on a table improve perfromance of the system?
No, it will make things worse.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~Postgre
On 7 October 2010 12:38, AI Rumman wrote:
> MayVACUUM FULL on a table improve perfromance of the system?
>
Please treat VACUUM FULL as a last resort. Read this:
http://wiki.postgresql.org/wiki/VACUUM_FULL
A VACUUM ANALYZE will mark dead tuples as free and update the stats.
Also check your query
