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

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
>
>
> ************

Browse pgsql-general by date

  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