Re: Commercial postgresql
От | Shridhar Daithankar |
---|---|
Тема | Re: Commercial postgresql |
Дата | |
Msg-id | 3F54EC89.12705.1000B2E@localhost обсуждение исходный текст |
Ответ на | Re: Commercial postgresql (Vivek Khera <khera@kcilink.com>) |
Список | pgsql-general |
On 2 Sep 2003 at 9:36, Vivek Khera wrote: > >>>>> "BL" == Bo Lorentsen <bl@netgroup.dk> writes: > > BL> On Tue, 2003-09-02 at 04:08, Vivek Khera wrote: > >> 3) Index bloat is apparently a bigger problem than I thought. > BL> This does not sound too nice ! > > No, like I said, I shaved 900Mb of index table size this weekend by > re-indexing. Unfortunately it meant I was partially down for about 45 > minutes per index on my largest table, and about 15 per index on the > second largest table, and 5 per index on the third largest, then about > 90 seconds total for the rest of the tables ;-) Umm.. Since you have only 2.7GB of data, all inclusive, would it be real downtime if you reindex in a transaction, assuming the "downtime" was not due to crunch of IO bandwidth.. Just a thought.. Bye Shridhar -- Beauty: What's in your eye when you have a bee in your hand.
В списке pgsql-general по дате отправления: