Re: Чудо дивное планировщик явил !!!

Nikolay Samokhvalov wrote:
> А можно схему таблиц посмотреть?

Можно, но она большая.
Поэтому если чо, я могу рассказать.

article.up references article.id
article.topic references topic.id
topic.up references topic.id

Схема ниже, кому не интересно может не читать.

\d topic

Column | Type |
Modifiers
-------------+-----------------------------+---------------------------------------------------------------------
id | integer | not null
name | text | not null
realm | text | not null
guid | text |
usr | text | not null
grp | text | not null
acl | row_acl | not null
created | timestamp without time zone | not null default now()
creator | text | not null
updated | timestamp without time zone | not null default now()
updater | text | not null
exported | timestamp without time zone | not null default
'1970-01-01 00:00:00'::timestamp without time zone
vector | tsvector |
up | integer |
trail | ltree | not null
layer | integer | not null
pid | integer | not null default 0
score | integer | not null default 0
title | text | not null default ''::text
description | text | not null default ''::text
extra | text | not null default ''::text
revision | integer | not null default 0
Indexes:
"topic_pkey" PRIMARY KEY, btree (id)
"topic_guid_idx" UNIQUE, btree (guid)
"topic_name_key" UNIQUE, btree (name, pid)
"topic_acl_idx" gist (acl)
"topic_grp_idx" btree (grp)
"topic_layer_idx" btree (layer)
"topic_realm_idx" btree (realm)
"topic_trail_idx" gist (trail)
"topic_up_idx" btree (up)
"topic_usr_idx" btree (usr)
"topic_vector_key" gist (vector)

\d article

Column | Type |
Modifiers
----------+-----------------------------+-----------------------------------------------------------------------
id | integer | not null
name | text | not null
realm | text | not null
guid | text |
usr | text | not null
grp | text | not null
acl | row_acl | not null
created | timestamp without time zone | not null default now()
creator | text | not null
updated | timestamp without time zone | not null default now()
updater | text | not null
exported | timestamp without time zone | not null default '1970-01-01
00:00:00'::timestamp without time zone
vector | tsvector |
up | integer |
trail | ltree | not null
layer | integer | not null
pid | integer | not null default 0
topic | integer | not null
title | text | not null default ''::text
abstract | text | not null default ''::text
content | text | not null default ''::text
author | text | not null default ''::text
start | timestamp without time zone | not null default now()
stop | timestamp without time zone | not null default
(date_trunc('day'::text, now()) + '1 day'::interval)
extra | text | not null default ''::text
revision | integer | not null default 0
locked | timestamp without time zone | not null default
'infinity'::timestamp without time zone
locker | text | not null default 'anonymous'::text
score | integer | not null default 0
type | integer | not null default 0
section | integer[] | not null default '{}'::integer[]
Indexes:
"article_pkey" PRIMARY KEY, btree (id)
"article_guid_idx" UNIQUE, btree (guid)
"article_name_key" UNIQUE, btree (name, topic)
"article_acl_idx" gist (acl)
"article_grp_idx" btree (grp)
"article_layer_idx" btree (layer)
"article_realm_idx" btree (realm)
"article_section_idx" gist (section)
"article_topic_idx" btree (topic)
"article_trail_idx" gist (trail)
"article_up_idx" btree (up)
"article_usr_idx" btree (usr)
"article_vector_key" gist (vector)