Re: BUG #5774: VACCUM & REINDEX kills production environement

Поиск
Список
Период
Сортировка
От Balamurugan Mahendran
Тема Re: BUG #5774: VACCUM & REINDEX kills production environement
Дата
Msg-id AANLkTikDY1c+QQg-1XTHH4YvsVVPFbBK9Rzs07sX_qCJ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #5774: VACCUM & REINDEX kills production environement  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-bugs
Is there a recommended link/documentation to make sure my configuration? for
my current hardware

7 GB of memory
20 EC2 Compute Units (8 virtual cores with 2.5 EC2 Compute Units each)
1690 GB of instance storage
64-bit platform

Thanks for all your help!!

Thanks,
Bala


On Mon, Nov 29, 2010 at 10:22 PM, Heikki Linnakangas <
heikki.linnakangas@enterprisedb.com> wrote:

> On 29.11.2010 18:48, Balamurugan Mahendran wrote:
>
>> Thanks, I'll remove it. But I still get down time because of Vacuum(table
>> lock). Is there any other better way to do this?
>>
>
> Non-full vacuum doesn't lock out concurrent access. If you're getting
> downtime, there's got to be some other explanation.
>
>
>  I don't mind to switch to bigger instance with more Hardware.
>>
>
> Based on the information you've provided, it won't make a difference.
>
>
> --
>  Heikki Linnakangas
>  EnterpriseDB   http://www.enterprisedb.com
>

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

Предыдущее
От: Balamurugan Mahendran
Дата:
Сообщение: Re: BUG #5774: VACCUM & REINDEX kills production environement
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5761: In 'dblink' function connection string truncated