Re: [PERFORM] Filter certain range of IP address.

2017-04-07 Thread Moreno Andreo
Il 07/04/2017 17:56, Rick Otten ha scritto: On Fri, Apr 7, 2017 at 11:29 AM, David G. Johnston wrote: On Fri, Apr 7, 2017 at 8:18

Re: [PERFORM] Filter certain range of IP address.

2017-04-07 Thread Dinesh Chandra 12108
Thanks. It’s working fine. Thank you so much Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida. -- Mobile: +91-9953975849 | Ext 1078 |dinesh.chan...@cyient.com

Re: [PERFORM] Filter certain range of IP address.

2017-04-07 Thread Rick Otten
On Fri, Apr 7, 2017 at 11:29 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Apr 7, 2017 at 8:18 AM, Dinesh Chandra 12108 < > dinesh.chan...@cyient.com> wrote: > >> Dear Vinny, >> >> Thanks for your valuable replay. >> >> but I need a select query, which select only that recor

Re: [PERFORM] Filter certain range of IP address.

2017-04-07 Thread David G. Johnston
On Fri, Apr 7, 2017 at 8:18 AM, Dinesh Chandra 12108 < dinesh.chan...@cyient.com> 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 1

Re: [PERFORM] Filter certain range of IP address.

2017-04-07 Thread Dinesh Chandra 12108
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 172.23.110.178 zzz 172.23.110.177 aaa 172.23.110.176 bbb 172.23.111.180 ccc 172.23.115.26

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 execution time of a query in PostgreSQL then I > wan

Re: [PERFORM] Understanding PostgreSQL query execution time

2017-04-07 Thread l...@laurent-hasson.com
The first behavior is very likely just caching. The plan and results from the query are cached, so the second time, it's reused directly. If you ran a bunch of other queries in the middle and effectively exhausted the cache, then back to your query, likely tou'd see the 'slow' behavior again. A

[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

Re: [PERFORM] Filter certain range of IP address.

2017-04-07 Thread vinny
On 2017-04-07 16:13, Dinesh Chandra 12108 wrote: Hi expert, May I know how to select a range of IP address. Example: I have number of different-2 IP's present in a table. I HAVE TO SELECT ONLY THAT IP ADDRESS WHICH DOES NOT START FROM PREFIX “172.23.110”. Thanks in advance REGARDS, DINESH C

[PERFORM] Filter certain range of IP address.

2017-04-07 Thread Dinesh Chandra 12108
Hi expert, May I know how to select a range of IP address. Example: I have number of different-2 IP's present in a table. I have to select only that IP address which does not start from prefix "172.23.110". Thanks in advance Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)|