Skip site navigation (1) Skip section navigation (2)

Re: gin/gist indexes show twice

From: Timon <timosha(at)gmail(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: gin/gist indexes show twice
Date: 2011-03-28 08:57:48
Message-ID: AANLkTin3PjMwLV29s9ux=qACFUGqhfNfhng8HsB0D29h@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
yup, seem that problem is not with git/gist indexes.
I have found the query for this grid in file
pgadmin/schema/pgIndex.cpp line 670.

I run this query in Sql Query tool and get same results:
SELECT
	indexrelname,
	idx_scan, idx_tup_read, idx_tup_fetch,
	pg_size_pretty(pg_relation_size(indexrelid)),
	refclassid, refobjid, deptype,
	refclassid::regclass, refobjid::regclass
FROM pg_stat_all_indexes stat
	JOIN pg_class cls ON cls.oid=indexrelid
	LEFT JOIN pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid
= cls.oid AND dep.refobjsubid = '0')
--	LEFT OUTER JOIN pg_constraint con ON (con.tableoid = dep.refclassid
AND con.oid = dep.refobjid)
WHERE schemaname = 'public'
	AND
	stat.relname = 'user_attr_text'
	--AND con.contype IS NULL
ORDER BY indexrelname

idx_fts;0;0;0;28 MB;3602;11335;n;pg_ts_config;11335
idx_fts;0;0;0;28 MB;1259;159262085;a;pg_class;user_attr_text
idx_length;0;0;0;4528 kB;1259;159262085;a;pg_class;user_attr_text
trgm_idx;0;0;0;126 MB;2616;24936297;n;pg_opclass;24936297
trgm_idx;0;0;0;126 MB;1259;159262085;a;pg_class;user_attr_text
user_attr_text_pkey;16;16;16;39 MB;2606;159262089;i;pg_constraint;159262089

my indexes:
CREATE INDEX idx_fts
  ON user_attr_text
  USING gin
  (strip(to_tsvector('russian'::regconfig, about::text)))
  WHERE about IS NOT NULL;

CREATE INDEX trgm_idx
  ON user_attr_text
  USING gin
  (lower(about::text) gin_trgm_ops)
  WHERE about IS NOT NULL;

this is on latest working version from git repo.

2011/3/28 Guillaume Lelarge <guillaume(at)lelarge(dot)info>:
> Le 24/03/2011 07:21, Timon a écrit :
>> gin and gist indexes show twice in indexes list grid of table.
>> Watch attachment
>>
>
> Just tried, didn't reproduce it.
>
> Care to share more info? like pgAdmin's release number. This issue
> reminds me something, but I don't find what.
> --
> Guillaume
>  http://www.postgresql.fr
>  http://dalibo.com
>



-- 
All bugs reserved

In response to

Responses

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2011-03-28 09:28:25
Subject: Re: gin/gist indexes show twice
Previous:From: TimonDate: 2011-03-28 07:08:10
Subject: Re: Debugger crashes when setting a value with quotes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group