Hi I'm trying to implement a text search in PG .
My goal to enable the user search on several columns also on partial words.
here is sample code :
create table test_test( text_data tsvector, text_a varchar,text_b varchar);
insert into test_test(text_a,text_b) select 'name 10.10.2.3 ','name3 nam
-- Forwarded message -
From: amihay gonen
Date: Tue, 24 Feb 2015 09:07
Subject: Re: [GENERAL] : Getting error while starting the server
To: Raghavendra
Check postgresql conf file where the socket file is created.
On Tue, 24 Feb 2015 08:42 Raghavendra
wrote:
> ret
puts in a tab. I hope this might be of some
> help, though I don't really see how.
>
> On Mon, Jan 26, 2015 at 10:21 AM, amihay gonen wrote:
>
>> Hi on 9.1 the psql did auto complete for tables. I've removed 9.1 and
>> installed 9.4 and the auto complete does
Hi on 9.1 the psql did auto complete for tables. I've removed 9.1 and
installed 9.4 and the auto complete doesn't work.
Any idea what I need to check?
-- Forwarded message -
From: amihay gonen
Date: Thu, 15 Jan 2015 13:37
Subject: What is the best way to model attributes relations ?
To: pgsql-general
I need to support the following queries :
1. give all documents where attrib X='value'
2. give me all docum
I need to support the following queries :
1. give all documents where attrib X='value'
2. give me all documents where attib X='value' and attrib Y='value2'
the distinct attributes if about 10,000,000,000 on about 10 difference
type (X,Y etc), so in average 1000 M for each.
each attribut
My goal is to implement a new index type base on bitmap index algorithm.
I've to main problems :
1. How to get "Target list" - list of columns need to be returned from
query on the index.
I want to implement index only access , today the indexer api get row-id
and then PG retrive the data fro
