Re: High inserting by syslog

On Thursday 03 July 2008, Richard Huxton <dev@[EMAIL PROTECTED]
> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general