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 по дате отправления: