Slow Query

From: "systems" <systems(at)platform(dot)net(dot)au>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Slow Query
Date: 2003-08-13 01:47:03
Message-ID: 009b01c3613c$cc8e0f60$3103ddcb@platform.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

When I ran a query using postgres 7.3.2 it took over 2 hours to run.
I upgraded to version 7.3.4 and the same query takes 5 minutes.
This was with absolutely no changes to indexes or any of the queries.

I used the default install, and didn't tweak any settings in postgresql.conf

Kernel version: Solaris 5.9 Generic 112233-06 March 2003
kernel architecture: sun4u
Application architecture: sparc
Memory: 256Mb
compiler: gcc version 3.1

regards,
Ross George.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Donald Fraser 2003-08-13 10:40:08 Partial Indexes condtions
Previous Message Tom Lane 2003-08-12 20:04:59 Re: UNIQUE INDEX difference between 7.2 and 7.3