--- Herv� wrote:
> George,
>
> I have well read many pages about this subject ... but I have not found any
> thing for the moment to really help me ...
> What can I do to optimize my PostgreSQL configuration for a special use of
> Tsearch2 ...
> I'm a little dispointed looking the Postgresql Ru
George,
Le Jeudi 26 Août 2004 19:58, George Essig a écrit :
> Bill Footcow wrote:
>
> ...
>
> > I have done a simple request, looking for title or description having
> > Postgres inside order by rank and date, like this :
> > SELECT a.title, a.id, a.url, to_char(a.r_date, 'DD/MM/ HH24:MI:SS')
Le Jeudi 26 Août 2004 19:48, Josh Berkus a écrit :
> Herve'
>
> > (cost=0.00..4052.84 rows=1351 width=166) (actual time=109.766..5415.108
> > rows=139 loops=1)
> > Index Cond: (idxfti @@ '\'postgresql\''::tsquery)
> > Filter: (idxfti @@ '\'postgresql\''::ts
Bill Footcow wrote:
...
> I have done a simple request, looking for title or description having Postgres
> inside order by rank and date, like this :
> SELECT a.title, a.id, a.url, to_char(a.r_date, 'DD/MM/ HH24:MI:SS') as dt,
> s.site_name, s.id_site, case when exists (select id_user from
Herve'
> (cost=0.00..4052.84 rows=1351 width=166) (actual time=109.766..5415.108
> rows=139 loops=1)
> Index Cond: (idxfti @@ '\'postgresql\''::tsquery)
> Filter: (idxfti @@ '\'postgresql\''::tsquery)
>From this, it looks like your FTI index isn't fitting
Josh,
Le Jeudi 26 Août 2004 01:50, Josh Berkus a écrit :
> > The request takes about 4 seconds ... I have about 1 400 000 records in
> > article and 36 000 records in site table ... it's a Bi-Pentium III 933
> > MHz server with 1 Gb memory ... I'm using Postgresql 7.4.5
> > For me this result is v
Herve'
> The request takes about 4 seconds ... I have about 1 400 000 records in
> article and 36 000 records in site table ... it's a Bi-Pentium III 933 MHz
> server with 1 Gb memory ... I'm using Postgresql 7.4.5
> For me this result is very very slow I really need a quicker result with
> less t
Hi,
I'm a little beginner with Tsearch2
I have simples tables like this :
# \d article
Table "public.article"
Column |Type |
Modifiers
+-+---