From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: TSearch2 performance issue? |
Date: | 2005-03-31 10:46:43 |
Message-ID: | 424BD513.4070502@sigaev.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Christopher Kings-Lynne wrote:
> 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?
It's cached. This select should run only one time per connection for each used
dictionary. If its'not then it's a bug. I'll check it.
>
> 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.)
All pg_ts_* tables are created with 'with oids' option.
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Sherry | 2005-03-31 10:47:12 | Re: ARC patent |
Previous Message | Christopher Kings-Lynne | 2005-03-31 09:06:06 | Bug in DROP NOT NULL |