> We are using PostgreSQL for storing data and full-text search indexes
> for the webiste of a daily newspaper. We are very happy overall with the
> results, but we have one "weird" behaviour that we would like to solve.
I think there's a lot of missing info worth knowing:
1) checkpoints logs? Enable them, maybe the "slowness" happens
2) How many rows does each table contain?
3) HW: how many discs you have, and which controller you're using (and:
does it use a BBU?)
The more you tell the list, the better help you'll get...
In response to
pgsql-performance by date
|Next:||From: Mladen Gogala||Date: 2010-10-21 13:27:44|
|Subject: Re: Index scan is not working, why??|
|Previous:||From: Kenneth Marshall||Date: 2010-10-21 13:03:08|
|Subject: Re: Periodically slow inserts|