[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

[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

[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.e. boxes, circles, polygons, not points) with SP-GiST by mapping to 4d-space

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