2016
May
15
comment Postgresql Filter Slows Query
@AbelistoWhat's wrong with the types here? They are actually both text types
May
15
comment Postgresql Filter Slows Query
@ypercubeᵀᴹ No indices, but I wouldn't think that would matter on a filter. The types of all the columns are text (various length VARCHARs). Also interesting is that this query runs fine locally, and there is no Materialize block in the output of EXPLAIN. It's only in an AWS RDS provisioned database that it's slow. Here's the full output of EXPLAIN locally: gist.github.com/cderwin/e0a393f4f0d597f1afecff375bd5de9e
May
13
revised Postgresql Filter Slows Query
update
May
13
awarded  Editor
May
13
revised Postgresql Filter Slows Query
added 1 character in body
May
13
awarded  Student
May
13
awarded  Autobiographer
May
13
asked Postgresql Filter Slows Query