Re: Drop in insert performance after 20ish seconds - Mailing list pgsql-novice

Hello,

postgres=# \d pg_test_messages
                                        Table "public.pg_test_messages"
  Column   |            Type             | Collation | Nullable |                  
Default
-----------+-----------------------------+-----------+----------+----------------------------------------------
 Id        | bigint                      |           | not null |
nextval('pg_test_messages_id_seq'::regclass)
 Message   | text                        |           | not null |
 TimeStamp | timestamp without time zone |           |          |
Indexes:
    "PK_pg_test_messages" PRIMARY KEY, btree ("Id")
    "IX_pg_test_messages_Id" btree ("Id")

It seems you have 2 indexes on "Id" columns, as this column is not null and
also primary key,
"IX_pg_test_messages_Id" is not needed. I would drop it and test again.

Regards
PAscal



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-novice-f2132464.html