Indexes?!?!?
| От | Nikolay Mijaylov |
|---|---|
| Тема | Indexes?!?!? |
| Дата | |
| Msg-id | 003f01bf14cf$3c27f2a0$ce2a18c3@skillbrokers.bg обсуждение исходный текст |
| Список | 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=>
+------------------+----------------------------------+----------+
| 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 по дате отправления: