Fw: [GENERAL] Fw: Indexes?!?!? AGAIN!!!!

Поиск
Список
Период
Сортировка
От Nikolay Mijaylov
Тема Fw: [GENERAL] Fw: Indexes?!?!? AGAIN!!!!
Дата
Msg-id 004701bf165c$e12a20a0$ce2a18c3@skillbrokers.bg
обсуждение исходный текст
Список pgsql-general
I have a problems with list, so I;ll explaine again:
--------------------------------

Hi all I making a project (Free EMail:) with a table that contain many
LargeObjects (BLOb's)
when i look the database I saw that there are REALLY A LOT OF STRANGE
INDEXES:
 santo=> \d mboxes_att

Table    = mboxes_att
+----------------------------------+----------------------------------+-----
--+
|              Field               |              Type                |
Length|
+----------------------------------+----------------------------------+-----
--+
| mail_id                          | int4 not null                    |
4 |
| id                               | int4 not null default nextval('m |
4 |
| filename                         | varchar() not null               |
250 |
| content_type                     | varchar() not null default 'unkn |
200 |
| binary_object                    | oid not null                     |
4 |
| size                             | int4                             |
4 |
+----------------------------------+----------------------------------+-----
--+
Indices:  mboxes_att_id_key
          mboxes_att_pk

> santo=> \d
>
> Database    = santo
>  +------------------+----------------------------------+----------+
>  |  Owner           |             Relation             |   Type   |
>  +------------------+----------------------------------+----------+
>  | postgres         | banners                          | table    |
>  | postgres         | banners_id_seq                   | sequence |
>  | postgres         | banners_pkey                     | index    |
>  | postgres         | domains                          | table    |
>  | postgres         | domains_pkey                     | index    |
>  | postgres         | folders                          | table    |
>  | postgres         | folders_pkey                     | index    |
>  | postgres         | folders_seq                      | sequence |
>  | postgres         | mboxes                           | table    |
>  | postgres         | mboxes_att                       | table    |
>  | postgres         | mboxes_att_id_key                | index    |
>  | postgres         | mboxes_att_id_seq                | sequence |
>  | postgres         | mboxes_att_pk                    | index    |
>  | postgres         | mboxes_pkey                      | index    |
>  | postgres         | mboxes_seq                       | sequence |
>  | postgres         | sessions                         | table    |
>  | postgres         | sessions_pkey                    | index    |
>  | postgres         | userdata                         | table    |
>  | postgres         | userdata_pkey                    | index    |
>  | postgres         | users                            | table    |
>  | postgres         | users_name_key                   | index    |
>  | postgres         | users_pkey                       | index    |
>  | postgres         | users_seq                        | sequence |
>  | mta              | xinx605281                       | index    |
>  | mta              | xinx605345                       | index    |
>  | mta              | xinx605409                       | index    |
>  | mta              | xinx605473                       | index    |
>  | mta              | xinx605537                       | index    |
>  | mta              | xinx605697                       | index    |
>  | mta              | xinx605985                       | index    |
>  | mta              | xinx606049                       | index    |
>  | mta              | xinx606113                       | index    |
>  | mta              | xinx606177                       | index    |
>
> OK THERE WAS A LOTS OF THEM BUT The list reject my message, so i delete a
> couple of them.
>
>  | mta              | xinx606273                       | index    |
>  | mta              | xinx606305                       | index    |
>  | mta              | xinx606369                       | index    |
>  | mta              | xinx606401                       | index    |
>  | mta              | xinx606497                       | index    |
>  | mta              | xinx606529                       | index    |
>  | mta              | xinx606593                       | index    |
>  | mta              | xinx606625                       | index    |
>  | mta              | xinx606689                       | index    |
>  | mta              | xinx606753                       | index
>  +------------------+----------------------------------+----------+
> santo=>
>
> "mta" is user that works with the base.
>
> Whats happen??? First I thought that every LargeObject is index, but now
in
> table i have no more than 5 or 6 LargeObjects
>
> HELP????
>
> nmmm
>
>
> ************


В списке pgsql-general по дате отправления:

Предыдущее
От: "Nikolay Mijaylov"
Дата:
Сообщение: Re: [GENERAL] insert BLOB
Следующее
От: Nicolas Huillard
Дата:
Сообщение: RE: [GENERAL] insert BLOB