| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | Tim Perdue <tperdue(at)valinux(dot)com> |
| Cc: | Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Serious Performance Loss in 7.0.2?? |
| Date: | 2000-07-12 16:11:32 |
| Message-ID: | Pine.BSF.4.21.0007121311020.1325-100000@thelab.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 12 Jul 2000, Tim Perdue wrote:
> Andrew McMillan wrote:
> > PostgreSQL seems to not get the index choice right when you have index
> > matches that are like =, =, =, DESC so you actually need to specify the
> > ORDER BY clause in full like:
> > ORDER BY mail_list DESC, mail_year DESC, mail_month DESC, mail_date
> > DESC
> > and things will hopefully be all OK again.
>
> Wow - that definitely does *not* work. That took 1:30 to return the
> result for the linux-kernel list.
>
> My server has a load of 19.25 right now - at 6 AM.
Ouch! because of that query, or is this standard? what is the server,
anyway?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2000-07-12 16:13:07 | Re: Vacuum only with 20% old tuples |
| Previous Message | The Hermit Hacker | 2000-07-12 16:08:31 | Re: 7.0.2 issues / Geocrawler |