> BTW, I didn't complete my first thought above, which was to ask when
you
> last
> vacuumed the DB, but then I saw that you were running autovac, so that
> wasn't
> likely the problem.
>
> BTW, if the problem is actually a raid array that is rebuilding, it
should
> be
> (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
is taken)
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?
--
Daniel