| From: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | "Jan Harders" <jan(at)delinquent(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: increasing LIMIT with ORDER BY changes queryplan (7.4) |
| Date: | 2006-10-18 13:42:29 |
| Message-ID: | b42b73150610180642k7b2b36absba73437557233327@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/18/06, Jan Harders <jan(at)delinquent(dot)de> wrote:
> and, as guessed, takes forever. tried to ANALYZE the table but no change.
> Anyone got any ideas? I just don't understand why it's sorting the values
> while the index should already be sorted...
>
> Oh, btw, I'm on 7.4 (sarge stable version). Could this behaviour change if I
> just upgrade to 8.1?
yes :-) if you're feeling frisky, bite the bullet and give 8.2 a spin!
> any input is appreciated - it's not a critical project but just a private
> one I'm using to get familiar with postgre.
8.1 is smarter with these types of queries and just faster generally.
if that doesn't help, its down to tweaking statistics, etc...note that
I rarely, if ever, resort to that type of optimization.
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2006-10-18 13:56:00 | Re: Moving postgres users accounts from one postgres 7.3 to postgres 8.0 |
| Previous Message | Jan Harders | 2006-10-18 13:35:02 | increasing LIMIT with ORDER BY changes queryplan (7.4) |