Re: [GENERAL] Aggregate query on large tables

2017-04-09 Thread Adrian Klaver
On 04/09/2017 08:05 AM, Job wrote: Hi, i have a table with about 400 millions of rows and i need to build some aggregate function for reporting. I noticed that query performances are slowing down, even though indexes are present. Query is simple (i make an example, my table is in italian lang

Re: [GENERAL] Aggregate query on large tables

2017-04-09 Thread Bill Moran
On Sun, 9 Apr 2017 17:05:56 +0200 Job wrote: > Hi, > > i have a table with about 400 millions of rows and i need to build some > aggregate function for reporting. > I noticed that query performances are slowing down, even though indexes are > present. > > Query is simple (i make an example, m

[GENERAL] Aggregate query on large tables

2017-04-09 Thread Job
Hi, i have a table with about 400 millions of rows and i need to build some aggregate function for reporting. I noticed that query performances are slowing down, even though indexes are present. Query is simple (i make an example, my table is in italian language): select a,sum(b) from table whe