Re: Re[4]: Postgres is too slow?

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
>

In response to

Browse pgsql-general by date

  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