Re: [GENERAL] (VERY) Slow Query - PostgreSQL 9.2

2016-05-03 Thread Mike Sofen
From: drum.lu...@gmail.com Sent: Tuesday, May 03, 2016 2:55 AM I'm trying to get the query below a better performance.. but just don't know what else I can do... Please, have a look and let me know if you can help somehow.. also.. if you need some extra data j

Re: [GENERAL] (VERY) Slow Query - PostgreSQL 9.2

2016-05-03 Thread Alban Hertroys
> On 03 May 2016, at 11:55, drum.lu...@gmail.com wrote: > > Hi all, > > I'm trying to get the query below a better performance.. but just don't know > what else I can do... > > Please, have a look and let me know if you can help somehow.. also.. if you > need some extra data jet ask me please

Re: [GENERAL] (VERY) Slow Query - PostgreSQL 9.2

2016-05-03 Thread Bill Moran
On Tue, 3 May 2016 21:55:21 +1200 "drum.lu...@gmail.com" wrote: > Hi all, > > I'm trying to get the query below a better performance.. but just don't > know what else I can do... > > Please, have a look and let me know if you can help somehow.. also.. if you > need some extra data jet ask me pl

[GENERAL] (VERY) Slow Query - PostgreSQL 9.2

2016-05-03 Thread drum.lu...@gmail.com
Hi all, I'm trying to get the query below a better performance.. but just don't know what else I can do... Please, have a look and let me know if you can help somehow.. also.. if you need some extra data jet ask me please. * Note that the gorfs.inode_segments table is 1.7TB size I have the fol