Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? - Mailing list pgsql-performance

From Pavel Stehule
Subject Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?
Date
Msg-id 162867791002100111n3cbf2164p5b9907d82174ba9@mail.gmail.com
Whole thread Raw
In response to Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?  (Bryce Nesbitt <bryce2@obviously.com>)
List pgsql-performance
Tree view 
2010/2/10 Bryce Nesbitt <bryce2@obviously.com>:
> Or, if you want to actually read that query plan, try:
> http://explain.depesz.com/s/qYq
>

hello,

check your work_mem sesttings. Hash join is very slow in your case.

Pavel

>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

pgsql-performance by date:

Previous
From: Bryce Nesbitt
Date:
Subject: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?
Next
From: Franck Routier
Date:
Subject: Deferred constraint and delete performance