Quick Links

Write performance on a large database

From:	Håvard Wahl Kongsgård <haavard(dot)kongsgaard(at)gmail(dot)com>
To:	pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject:	Write performance on a large database
Date:	2011-06-09 12:15:26
Message-ID:	BANLkTi=mrDYWctLp8Si+DpeMO_um8dKG7g@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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/

Responses

Re: Write performance on a large database at 2011-06-09 13:35:21 from Vick Khera
Re: Write performance on a large database at 2011-06-09 14:06:29 from tv
Re: Write performance on a large database at 2011-06-09 15:08:55 from Alan Hodgson
Re: Write performance on a large database at 2011-06-09 17:15:06 from Greg Smith

Browse pgsql-general by date

	From	Date	Subject
Next Message	Bill Moran	2011-06-09 12:44:31	Re: Best Practices - Securing an Enterprise application using JBOSS & Postgres
Previous Message	Willy-Bas Loos	2011-06-09 11:43:26	Re: [PERFORM] [PERFORMANCE] expanding to SAN: which portion best to move