Home > mailing lists

Write performance on a large database - Mailing list pgsql-general

From	Håvard Wahl Kongsgård
Subject	Write performance on a large database
Date	June 9, 2011 12:15:33
Msg-id	BANLkTi=mrDYWctLp8Si+DpeMO_um8dKG7g@mail.gmail.com Whole thread Raw
Responses	Re: Write performance on a large database Re: Write performance on a large database Re: Write performance on a large database Re: Write performance on a large database Re: Write performance on a large database
List	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?

From: Willy-Bas Loos
Date: 09 June 2011, 11:43:35
Subject: Re: [PERFORM] [PERFORMANCE] expanding to SAN: which portion best to move

From: Bill Moran
Date: 09 June 2011, 12:44:44
Subject: Re: Best Practices - Securing an Enterprise application using JBOSS & Postgres