Re: [PERFORM] Very slow query (3-4mn) on a table with 25millions rows

2016-07-26 Thread Abadie Lana
Hi Tom, Thanks for the hints.. I made various tests for index The best I could get is the following one with create index vat_funcvaratt_multi_idx on functionalvarattributes(split_part(split_part(attvalue,' ',1),'.',1), tag_id, atttype_id); analyze functionalvarattributes; explain analyze sele

Re: [PERFORM] Very slow query (3-4mn) on a table with 25millions rows

2016-07-26 Thread Martín Marqués
El 26/07/16 a las 06:01, Abadie Lana escribió: > Hi Tom, > Thanks for the hints.. > > I made various tests for index > The best I could get is the following one with > create index vat_funcvaratt_multi_idx on > functionalvarattributes(split_part(split_part(attvalue,' ',1),'.',1), tag_id, > attt

Re: [PERFORM] Very slow query (3-4mn) on a table with 25millions rows

2016-07-26 Thread Abadie Lana
Dear Martin I run an analyse on the whole database + explicit analyse on tables involved in the query. Here the result of explain (analyse, buffer). Thanks for your help and let me know if you need more information. explain (analyze, buffers) select s.attvalue from functionalvarattributes s, ta