Re: DB is slow until DB is reloaded
От
Craig Ringer
Тема
Re: DB is slow until DB is reloaded
Дата
Msg-id
4B43E47F.5010305@postnewspapers.com.au
Ответ на
Re: DB is slow until DB is reloaded (Scott Carey)
Список
Дерево обсуждения
DB is slow until DB is reloaded Madison Kelly <linux@alteeve.com>
Re: DB is slow until DB is reloaded Gary Doades <gpd@gpdnet.co.uk>
Re: DB is slow until DB is reloaded Steve Crawford <scrawford@pinpointresearch.com>
Re: DB is slow until DB is reloaded Madison Kelly <linux@alteeve.com>
Re: DB is slow until DB is reloaded Richard Neill <rn214@cam.ac.uk>
Re: DB is slow until DB is reloaded Gary Doades <gpd@gpdnet.co.uk>
Re: DB is slow until DB is reloaded Madison Kelly <linux@alteeve.com>
Re: DB is slow until DB is reloaded Brad Nicholson <bnichols@ca.afilias.info>
Re: DB is slow until DB is reloaded Madison Kelly <linux@alteeve.com>
Re: DB is slow until DB is reloaded Steve Crawford <scrawford@pinpointresearch.com>
Re: DB is slow until DB is reloaded Madison Kelly <linux@alteeve.com>
Re: DB is slow until DB is reloaded Rosser Schwarz <rosser.schwarz@gmail.com>
Re: DB is slow until DB is reloaded Madison Kelly <linux@alteeve.com>
Re: DB is slow until DB is reloaded Steve Crawford <scrawford@pinpointresearch.com>
Re: DB is slow until DB is reloaded Craig James <craig_james@emolecules.com>
Re: DB is slow until DB is reloaded Brad Nicholson <bnichols@ca.afilias.info>
Re: DB is slow until DB is reloaded "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: DB is slow until DB is reloaded Madison Kelly <linux@alteeve.com>
Re: DB is slow until DB is reloaded Scott Carey <scott@richrelevance.com>
Re: DB is slow until DB is reloaded Craig Ringer <craig@postnewspapers.com.au>
Re: DB is slow until DB is reloaded Steve Crawford <scrawford@pinpointresearch.com>
Re: DB is slow until DB is reloaded Madison Kelly <linux@alteeve.com>
Re: DB is slow until DB is reloaded Greg Smith <greg@2ndquadrant.com>
Re: DB is slow until DB is reloaded Scott Marlowe <scott.marlowe@gmail.com>
Re: DB is slow until DB is reloaded Madison Kelly <linux@alteeve.com>
Scott Carey wrote: > CLUSTER also does *nothing at all* to a table unless you have chosen an index to CLUSTER on. Its not as simple as switching from VACUUM or VACUUM FULL to CLUSTER. > > Does CLUSTER also REINDEX? I seem to recall reducing the size of my indexes by REINDEXing after a CLUSTER, but it was a while ago and I could have been mistaken. AFAIK CLUSTER builds a new copy of the table, and new indexes for it, then swaps them into the old table and index's place. -- Craig Ringer
В списке pgsql-performance по дате отправления
