Re: Re[4]: Postgres is too slow? - Mailing list pgsql-general

From Daniel Åkerud
Subject Re: Re[4]: Postgres is too slow?
Date
Msg-id 004a01c0fb5c$e0478380$c901a8c0@automatic100
Whole thread Raw
In response to Re: Re[4]: Postgres is too slow?  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List 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@cs.pitt.edu>
To: "Alex Pilosov" <alex@pilosoft.com>
Cc: "Paul" <magamos@mail.ru>; <pgsql-general@postgresql.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
>


pgsql-general by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: Re[4]: Postgres is too slow?
Next
From: Martin Weinberg
Date:
Subject: Re: Re[4]: Postgres is too slow?