Внимание на  3  строчку!


INFO:  vacuuming "public.tags"
INFO:  index "tags_pkey" now contains  32  row versions in  12339  pages
DETAIL:   12264  index pages have been deleted,  12264  are currently reusable.
CPU  0 .05s/ 0 .03u sec elapsed  0 . 59  sec.
INFO:  index "tags_title_key" now contains  32  row versions in  23160  pages
DETAIL:   23060  index pages have been deleted,  20000  are currently reusable.
CPU  0 .14s/ 0 .09u sec elapsed  5 . 57  sec.
INFO:  index "PKey" now contains  32  row versions in  9238  pages
DETAIL:   9176  index pages have been deleted,  9176  are currently reusable.
CPU  0 .07s/ 0 .03u sec elapsed  0 . 75  sec.
INFO:  "tags": found  0  removable,  32  nonremovable row versions in  227  pages
DETAIL:   0  dead row versions cannot be removed yet.
There were  31585  unused item pointers.
 0  pages are entirely empty.
CPU  0 .26s/ 0 .15u sec elapsed  6 . 93  sec.

CREATE TABLE tags
(
  title character varying( 50 ),
  tag_id integer NOT NULL DEFAULT nextval('tags_seq'::text),
  cnt integer NOT NULL DEFAULT  0 ,
  CONSTRAINT tags_pkey PRIMARY KEY (tag_id),
  CONSTRAINT tags_title_key UNIQUE (title)
) 
WITHOUT OIDS;
ALTER TABLE tags OWNER TO postgres;


-- Index: "PKey"

-- DROP INDEX "PKey";

CREATE INDEX "PKey"
  ON tags
  USING btree
  (tag_id);