Hello,
We are running a Linux Redhat system and running a postgres 8.3.7
Database. We are also running slony 1.2.21 with a simple 1 master -1 slave
Configuration. We wish to delete older inactive data from our largest
table, the end result will be dropping from 380 million rows and 2.9 million
Pages to 290 million rows. When I perform a vacuum full in test, the table
size Reduces to 2.2 million pages. I would like this to be the end result,
The problem is the vacuum full took nearly 36 hours to run. I've also read
The cautions about long running transactions being a potential problem to
Slony.
In test, I have successfully run the delete to remove the rows and
Currently have the table with the removed rows but the bloated page size.
My questions are:
1. What better method other than VACUUM FULL is there to rid myself of
The bloat and,
2. How can I make this method play nice with slony?
Thank you for your time,
Mark Steben | Database Administrator
@utoRevenue® - "Keeping Customers Close"
95D Ashley Ave, West Springfield, MA 01089
413.243.4800 x1512 (Phone) |413.732-1824 (Fax)
@utoRevenue is a registered trademark and a division of Dominion
Enterprises
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
