| From: | "Thalis A(dot) 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 |
| Subject: | Re: Re[4]: Postgres is too slow? |
| Date: | 2001-06-22 20:34:56 |
| Message-ID: | Pine.LNX.4.21.0106221626540.27771-100000@aluminum.cs.pitt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas T. Thai | 2001-06-22 20:42:03 | Re: select to combine 2 tables |
| Previous Message | Svenne Krap | 2001-06-22 20:26:18 | PG-upgrade : 7.0.3 -> 7.1.2 |