Beta3 much slower than Beta2 - Mailing list pgsql-bugs

From Enrico Riedel
Subject Beta3 much slower than Beta2
Date
Msg-id 20041022212731.EB15FEAE486@svr1.postgresql.org
Whole thread Raw
Responses Re: Beta3 much slower than Beta2
Re: Beta3 much slower than Beta2
List pgsql-bugs
Hi!



I just tried to use the new Beta 3 of PostGRE SQL 8.0. However, I found that
the Beta 3 is much slower than the B2.



To the setup: I use the Win32 version of PGRE SQL8. The table that I am
working with has about 1.1M records in it and is indexed on several columns.
By searching the indexed columns the DB used to be very fast. The data
retrieval used to be more or less instantaneous. In Beta 3 it takes about 4
seconds to retrieve the same amount of data. E.g. I searched for "EAG",
which returns about 50 records. In B2 the retrieval time was less than 1s,
in B3 it's about 3-4 seconds.



Thx,

Enrico

pgsql-bugs by date:

Previous
From: H Chao
Date:
Subject: select() failed in statistics collector
Next
From: Jan Wieck
Date:
Subject: Re: [Slony1-general] Thread-safety detection on HP-UX