| From: | tv(at)fuzzy(dot)cz |
|---|---|
| To: | "Håvard Wahl Kongsgård" <haavard(dot)kongsgaard(at)gmail(dot)com> |
| Cc: | "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Write performance on a large database |
| Date: | 2011-06-09 14:06:29 |
| Message-ID: | a672ae72522bf83a39b0e729edd6cc0a.squirrel@sq.gransy.com |
| Views: | Whole Thread | Raw Message | 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?
Hard to tell with this little info. We need to know more about your
hardware (CPU, RAM, disk setup, ...), PostgreSQL configuration (number of
checkpoint segments, ...) and output from tools like vmstat and iostat.
regards
Tomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-06-09 14:19:32 | Re: plpgsql function with update and seeing changed data from outside during run |
| Previous Message | Day, David | 2011-06-09 14:06:04 | ECPG and server datatypes vs client representations. |