| From: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Christian Schröder <cs(at)deriva(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance of full outer join in 8.3 |
| Date: | 2009-04-15 12:31:33 |
| Message-ID: | 2f4958ff0904150531h32358fex5cb705472abd271e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Wed, Apr 15, 2009 at 1:25 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> The cost of the query seems accurate, so the absence of
> attachment_isins_attachment_idx on the 8.3 plan looks to be the reason.
> There's no way it would choose to scan 8115133 rows on the pkey if the
> other index was available and usable.
hance my question, if there's index on it in 8.3 version of db.
--
GJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | William Temperley | 2009-04-15 13:27:12 | Re: Disconnected editing - versioning of databases |
| Previous Message | SongDongyan | 2009-04-15 12:30:29 | a question about postgresql server connection |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2009-04-15 13:31:08 | Re: Replacing plpgsql's lexer |
| Previous Message | Andrew Dunstan | 2009-04-15 12:27:38 | Re: Replacing plpgsql's lexer |