Wed Aug 18 13:12:24 PDT 2010
- Previous message: [Slony1-general] Known bug I missed ?
- Next message: [Slony1-general] recommendations for removing bloat
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Known bug I missed ?
- Next message: [Slony1-general] recommendations for removing bloat
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list