Category "postgresql-11"

Benefit to adding an Index for an order by column?

We have a large table (2.8M rows) where we are finding a single row by our device_token column CREATE TABLE public.rpush_notifications ( id bigint NOT NULL,

Using 'on conflict' with a unique constraint on a table partitioned by date

Given the following table: CREATE TABLE event_partitioned ( customer_id varchar(50) NOT NULL, user_id varchar(50) NOT NULL, event_id varchar(50) NOT

Using 'on conflict' with a unique constraint on a table partitioned by date

Given the following table: CREATE TABLE event_partitioned ( customer_id varchar(50) NOT NULL, user_id varchar(50) NOT NULL, event_id varchar(50) NOT

Postgresql pg_dump for "invalid page in block" database does not work properly

We have setup database postgresql 11 on a system. There are about 8 tables. From few days, we are facing this problem ERROR: invalid page in block 9698 of rela