Re: Drop in insert performance after 20ish seconds

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