Strange behaviour - Inserts speeding, Selects are very slow

From: "Marek Lewczuk" <newsy(at)lewczuk(dot)com>
To: "Lista dyskusyjna pgsql-cygwin" <pgsql-cygwin(at)postgresql(dot)org>
Subject: Strange behaviour - Inserts speeding, Selects are very slow
Date: 2003-09-05 07:39:42
Message-ID: 000001c37380$df39ef70$4701a8c0@marek
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

Hello,
I'm quite new in PostgreSQL, but what I already know is that windows
Cygwin version of PG isn't working properly. I have made simple test
with insert and select. I was delighted in a speed of insertion query -
it is faster than mysql or other dbms (which I was using before) -
belive me - it was insertion of about 50 000 records. But when I wanted
to make selection query "SELECT * FROM ..." I wasn't so happy, becouse
MySQL do it 2-3 times faster. So my question Is: is it a windows problem
or maybe it's a nature of PostgreSQL engine ?? Usualy the situation is
different - insertions are slower than selects.

I was using "psql" to make querys, and the results was outputed to some
file.

Best wishes,
ML

Browse pgsql-cygwin by date

  From Date Subject
Next Message raj_14_11 2003-09-05 08:05:50 postgresql on windows 2000
Previous Message raj_14_11 2003-09-05 07:14:56 pgsql-cygwin