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] Filter certain range of IP address.

2017-04-10 Thread vinny
On 2017-04-07 17:29, David G. Johnston wrote: On Fri, Apr 7, 2017 at 8:18 AM, Dinesh Chandra 12108 wrote: Dear Vinny, Thanks for your valuable replay. but I need a select query, which select only that record which starts from IP "172.23.110" only from below table. xxx 172.23.110.175 yyy