|
Home > Archive > PostgreSQL Administration > October 2006 > Re: Disk space consumed by pk not returned after vacuum or reindex
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Disk space consumed by pk not returned after vacuum or reindex
|
|
| Jim Nasby 2006-10-25, 8:24 am |
| I didn't see you mention what version you're running; index bloat
shouldn't be a big issue in 7.4 and above. You also didn't mention
how often you're vacuuming the table. If you don't vacuum the table
frequently enough, you're going to get bloat, plain and simple.
On Oct 5, 2006, at 11:24 AM, Kevin Johnson wrote:[color=darkred
]
> Thank you for the suggestion, Bruno. The clustering did the trick
> in reducing the current disk usage, however eventually the disk
> space get consumed once more. I fear that we may just need to
> update the version of Postgres to help alleviate index bloat!
>
> Bruno Wolff III wrote:
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
--
Jim Nasby jimn@enterprisedb.com
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
| |
| Jim Nasby 2006-10-25, 8:24 am |
| On Oct 6, 2006, at 5:39 AM, Kevin Johnson wrote:[color=darkred
]
> You are correct, it is 7.4 we are running on a RHEL3 system.
> The database itself is vacuumed via cron 6 times a day.
>
> Jim Nasby wrote:
For a heavy update load, even 6 times a day may not be enough.
Also, remember that the size you get after a REINDEX will be
unreasonably low, because there will be very little free space in the
index. That's fine if you won't be updating the table much, but
otherwise the index will have no choice but to grow.
--
Jim Nasby jimn@enterprisedb.com
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
|
|
|
|
|