Re: [GENERAL] Find similar records (compare tsvectors)

2015-03-07 Thread Patrick Dung
Thanks. smlar is fast and quite good.I need find tuning on the search result. On Saturday, March 7, 2015 12:07 AM, Oleg Bartunov wrote: On Fri, Mar 6, 2015 at 5:05 PM, Patrick Dung wrote: > Resend. > > How to quickly compare the similarity of two tsvector? > check http://www.sai.ms

Re: [GENERAL] How to get plpython2 in /lib?

2015-03-07 Thread dpopova
Just to let everybody know: happy end! Everything installed and MADlib is successfully registered! Details: 1. Had to use PostgresApp for this installation. No other method worked for my particular case. 2. Had to manually remove several directories and files from my machine, because uninstaller is

Re: [GENERAL] How to get plpython2 in /lib?

2015-03-07 Thread Adrian Klaver
On 03/07/2015 10:09 AM, dpop...@uvic.ca wrote: Thank you so much, Adrian! You are most helpful. :-) I was up at 2 a.m. worrying about my project (just 2 weeks to complete), and by 10 a.m., after installing/uninstalling several times, started questioning everything. I needed a calm voice like you

Re: [GENERAL] How to get plpython2 in /lib?

2015-03-07 Thread dpopova
Thank you so much, Adrian! You are most helpful. :-) I was up at 2 a.m. worrying about my project (just 2 weeks to complete), and by 10 a.m., after installing/uninstalling several times, started questioning everything. I needed a calm voice like yours to tell me that I might be weird, but not comp

Re: [GENERAL] How to get plpython2 in /lib?

2015-03-07 Thread Adrian Klaver
On 03/07/2015 09:52 AM, dpop...@uvic.ca wrote: Adrian, I again wiped out everything postgres from my machine (Mac 10.10.2, Yosemite). Now, if I want to start installing postgres 9.3 anew, what is the best way to go for it? Aah, you anticipated the post I just sent. I found PostgresApp, that

Re: [GENERAL] How to get plpython2 in /lib?

2015-03-07 Thread Adrian Klaver
On 03/06/2015 09:43 PM, dpop...@uvic.ca wrote: Thank you, Adrian. Maybe, you will be able to find something useful. I spent more hours trying to - install PostgreSQL 9.3 (successful, but with python3) - install PostgresApp 9.3 (unsuccessful, could not start postgres, but no matter - no python2 t

Re: [GENERAL] How to get plpython2 in /lib?

2015-03-07 Thread dpopova
Adrian, I again wiped out everything postgres from my machine (Mac 10.10.2, Yosemite). Now, if I want to start installing postgres 9.3 anew, what is the best way to go for it? I found PostgresApp, that promises the easiest way to start using postgres. Does it mean that if I install this PostgresAp

Re: [GENERAL] autovacuum worker running amok - and me too ;)

2015-03-07 Thread wambacher
Hi, some final results: I monitored the vaccum process and logged some data using one big table and doing analyze/vaccum by hand. Table has two btree-indexes and one gin. maintenance_work_mem was 1GB. the analyze job used abot 1.2 GB virt mem during the whole task, no problems at all. The vacu