Re: Чудо дивное планировщик явил !!!
От | silly_sad |
---|---|
Тема | Re: Чудо дивное планировщик явил !!! |
Дата | |
Msg-id | 460B4CE8.3030600@bankir.ru обсуждение исходный текст |
Ответ на | Подвисший запрос (isk <isk@rdw.ru>) |
Список | pgsql-ru-general |
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)
В списке pgsql-ru-general по дате отправления: