create table input_table(
	id BIGINT PRIMARY KEY NOT NULL DEFAULT nextval('input_table_seq'),
	req_id VARCHAR(300) NOT NULL,
	m_id VARCHAR(300) NOT NULL,
	type VARCHAR(100) NOT NULL,
	user_id BIGINT NOT NULL,
	body TEXT NOT NULL,
	status SMALLINT NOT NULL,
	create_time TIMESTAMP NOT NULL,
	update_time TIMESTAMP NOT NULL
);

CREATE UNIQUE INDEX idx_uniq_requests_m_id on requests (m_id);


create table parsed_table(
	id BIGINT PRIMARY KEY NOT NULL DEFAULT nextval('parsed_table_seq'),
	m_id VARCHAR(500) NOT NULL,
	type SMALLINT,
	user_id BIGINT	NOT NULL CONSTRAINT fk_users_pt_uid REFERENCES users(id),
        send_id BIGINT	CONSTRAINT fk_users_pt_sid REFERENCES users(id),
	body TEXT,
	size INT,
	status SMALLINT NOT NULL,
	create_time TIMESTAMP NOT NULL,
	update_time TIMESTAMP NOT NULL
);

CREATE UNIQUE INDEX idx_uniq_m_id ON parsed_table(m_id);
CREATE INDEX idx_status 	 ON parsed_table(status);
CREATE INDEX idx_user_id	 ON parsed_table(user_id);
CREATE INDEX idx_user_id_send_id_status_type ON parsed_table(user_id, send_id, status, type);

DELETE FROM parsed_table
WHERE user_id = 10 AND send_id = 2 AND type = 2 AND status = 1

#------------------------------------------------------------------------------
# AUTOVACUUM PARAMETERS
#------------------------------------------------------------------------------

autovacuum = on			# Enable autovacuum subprocess?  'on'
					# requires track_counts to also be on.
log_autovacuum_min_duration = 100	# -1 disables, 0 logs all actions and
					# their durations, > 0 logs only
					# actions running at least this number
					# of milliseconds.
autovacuum_max_workers = 3		# max number of autovacuum subprocesses
					# (change requires restart)
autovacuum_naptime = 20s		# time between autovacuum runs
autovacuum_vacuum_threshold = 50	# min number of row updates before
					# vacuum
autovacuum_analyze_threshold = 50	# min number of row updates before
					# analyze
autovacuum_vacuum_scale_factor = 0.2	# fraction of table size before vacuum
autovacuum_analyze_scale_factor = 0.1	# fraction of table size before analyze
autovacuum_freeze_max_age = 100000000	# maximum XID age before forced vacuum
					# (change requires restart)
#autovacuum_multixact_freeze_max_age = 400000000	# maximum multixact age
					# before forced vacuum
					# (change requires restart)
autovacuum_vacuum_cost_delay = 60ms	# default vacuum cost delay for
					# autovacuum, in milliseconds;
					# -1 means use vacuum_cost_delay
autovacuum_vacuum_cost_limit = -1	# default vacuum cost limit for
					# autovacuum, -1 means use
					# vacuum_cost_limit

По железу: 4 ядра, 16 гб оперативы. SSD диски.
На нем крутиться и БД, и приложение.