Re: [PERFORM] Understanding PostgreSQL query execution time

2017-04-10 Thread vinny
On 2017-04-07 16:56, Haider Ali wrote: Hello I want to understand execution time of a query in PostgreSQL then I want to relate it to the problem i am getting. According to my observation ( I can't explain why this happen ) whenever we query a table first time its execution will be high (sometim

Re: [PERFORM] Understanding PostgreSQL query execution time

2017-04-07 Thread Gerardo Herzig
- Mensaje original - > De: "Haider Ali" > Para: pgsql-performance@postgresql.org > Enviados: Viernes, 7 de Abril 2017 11:56:53 > Asunto: [PERFORM] Understanding PostgreSQL query execution time > > > Hello > > > I want to understand execut

Re: [PERFORM] Understanding PostgreSQL query execution time

2017-04-07 Thread l...@laurent-hasson.com
#x27; behavior again. As for AWS, not sure, but likely about memory and config more than latency. Sent from my BlackBerry 10 smartphone. From: Haider Ali Sent: Friday, April 7, 2017 09:58 To: pgsql-performance@postgresql.org Subject: [PERFORM] Understanding PostgreSQL query execution time Hello

[PERFORM] Understanding PostgreSQL query execution time

2017-04-07 Thread Haider Ali
Hello I want to understand execution time of a query in PostgreSQL then I want to relate it to the problem i am getting. According to my observation ( I can't explain why this happen ) whenever we query a table first time its execution will be high (sometimes very high) as compare to queries made