| Lists: | pgsql-bugs |
|---|
| 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$cc8e0f6003ddcb@platform.net.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "systems" <systems(at)platform(dot)net(dot)au> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Slow Query |
| Date: | 2003-08-13 13:53:03 |
| Message-ID: | 23323.1060782783@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"systems" <systems(at)platform(dot)net(dot)au> writes:
> 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.
And you are filing this as a bug because ... ?
regards, tom lane