Hi Everybody,
I have a table that I add rows every evening.
A rule I have for this table is that no row
ever gets deleted. It has 600+ million rows.
The last time I did it, it took nearly 4 hours
to vacuum and 13 hours 40 minutes to reindex.
My rudimental understanding of vacuuming is
that when
do you also update rows of that table?
because that action delete old one's and insert new one's..
if you are just inserting rows and not updating or deleting, i think is
correct your point.
Regards,
--
"Sin desafíos la vida es una rutina, una lenta agonía"
Diógenes Caraballo
On Fri, Ma
s Caraballo [mailto:dio...@gmail.com]
Sent: Sat 3/21/2009 6:31 AM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] vacuuming and reindexing
do you also update rows of that table?
because that action delete old one's and insert new one's..
if you are just inserting rows