Fw: Indexes?!?!?

From: "Nikolay Mijaylov" <nmmm(at)nmmm(dot)nu>
To: "pgsql-general" <pgsql-general(at)postgreSQL(dot)org>
Subject: Fw: Indexes?!?!?
Date: 1999-10-13 07:37:31
Message-ID: 007b01bf154d$d2c42c00$ce2a18c3@skillbrokers.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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 |
>
> OK THERE WAS A LOTS OF THEM BUT The list reject my message, so i delete a
> couple of them.
>
> | 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 Dirk Lutzebaeck 1999-10-13 07:39:22 Re: [GENERAL] Perl DBI + binary data in psql not working
Previous Message Nikolay Mijaylov 1999-10-13 07:19:04 Fw: Indexes?!?!?