On Wed, May 09, 2001 at 10:31:27AM +0200, Renaud Thonnart wrote:
> Does PostgreSQL create an index when a table is created?
Yes, with PK.
> Does it create index even if there is no PK for this table?
No.
> I know that indexes increase performance for SELECT but it is the
> contrary when INSERT because the index must be actualised every time,
> isn't it?
Yes.
> How can I see all the index that PostgreSQL have implicitly create?
You can, from psql, do:
# \d table_name
This order shows all info about a table, including existing indexes.
> How can I delete them in keeping integrity in the database?
drop index?...
Greets.
David