id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc 248,Postgres hangs when trying to load data from a filtered bioassayset,Nicklas Nordborg,Nicklas Nordborg,"A non-filter bioassay set is displaying ok. The SQL for loading the filtered bioassay set is: {{{ SELECT COUNT(*) FROM ""base2"".""dynamic"".""D2624Spot"" ""spt"" INNER JOIN ""base2"".""dynamic"".""D2624Filter"" AS flt ON flt.""cube"" = ""spt"".""cube"" AND flt.""column"" = ""spt"".""column"" AND flt.""position"" = ""spt"".""position"" WHERE ""spt"".""cube"" = 2 AND ""spt"".""layer"" = 1 AND ""flt"".""filter"" = 1 AND ""spt"".""column"" = 1 }}} The SQL for loading the unfiltered bioassay set is the same without the INNER JOIN part: {{{ SELECT COUNT(*) FROM ""base2"".""dynamic"".""D2624Spot"" ""spt"" WHERE ""spt"".""cube"" = 2 AND ""spt"".""layer"" = 1 AND ""spt"".""column"" = 1 }}} ",defect,closed,critical,BASE 2.0,core,,fixed,,