reindex vs. drop index , create index

Поиск
Список
Период
Сортировка
От Henrik Steffen
Тема reindex vs. drop index , create index
Дата
Msg-id 02ed01c2d902$0467d1f0$7100a8c0@henrik
обсуждение исходный текст
Ответы Re: reindex vs. drop index , create index
Список pgsql-general
hello all,

a few weeks ago I turned to REINDEXing my tables instead of DROPping and
reCREATEing them.

now, however, I again have problems when VACUUMing or REINDEXing these
tables. Postgres states that the connection has been lost etc.

the only thing helping is to DROP and CREATE the index again....

I will now again have a cronjob that at least once a week will
DROP and CREATE all indexes.

isn't this a bit poor of postgresql??

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com          Tel. +49 4141 991230
mail: steffen@topconcepts.com       Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline:  +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------


В списке pgsql-general по дате отправления:

Предыдущее
От: Jean-Luc Lachance
Дата:
Сообщение: Re: 7.3.1 takes long time to vacuum table?
Следующее
От: "Patric Bechtel"
Дата:
Сообщение: Re: Table Partitioning in Postgres: [Viruschecked]