Postgres Pro
Downloads
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
Msg-id BANLkTi=mrDYWctLp8Si+DpeMO_um8dKG7g@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: Willy-Bas Loos
Date:
Subject: Re: [PERFORM] [PERFORMANCE] expanding to SAN: which portion best to move
Next
From: Bill Moran
Date:
Subject: Re: Best Practices - Securing an Enterprise application using JBOSS & Postgres