Re: Periodically slow inserts

Поиск
Список
Период
Сортировка
От Leonardo Francalanci
Тема Re: Periodically slow inserts
Дата
Msg-id 857928.20870.qm@web29002.mail.ird.yahoo.com
обсуждение исходный текст
Ответ на Periodically slow inserts  (Gael Le Mignot <gael@pilotsystems.net>)
Ответы Re: Periodically slow inserts  (Gael Le Mignot <gael@pilotsystems.net>)
Список pgsql-performance
> We are  using PostgreSQL for  storing data and  full-text  search indexes
> for the webiste of a daily newspaper. We are  very happy overall with the
> results, but we have one "weird" behaviour that  we would like to solve.


I think there's a lot of missing info worth knowing:

1) checkpoints logs? Enable them, maybe the "slowness" happens
at checkpoints:

log_checkpoints=true

2) How many rows does each table contain?

3) HW: how many discs you have, and which controller you're using (and:
does it use a BBU?)

The more you tell the list, the better help you'll get...




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

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: Periodically slow inserts
Следующее
От: Mladen Gogala
Дата:
Сообщение: Re: Index scan is not working, why??