Re: Help tuning postgres
От | Robert Treat |
---|---|
Тема | Re: Help tuning postgres |
Дата | |
Msg-id | 1129648722.2022.8.camel@camel обсуждение исходный текст |
Ответ на | Re: Help tuning postgres (Steve Poe <spoe@sfnet.cc>) |
Ответы |
Re: Help tuning postgres
|
Список | pgsql-performance |
reindex should be faster, since you're not dumping/reloading the table contents on top of rebuilding the index, you're just rebuilding the index. Robert Treat emdeon Practice Services Alachua, Florida On Wed, 2005-10-12 at 13:32, Steve Poe wrote: > > Would it not be faster to do a dump/reload of the table than reindex or > is it about the same? > > Steve Poe > > On Wed, 2005-10-12 at 13:21 -0400, Tom Lane wrote: > > Emil Briggs <emil@baymountain.com> writes: > > >> Not yet, the db is in production use and I have to plan for a down-time > > >> for that... or is it not impacting the activity on the table ? > > > > > It will cause some performance hit while you are doing it. > > > > It'll also lock out writes on the table until the index is rebuilt, > > so he does need to schedule downtime. > > > > regards, tom lane > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
В списке pgsql-performance по дате отправления: