Re: [PERFORM] tsearch2 seem very slow

2005-09-25 Thread Ahmad Fajar
12 AM To: Ahmad Fajar Cc: pgsql-performance@postgresql.org Subject: RE: [PERFORM] tsearch2 seem very slow Ahmad, On Mon, 26 Sep 2005, Ahmad Fajar wrote: > Hi Oleg, > >> what king of garbage ? Probably you index not needed token types, for >> example, email address, file nam

Re: [PERFORM] tsearch2 seem very slow

2005-09-25 Thread Oleg Bartunov
Ahmad, On Mon, 26 Sep 2005, Ahmad Fajar wrote: Hi Oleg, what king of garbage ? Probably you index not needed token types, for example, email address, file names do you need proximity ? If no, use strip(tsvector) function to remove coordinate information from tsvector. I need proximit

Re: [PERFORM] tsearch2 seem very slow

2005-09-25 Thread Ahmad Fajar
Hi Oleg, > what king of garbage ? Probably you index not needed token types, for > example, email address, file names > do you need proximity ? If no, use strip(tsvector) function to remove > coordinate information from tsvector. I need proximity. Some time I have to rank my article and mak

Re: [PERFORM] tsearch2 seem very slow

2005-09-25 Thread Oleg Bartunov
though reiserfs is fast enough for postgresql. And must I down grade my postgresql from version 8.0.3 to 7.4.8? I'm not experienced with filesystems :) Regards, ahmad fajar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oleg Bartunov Sent: Satu

Re: [PERFORM] tsearch2 seem very slow

2005-09-25 Thread Ahmad Fajar
7.4.8? Regards, ahmad fajar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oleg Bartunov Sent: Saturday, September 24, 2005 1:08 PM To: Ahmad Fajar Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] tsearch2 seem very slow Ahmad, what's about the n

Re: [PERFORM] tsearch2 seem very slow

2005-09-23 Thread Oleg Bartunov
tgresql data and the partition is EXT3 1x80 GB EIDE 7200 RPM configure for system and home directory and the partiton is EXT3 Did I miss something? Regards, ahmad fajar -Original Message- From: Oleg Bartunov [mailto:[EMAIL PROTECTED] Sent: Jumat, 23 September 2005 18:26 To: Ahmad Fajar

Re: [PERFORM] tsearch2 seem very slow

2005-09-23 Thread Ahmad Fajar
ta and the partition is EXT3 1x80 GB EIDE 7200 RPM configure for system and home directory and the partiton is EXT3 Did I miss something? Regards, ahmad fajar -Original Message- From: Oleg Bartunov [mailto:[EMAIL PROTECTED] Sent: Jumat, 23 September 2005 18:26 To: Ahmad Fajar Cc:

Re: [PERFORM] tsearch2 seem very slow

2005-09-23 Thread Oleg Bartunov
of your queries, so we can't help you. How big is your database, tsearch2 index size ? Regards, ahmad fajar -Original Message- From: Oleg Bartunov [mailto:[EMAIL PROTECTED] Sent: Jumat, 23 September 2005 14:36 To: Ahmad Fajar Cc: pgsql-performance@postgresql.org Subject: Re: [PER

Re: [PERFORM] tsearch2 seem very slow

2005-09-23 Thread Oleg Bartunov
Ahmad, how fast is repeated runs ? First time system could be very slow. Also, have you checked my page http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_Notes and some info about tsearch2 internals http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_internals Oleg On Thu

[PERFORM] tsearch2 seem very slow

2005-09-22 Thread Ahmad Fajar
I have about 419804 rows in my article table. I have installed tsearch2 and its gist index correctly. My table structure is: CREATE TABLE tbarticles (   articleid int4 NOT NULL,   title varchar(250),   mediaid int4,   datee date,   content text,   contentvar text,   mmcol float4