> BTW, I didn't complete my first thought above, which was to ask when
> vacuumed the DB, but then I saw that you were running autovac, so that
> likely the problem.
> BTW, if the problem is actually a raid array that is rebuilding, it
> (hopefullY) fixed by tomorrow morning.
An administrator is checking the raid status this morning. Anyway, I
did some tests and it seems that some results are weird.
For example, the execution of the following query is fast as it used to
be (gslog_event_id is the primary key on gslog_event):
select max(gslog_event_id) from gslog_event; (=> Time: 0.773 ms)
while the following query is really slow (several minutes):
select min(gslog_event_id) from gslog_event; (index on the primary key
I'm not a hardware expert at all, but I supposed that the whole
performance would be degraded when a problem occurs with RAID disks. Am
I wrong? Could it be something else? Are there some tools that check
the state of a PostgreSQL database?
pgsql-sql by date
|Next:||From: Achilleus Mantzios||Date: 2006-03-21 14:23:18|
|Subject: Re: Job queue, how would you implement this?|
|Previous:||From: Alexis Paul Bertolini||Date: 2006-03-21 13:02:30|
|Subject: Job queue, how would you implement this?|