Fw: Indexes?!?!? - Mailing list pgsql-general
From | Nikolay Mijaylov |
---|---|
Subject | Fw: Indexes?!?!? |
Date | |
Msg-id | 004901bf1548$17038b00$ce2a18c3@skillbrokers.bg Whole thread Raw |
List | pgsql-general |
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 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 | | 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 | | mta | xinx606817 | index | | mta | xinx606881 | index | | mta | xinx606913 | index | | mta | xinx606945 | index | | mta | xinx607201 | index | | mta | xinx607265 | index | | mta | xinx607297 | index | | mta | xinx607361 | index | | mta | xinx607393 | index | | mta | xinx607457 | index | | mta | xinx607489 | index | | mta | xinx607553 | index | | mta | xinx607585 | index | | mta | xinx607649 | index | | mta | xinx607681 | index | | mta | xinx607745 | index | | mta | xinx607777 | index | | mta | xinx607841 | index | | mta | xinx607873 | index | | mta | xinx607937 | index | | mta | xinx607969 | index | | mta | xinx608033 | index | | mta | xinx608065 | index | | mta | xinx608129 | index | | mta | xinx608161 | index | | mta | xinx608225 | index | | mta | xinx608257 | index | | mta | xinx608321 | index | | mta | xinx608353 | index | | mta | xinx608417 | index | | mta | xinx608449 | index | | mta | xinx608513 | index | | mta | xinx608545 | index | | mta | xinx608609 | index | | mta | xinx608641 | index | | mta | xinx608705 | index | | mta | xinx608737 | index | | mta | xinx608833 | index | | mta | xinx608897 | index | | mta | xinx608961 | index | | mta | xinx608993 | index | | mta | xinx609057 | index | | mta | xinx609089 | index | | mta | xinx609153 | index | | mta | xinx609185 | index | | mta | xinx609249 | index | | mta | xinx609281 | index | | mta | xinx609345 | index | | mta | xinx609377 | index | | mta | xinx609441 | index | | mta | xinx609473 | index | | mta | xinx609537 | index | | mua | xinx609730 | index | | mua | xinx609762 | index | | mta | xinx609857 | index | | mta | xinx610081 | index | | mta | xinx610305 | index | | mta | xinx610337 | index | | mta | xinx610369 | index | | mta | xinx610497 | index | | mta | xinx610529 | index | | mta | xinx611233 | index | | mta | xinx611361 | index | | mta | xinx611393 | index | | mta | xinx611521 | index | | mta | xinx611585 | index | | mta | xinx611617 | index | | mta | xinx611777 | index | | mta | xinx611841 | index | | mta | xinx611873 | index | | mta | xinx612225 | index | | mta | xinx612321 | index | | mta | xinx612385 | index | | mta | xinx612449 | index | | mta | xinx612577 | index | | mta | xinx612609 | index | | mta | xinx612673 | index | | mta | xinx612705 | 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 by date: