On Feb 24, 2008, at 4:27 PM, Scott Marlowe wrote:
On Sun, Feb 24, 2008 at 6:05 PM, Sean Leach <sleach@xxxxxxxxxx> wrote:
On Feb 24, 2008, at 4:03 PM, Scott Marlowe wrote:
What version pgsql is this? If it's pre 8.0 it might be worth
looking
into migrating for performance and maintenance reasons.
It's the latest 8.3.0 release :(
Urg. Then I wonder how your indexes are bloating but your table is
not... you got autovac running? No weird lock issues? It's a side
issue right now since the table is showing as non-bloated (unless
you've got a long running transaction and that number is WAY off from
your vacuum)
Autovac is running, but probably not tuned. I am looking at my
max_fsm_pages setting to up as vacuum says, but not sure which value
to use (all the posts on the web refer to what looks like an old
vacuum output format), is this the line to look at?
INFO: "u_counts": found 0 removable, 6214708 nonremovable row
versions in 382344 pages
DETAIL: 2085075 dead row versions cannot be removed yet.
I.e. I need 382344 max_fsm_pages? No weird lock issues that we have
seen.
So should I do a vacuum full and then hope this doesn't happen again?
Or should I run a VACUUM FULL after each aggregation run?
Thanks!
Sean
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
