Re: High inserting by syslog

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: High inserting by syslog
Дата
Msg-id 200807030927.26975@hal.medialogik.com
обсуждение исходный текст
Ответ на Re: High inserting by syslog  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
On Thursday 03 July 2008, Richard Huxton <dev@archonet.com> wrote:
> You might want to partition the table monthly. That will make it easier
> to manage a few years from now.
> http://www.postgresql.org/docs/current/static/ddl-partitioning.html

Definitely pay attention to this point ... it's pretty easy to stuff 300K
rows a day into a table but a lot more painful to manage the enormous table
that results from doing it for any length of time.

--
Alan

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

Предыдущее
От: "Valter Douglas Lisbôa Jr."
Дата:
Сообщение: Re: High inserting by syslog
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: High inserting by syslog