From: | Daniel Åkerud <zilch(at)home(dot)se> |
---|---|
To: | "PostgreSQL-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Re[4]: Postgres is too slow? |
Date: | 2001-06-22 20:49:48 |
Message-ID: | 004a01c0fb5c$e0478380$c901a8c0@automatic100 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
man syslogd
-m interval
The syslogd logs a mark timestamp regularly.... default 20 minutes.
No virus *sigh* :)
Daniel Åkerud
----- Original Message -----
From: "Thalis A. Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
To: "Alex Pilosov" <alex(at)pilosoft(dot)com>
Cc: "Paul" <magamos(at)mail(dot)ru>; <pgsql-general(at)postgresql(dot)org>
Sent: Friday, June 22, 2001 10:34 PM
Subject: Re: Re[4]: [GENERAL] Postgres is too slow?
> On Fri, 22 Jun 2001, Alex Pilosov wrote:
>
> > Whoa! Your drive is only capable of 3M/s (640M/213 sec) transfer! Your
> > data set is 500K*200 bytes=100M. No surprise your queries take 30
seconds
> > to run, since its exactly how much it'd take to transfer 100M of data
from
> > your drive.
> >
> > Please read Linux IDE tuning documentation, or upgrade to more recent
> > kernel. You must be using DMA to get any sort of performance with
> > Linux on IDE drive.
>
> Had the same problem with a disk and boosted its performance with hdparm
(4->35Mb/s). I don't know if this was the reason I started getting the
message "-- MARK --" in my syslog's files (20min intervals) or I just hadn't
noticed them earlier. Any idea what it means?
>
> TIA,
> thalis
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Pilosov | 2001-06-22 20:52:08 | Re: Re[4]: Postgres is too slow? |
Previous Message | Daniel Åkerud | 2001-06-22 20:47:08 | Re: Multiple Indexing, performance impact |