Re: [HACKERS] [ADMIN] Security question : Database access control

2002-10-23 Thread dima
edit *pg_hba.conf * # Allow any user on the local system to connect to any # database under any username, but only via an IP connection: host all 127.0.0.1 255.255.255.255trust # The same, over Unix-socket connections: local

[HACKERS] Improve perfomance for index search ANY(ARRAY[]) condition with single item

2017-07-23 Thread Dima Pavlov
Hello, The problems I tried to solve here: 1. Improve perfomance for index search ANY(ARRAY[...]) condition with single item 2. I saw tons of users code like: if len(array) == 1: sql += '{}'.format(array[0]) else: sql += 'ANY(ARRAY[{}])'.format(array) So there will be less lines of code and it wil

[HACKERS] GSoC 2015: SP-GIST for geometrical objects

2015-03-27 Thread Dima Ivanovskiy
Hello, I am Dmitrii, student of Moscow Institute of Physics and Technology Abstract: I chose project "Indexing prolonged geometrical objects (i.e. boxes, circles, polygons, not points) with SP-GiST by mapping to 4d-space". According to the presentation https://www.pgcon.org/2011/schedule/attach

[HACKERS] Re[2]: [HACKERS] GSoC 2015: SP-GIST for geometrical objects

2015-03-27 Thread Dima Ivanovskiy
>On Mar 27, 2015 11:08 AM, "Dima Ivanovskiy" < dima...@mail.ru > wrote: >> >> Hello, I am Dmitrii, student of Moscow Institute of Physics and Technology >> >> Abstract: >> >> I chose project "Indexing prolonged geometrical objects (i.