unsubscribe
Regards,
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeff Frost
Sent: Tuesday, March 21, 2006 9:19 PM
To: Daniel Caune
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Power cut and performance problem
On Tue, 21 Mar 2006, Daniel Caune
unsubscribe
Regards,
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Daniel Caune
Sent: Tuesday, March 21, 2006 9:44 PM
To: Jeff Frost
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Power cut and performance problem
> > For example, the exe
> > 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 m
> 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 tomor
On Tue, 21 Mar 2006, Daniel Caune wrote:
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)
On Mon, 20 Mar 2006, Daniel Caune wrote:
I see you're running autovacuum. What's your disk subsytem look like?
By
chance is it sitting on a RAID 5 that's running in degraded mode right
now
while it scrubs?
Yes, that should be the problem. I will check that tomorrow morning
with a Linux
> I see you're running autovacuum. What's your disk subsytem look like?
By
> chance is it sitting on a RAID 5 that's running in degraded mode right
now
> while it scrubs?
>
Yes, that should be the problem. I will check that tomorrow morning
with a Linux administrator. Thanks.
I see you're running autovacuum. What's your disk subsytem look like? By
chance is it sitting on a RAID 5 that's running in degraded mode right now
while it scrubs?
On Mon, 20 Mar 2006, Daniel Caune wrote:
Hi,
We had a power cut lastly and it seems that our PostgreSQL database
suffers from
Hi,
We had a power cut lastly and it seems that our PostgreSQL database
suffers from performance since. For example, a simple query such as
"SELECT MIN(a-primary-key-column) FROM a-table" takes quite a very long
time; actually I gave up before getting the result.
I shutdown and started up the da
