Create table as takes hours

Help Me!

I'm doing a query that uses similarity functions to fuzzy match columns in a table against itself. Its pretty expensive as its essentially cartesian joins though I do have some equality matches to help out. It takes about 3 minutes to run.

However I executed a create table as (query) command and that 3 minute query took 14 hours to run, which it did eventually finish. I want to change the parameters of my similarity but I feel there has to be a way to reduce the difference in time between the query execution and the create table execution.

Any ideas?

Posted Oct 10, 2024, 9:18 PM UTC

121

Comments aren't archived yet

This post had 21 comments on Reddit. Comments for this period haven't been loaded into the archive yet.