Re: [Again] Postgres performance problem
От
Frank Schoep
Тема
Re: [Again] Postgres performance problem
Дата
Msg-id
A9ADD88B-83D8-43FC-A58F-A7D2D38B9311@ffnn.nl
Ответ на
Re: [Again] Postgres performance problem (Scott Marlowe)
Список
Дерево обсуждения
[Again] Postgres performance problem Ruben Rubio <ruben@rentalia.com>
Re: [Again] Postgres performance problem db@zigo.dhs.org
Re: [Again] Postgres performance problem Ruben Rubio <ruben@rentalia.com>
Re: [Again] Postgres performance problem Decibel! <decibel@decibel.org>
Re: [Again] Postgres performance problem ruben@rentalia.com
Re: [Again] Postgres performance problem "Scott Marlowe" <scott.marlowe@gmail.com>
Re: [Again] Postgres performance problem "Mikko Partio" <mpartio@gmail.com>
Re: [Again] Postgres performance problem "Scott Marlowe" <scott.marlowe@gmail.com>
Re: [Again] Postgres performance problem Alvaro Herrera <alvherre@commandprompt.com>
Re: [Again] Postgres performance problem Frank Schoep <frank@ffnn.nl>
Re: [Again] Postgres performance problem Erik Jones <erik@myemma.com>
Re: [Again] Postgres performance problem Decibel! <decibel@decibel.org>
Re: [Again] Postgres performance problem "Scott Marlowe" <scott.marlowe@gmail.com>
Re: [Again] Postgres performance problem Brian Hurt <bhurt@janestcapital.com>
Re: [Again] Postgres performance problem Greg Smith <gsmith@gregsmith.com>
Re: [Again] Postgres performance problem El-Lotso <el.lotso@gmail.com>
Re: [Again] Postgres performance problem Decibel! <decibel@decibel.org>
[OT] Re: [Again] Postgres performance problem Ow Mun Heng <Ow.Mun.Heng@wdc.com>
Re: [Again] Postgres performance problem Erik Jones <erik@myemma.com>
Re: [Again] Postgres performance problem "Scott Marlowe" <scott.marlowe@gmail.com>
Re: [Again] Postgres performance problem Adam Tauno Williams <adamtaunowilliams@gmail.com>
Re: [Again] Postgres performance problem "Scott Marlowe" <scott.marlowe@gmail.com>
Re: [Again] Postgres performance problem Greg Smith <gsmith@gregsmith.com>
Re: [Again] Postgres performance problem "Gavin M. Roy" <gmr@ehpg.net>
Re: [Again] Postgres performance problem Ruben Rubio <ruben@rentalia.com>
On Sep 12, 2007, at 9:07 PM, Scott Marlowe wrote: > On 9/12/07, Mikko Partio wrote: >> … >> Aren't you mixing up REINDEX and CLUSTER? > > … > Either one does what a vacuum full did / does, but generally does > it better. On topic of REINDEX / VACUUM FULL versus a CLUSTER / VACUUM ANALYZE I'd like to ask if CLUSTER is safe to run on a table that is in active use. After updating my maintenance scripts from a VACUUM FULL (add me to the list) to CLUSTER (which improves performance a lot) I noticed I was getting "could not open relation …" errors in the log while the scripts ran so I reverted the change. This was on 8.1.9. Am I hitting a corner case or is it generally not a good idea to CLUSTER tables which are being queried? I haven't had problems with the REINDEX / VACUUM FULL combination while CLUSTER / VACUUM ANALYZE resulted in errors on the first run. Can the "could not open relation…" error bring down the whole database server? I'm really interested in using CLUSTER regularly as it speeds up my system by a factor of two because of more efficient I/O. Sincerely, Frank
В списке pgsql-performance по дате отправления
