You could use GeoAlchemy + Full Text Search (FTS). It can probably increase the speed of your queries. However, it seems that FTS needs to be adapted to do such work in GA. I put below some links that may give you some more insights on both tools:

GeoAlchemy:


http://frankpurcell.com/code/tutorial
http://www.geoalchemy.org/_sources/tutorial.txt
https://github.com/geoalchemy/geoalchemy/tree/master/examples
https://geoalchemy-2.readthedocs.org/en/latest/orm_tutorial.html


FTS (with SqlAlchemy, but it's already adapted to SA as a patch):


http://nibrahim.net.in/2013/11/29/sqlalchemy_and_full_text_searching_in_postgresql.html


GIN/GiST Full Text searches through openlayers, geoserver and postgres
I am developing an API in Unix environment for virtual machines. Most of the modules are developed in python. I have few questions on this.

I have the file extension as abc.py. I would like to make this as a command. For example , virtman dominfo [vmid] should be the command syntax. Now I have to give ./virtman.py dominfo [vmid] to achieve this.  And I have first line as #!/usr/bin/python in the python file. So how can make this as a command?

My echo $PATH looks like '/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin0'

I read a lot of articles but I didn't get the clear picture,so any hints/suggestions would be helpful.
