Write performance on a large database

Поиск
Список
Период
Сортировка
От Håvard Wahl Kongsgård
Тема Write performance on a large database
Дата
Msg-id BANLkTi=mrDYWctLp8Si+DpeMO_um8dKG7g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Write performance on a large database  (Vick Khera <vivek@khera.org>)
Re: Write performance on a large database  (tv@fuzzy.cz)
Re: Write performance on a large database  (Alan Hodgson <ahodgson@simkin.ca>)
Re: Write performance on a large database  (Greg Smith <greg@2ndQuadrant.com>)
Re: Write performance on a large database  (Greg Smith <greg@2ndQuadrant.com>)
Список pgsql-general
Дерево обсуждения
Hi, I have performance issues on very large database(100GB). Reading from the database is no problem, but writing(or heavy writing) is a nightmare.
I have tried tuning postgresql, but that does not seem to improving the writing performance.
To improve the write performance, what are my options?


--
Håvard Wahl Kongsgård

http://havard.security-review.net/

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

Предыдущее
От: Willy-Bas Loos
Дата:
Сообщение: Re: [PERFORM] [PERFORMANCE] expanding to SAN: which portion best to move
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Best Practices - Securing an Enterprise application using JBOSS & Postgres