[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

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