TSearch2 performance issue? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject TSearch2 performance issue?
Date
Msg-id 424B7529.3030807@familyhealth.com.au
Whole thread Raw
Responses Re: TSearch2 performance issue?
List pgsql-hackers
I see this in my PQA analyzed PostgreSQL log:

######## Slowest queries
select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid 
= $1

It's my number one slowest query apparently!

Can that lookup perhaps be cached in some way?

I notice that there is no unique index on the oid column, but that 
shouldn't matter for performance since there are only like 6 rows in 
that table.

Also, will this work with default_with_oids = false?  (When the schema 
is initialised.)

Chris



pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: when using a bound cursor, error found..
Next
From: Neil Conway
Date:
Subject: Hash vs. HashJoin nodes