On Wed, Dec 28, 2011 at 3:02 PM, Matteo Beccati <php@xxxxxxxxxxx> wrote: > The query eventually completed in more than 18h. For comparison a normal > run doesn't take more than 1m for that specific step. > > Do you think that bad stats and suboptimal plan alone could explain such > a behaviour? Did you get the explain analyze output? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance