From: | "Nikolay Mijaylov" <nmmm(at)nmmm(dot)nu> |
---|---|
To: | "pgsql-general" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Fw: [GENERAL] Fw: Indexes?!?!? AGAIN!!!! |
Date: | 1999-10-14 15:57:50 |
Message-ID: | 004701bf165c$e12a20a0$ce2a18c3@skillbrokers.bg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
>
>
> ************
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolas Huillard | 1999-10-14 16:08:11 | RE: [GENERAL] Another access control query |
Previous Message | Nikolay Mijaylov | 1999-10-14 15:49:11 | Re: [GENERAL] insert BLOB |