| From: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
|---|---|
| To: | Matthew Wakeling <matthew(at)flymine(dot)org> |
| Cc: | S Arvind <arvindwill(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Query performance |
| Date: | 2009-10-12 13:40:14 |
| Message-ID: | 2f4958ff0910120640q1f56fcbfg922573a8594320a6@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
2009/10/12 Matthew Wakeling <matthew(at)flymine(dot)org>
> This is an EXPLAIN, not an EXPLAIN ANALYSE. If it was an EXPLAIN ANALYSE,
> it would show how much memory was used, and whether it was a disc sort or an
> in-memory sort. As it is only an EXPLAIN, the query hasn't actually been
> run, and we have no information about whether the sort would be performed on
> disc or not.
>
true, I was looking at it as if it was explain analyze output :)
sorry.
--
GJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michal Szymanski | 2009-10-12 14:14:37 | Performance with sorting and LIMIT on partitioned table |
| Previous Message | Matthew Wakeling | 2009-10-12 13:36:59 | Re: Query performance |