Re: [PERFORM] Materialized view performance problems

> Tom McLoughlin hat am 6. Januar 2016 um 09:08 > geschrieben: > > > > As you can see below it's a big query, and I didn't want to overwhelm > everyone with the schema, so let me know what bits you might need to help! > > Any help improving the performance will be

Re: [PERFORM] Materialized view performance problems

Thank you very much for your help. It's difficult for me to run analyse explain for the query given because it takes so long. However, the query below has a similar structure but has less data to process. create materialized view temp_camp_perf_unaggr as select account_websites.id as

Re: [PERFORM] Materialized view performance problems

Tom McLoughlin wrote: > Thank you very much for your help. > > It's difficult for me to run analyse explain for the query given because it > takes so long. However, the query below has a similar structure but has less > data to process. Seems okay, but it's better to