Re: VACUUM ANALYZE extremely slow

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Sergei Shelukhin <realgeek(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM ANALYZE extremely slow
Date: 2007-06-19 03:06:48
Message-ID: 20070619030648.GC4323@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sergei Shelukhin escribió:

> The same database running on mysql on basically the same server used
> to run optimize table on every table every half an hour without any
> problem, I am actually pondering scraping half the work on the
> conversion and stuff and going back to mysql but I wonder if there's
> some way to improve it.

Why waste time on it? Just move it to mysql since it's so good, and be
done with it.

--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"Someone said that it is at least an order of magnitude more work to do
production software than a prototype. I think he is wrong by at least
an order of magnitude." (Brian Kernighan)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-06-19 03:14:03 Re: Core reported from vaccum function.
Previous Message John Meyer 2007-06-19 03:02:07 Re: [GENERAL] [PERFORM] [ADMIN] Postgres VS Oracle