| From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: The planner chooses seqscan+sort when there is an |
| Date: | 2006-05-04 08:36:41 |
| Message-ID: | 1146731801.14093.193.camel@coppola.muc.ecircle.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> There are a number of ways you can (indirectly) see how far it has got.
> If it's in the first phase (the seq scan), by looking at which file it
> has open you should be able to see how far along the table it is. Once
> it's in the sort stage you should be able to see from the tape files
> approimately how far it is. As for the number of sort stages required,
> that depends on the size of the data to be sorted, but you should be
> able to estimate that...
>
> At least, you should be able to tell the difference between a 6 hour and
> 6 day query.
Thanks for the hints, I'll try to look up on the details...
Cheers,
Csaba.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2006-05-04 09:02:51 | Re: psql is slow and it does not take much resources |
| Previous Message | Martijn van Oosterhout | 2006-05-04 08:18:17 | Re: The planner chooses seqscan+sort when there is an |