Vaccum and 24/7/365 database
От | Jean-Christophe ARNU |
---|---|
Тема | Vaccum and 24/7/365 database |
Дата | |
Msg-id | 1010571359.23534.49.camel@ez обсуждение исходный текст |
Ответы |
Re: Vaccum and 24/7/365 database
Re: Vaccum and 24/7/365 database Re: Vaccum and 24/7/365 database |
Список | pgsql-admin |
Hi all, we use postgresql 7.2 for a data logging/supervisor application running 24 hours a day, 7 days a week and 365 (and 6 hours) a year. Data are inserted/deleted/updated each 1,5 minutes and for performance reason we have to vacuum each day some tables. The problem is that vacuum stops inserts, updates and deletes for the table it performs (well in fact, I understood this). This way of working for the database does not fit our needs of 24/7/365 availability. So my question is : is there a way to get all the things work together (good performances & availability)? Thanks a lot. -- Jean-Christophe ARNU s/w developer Paratronic France
В списке pgsql-admin по дате отправления: