I have some little questions about indexes :

Does PostgreSQL create an index when a table is created?
Does it create index even if there is no PK for this table?
If yes, why?
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?
How can I see all the index that PostgreSQL have implicitly create?
How can I delete them in keeping integrity in the database?

If someone could answer these questions, I thank him in advance.

Sincerly, Renaud THONNART

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.***.com/

        # \d table_name

 This order shows all info about a table, including existing indexes.

 Greets.

                                David

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Renaud THONNART

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

http://www.ca.postgresql.org/users-lounge/docs/7.1/reference/sql-crea...
.html
says:
PRIMARY KEY Constraint
Notes:
Postgres automatically creates a unique index to assure data integrity (see
CREATE INDEX statement).

Frank

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command