Horton
Menu

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

Thalis A. Kalfigopoulos <thalis@cs.pitt.edu>

View thread
From: "Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>
To: Alex Pilosov <alex@pilosoft.com>
Cc: Paul <magamos@mail.ru>, pgsql-general@postgresql.org
Date: 2001-06-22T20:34:56Z
Lists: pgsql-general 
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