Re: [PERFORM] updating statistics on slow running query

2014-11-10 Thread Eric Ramirez
uffers: shared hit=7369 Total runtime: 10475.240 ms On Mon, Nov 10, 2014 at 1:57 PM, desmodemone wrote: > > > 2014-11-10 18:43 GMT+01:00 Eric Ramirez : > >> >> Hi, >> I have created a sample database with test data to help benchmark our >> application. Th

[PERFORM] updating statistics on slow running query

2014-11-10 Thread Eric Ramirez
Hi, I have created a sample database with test data to help benchmark our application. The database has ten million records, and is running on a dedicated server(postgres 9.3) with 8GB of RAM. Our queries are pretty slow with this amount of data and is my job to get them to run to at acceptable sp