Re: [PERFORM] Materialized view performance problems

2016-01-06 Thread Andreas Kretschmer
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 analyse that for the real q

Re: [PERFORM] Materialized view performance problems

2016-01-06 Thread Tom McLoughlin
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 website_id

Re: [PERFORM] Materialized view performance problems

2016-01-06 Thread Andreas Kretschmer
> 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 greatly appreciated. can

[PERFORM] Materialized view performance problems

2016-01-06 Thread Tom McLoughlin
Hello, I'm having trouble with the performance from a query used to create a materialized view. I need to be able to build the keyword_performance_flat_matview view in around 2-4 hours overnight. However, it currently takes in excess of 24 hours. I'm wondering if there is anything I can do to imp