Re: Re[4]: Postgres is too slow?
От | Daniel Åkerud |
---|---|
Тема | Re: Re[4]: Postgres is too slow? |
Дата | |
Msg-id | 004a01c0fb5c$e0478380$c901a8c0@automatic100 обсуждение исходный текст |
Ответ на | Re: Re[4]: Postgres is too slow? ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>) |
Список | 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 по дате отправления: