2 ms·

Thanks, I updated the post. The optimizer is definitely aggressive about using bitmap indexes, what I'm after is "how could I creatively restructure this query

Thanks, I updated the post. The optimizer is definitely aggressive about using bitmap indexes, what I'm after is "how could I creatively restructure this query to make them be used," which is likely hard for anyone to comment on without seeing what I'm doing.

jeffdavis 13y ago
"Thanks, I updated the post... In Postgres, it behaves as a DELETE without a where clause..." I think there may still be some confusion. DELETE is an O(n) operation that actually examines the tuples; TRUNCATE is an O(1) operation that doesn't look at any tuples.