7.2 - 7.4.2 production server migration issue

Поиск
Список
Период
Сортировка
От Christophe Musielak
Тема 7.2 - 7.4.2 production server migration issue
Дата
Msg-id 1091190722.1952.189.camel@fangorn
обсуждение исходный текст
Ответы Re: 7.2 - 7.4.2 production server migration issue  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
Hi everyone at the list,

Some months ago i asked you some questions about 7.2 - 7.4.3 migration. Then i switched to the performance list to complain about postgres 7.2 poor performance and discussed about different ways to improbe performances.

Two days ago we started our first production server 7.4.2 migration at our biggest customer, a quite big postgres 7.2 database with millions of rows in a quite complex scheme.

I must say that the result is even better than what we expected. The average load of the standalone database server used to be around 1.5 - 2.0 with 7.2

The 7.4.2 server load average is now around 0.5 !!

The new database is answering very quickly at each request, and web pages displays quicker as never before.

I'm here to say thank you for your great work guys. Nice job!

I'm now waiting for 7.5 :)

++
Christophe Musielak



В списке pgsql-general по дате отправления:

Предыдущее
От: "Rodríguez Rodríguez, Pere"
Дата:
Сообщение: pg_restore -t
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Using view