Re: [PERFORM] Simple SQL too slow

On 30 June 2017 20:14:33 GMT+01:00, Daviramos Roussenq Fortunato wrote: >Hi List, > >I have a Server where a simple SQL is taking a long time to return the >results the Server settings are as follows: > >Debian GNU/Linux 7 (wheezy) >CPU: Intel(R) Xeon(R) CPU E5405 @ 2.00GHz >Mem: 16GB

[PERFORM] Simple SQL too slow

Hi List, I have a Server where a simple SQL is taking a long time to return the results the Server settings are as follows: Debian GNU/Linux 7 (wheezy) CPU: Intel(R) Xeon(R) CPU E5405 @ 2.00GHz Mem: 16GB HD: SSG 120 GB Postgresql 9.2 postgresql.conf shared_buffers = 1536MB work_mem =

Re: [PERFORM]

On Thu, Jun 29, 2017 at 12:11 PM, Yevhenii Kurtov wrote: > Hi Jeff, > > That is just a sample data, we are going live in Jun and I don't have > anything real so far. Right now it's 9.6 and it will be a latest stable > available release on the date that we go live. > You need to use your knowled