From: | Jan Krcmar <honza801(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: VACUUM process running for a long time |
Date: | 2010-04-15 13:56:20 |
Message-ID: | j2v27cffc1004150656w254bc516ve8fb5ab9d382b491@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi
2010/4/14 Adrian von Bidder <avbidder(at)fortytwo(dot)ch>:
> -> vacuum can run concurrently to other stuff, so it's not necessary to
> wait before it finishes.
> -> in most cases, autovacuum should do the Right Thing(tm) atomatically, so
> you should not need to call vacuum manually.
>
> This is with a recent pg version. Do you use a (very) old version with
> autovacuum? Is your db server running hot and can't really keep up with
> inserting data as soon as vacuum starts running?
>
> Note that the pg documentation contains lots of useful information about
> tuning autovacuum. Without knowing how your table looks and how your data
> entry happens (in peaks? or always at about the same rate?) we probably
> can't help you much more.
>
> cheers
> -- vbi
>
i'm doing one big insert per day, and one big delete per day
anyway, i've found, this article
http://www.postgresql.org/docs/8.4/interactive/ddl-partitioning.html
could the partitioning be helpfull for this situation?
i guess, that it does the same as the others advised. inserts are
stored into specific table and obsolete table is deleted and allocated
space is freed. am i right?
f.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2010-04-15 14:17:35 | Re: When is an explicit cast necessary? |
Previous Message | Merlin Moncure | 2010-04-15 13:53:37 | Re: How to insert Ecoded values into postrgresql |