On Fri, June 3, 2011 13:57, tv@xxxxxxxx wrote: > See this http://explain.depesz.com/s/THh > > > There's something very wrong with snames - the planner expects 22 rows but > gets 164147851. Which probably causes a bad plan choice or something like that. > Try to analyze the snames table (and maybe increase the statistics > target on the columns). Thanks - like you say, looks like the interesting bit is: rows=22 --> rows=164147851 for table snames. Nice online tool you have there my china! Cheers Henry -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
