Re: problems with large table
От
Mike Charnoky
Тема
Re: problems with large table
Дата
Msg-id
46EAA672.8060805@nextbus.com
Ответ на
Re: problems with large table (Joshua D. Drake)
Список
Дерево обсуждения
problems with large table Mike Charnoky <noky@nextbus.com>
Re: problems with large table "Joshua D. Drake" <jd@commandprompt.com>
Re: problems with large table Alvaro Herrera <alvherre@commandprompt.com>
Re: problems with large table Tom Lane <tgl@sss.pgh.pa.us>
Re: problems with large table Mike Charnoky <noky@nextbus.com>
Re: problems with large table Alvaro Herrera <alvherre@commandprompt.com>
Re: problems with large table "Phoenix Kiula" <phoenix.kiula@gmail.com>
Re: problems with large table Alvaro Herrera <alvherre@commandprompt.com>
Re: problems with large table Tom Lane <tgl@sss.pgh.pa.us>
Re: problems with large table "Phoenix Kiula" <phoenix.kiula@gmail.com>
Re: problems with large table Mike Charnoky <noky@nextbus.com>
Thanks, recreating the table solved my problems. Our team is working on implementing some performance tuning based on other recommendations from the list (FSM, etc). Mike Joshua D. Drake wrote: > At this point, you are in a world of hurt :). If you stop a vacuum you > have created a huge mess of dead rows in that table. My suggestion is > this to create a new table that is populated from the old table, rename > the old table to big_table new, rename new table to old table. Run analyze.
В списке pgsql-general по дате отправления
