performance problems
This is a discussion on performance problems within the Pgsql Performance forums, part of the PostgreSQL category; --> Hi, I have performance problems with the postmaster-process. The CPU usage is permanently around 90 %. My DB: 3,5 ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-18-2008, 11:13 AM
| ||||
| ||||
 performance problems Hi, I have performance problems with the postmaster-process. The CPU usage is permanently around 90 %. My DB: 3,5 GB Size largest table ca. 700 000 rows Most access: Finde a row - Update if exist Insert else Average access: 10 times a second every Query needs ca. 20 ms All server options are still default !! Any idea on wich "screw" I can turn ?. Thanks for suggestions! Michael Zöphel e-Mail: zoephel@rechnerbetriebsgruppe.de      |
 |
« Help with slow running query
|
Re: [pgsql-hackers-win32] Help with tuning this query (with explain analyze finally) »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 01:49 PM.
