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 по дате отправления: