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

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

From: silly_sad <sad(at)bankir(dot)ru>
To: Nikolay Samokhvalov <nikolay(at)samokhvalov(dot)com>
Cc: pgsql-ru-general(at)postgresql(dot)org
Subject: Re: Чудо дивное планировщик явил !!!
Date: 2007-03-29 05:21:44
Message-ID: 460B4CE8.3030600@bankir.ru (view raw or flat)
Thread:
Lists: 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)

In response to

pgsql-ru-general by date

Next:From: silly_sadDate: 2007-03-29 06:02:49
Subject: Re: Чудо дивное планировщик явил !!!
Previous:From: silly_sadDate: 2007-03-28 13:50:16
Subject: Re: Чудо дивное планировщик явил !!!

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