Re: Refresh Materialized View Issue

[Jeremiah Bauer <jbauer@xxxxxxxxxxxxx>]

My question is: what indexes are on public.large_table?  Hopefully there's a compound b-tree index on id1, id2, id3.

There is not, after further investigation.  There are these 4 indexes that involve id1, id2, and id3.  Should I try creating an index on all three of the columns?

CREATE INDEX IF NOT EXISTS idx_large_table_id1

    ON public.large_table USING btree

    (id1 ASC NULLS LAST)

    TABLESPACE pg_default;

CREATE INDEX IF NOT EXISTS idx_large_table_id2

    ON public.large_table USING btree

    (id2 ASC NULLS LAST)

    TABLESPACE pg_default;

CREATE INDEX IF NOT EXISTS idx_large_table_id3

    ON public.large_table USING btree

    (id3 ASC NULLS LAST)

    TABLESPACE pg_default;

CREATE INDEX IF NOT EXISTS idx_large_table_id2_id3

    ON public.large_table USING btree

    (id2 ASC NULLS LAST, id3 ASC NULLS LAST)

    TABLESPACE pg_default;

A materialized view isn't too different from an unlogged table. 

So an unlogged table would also be an appropriate solution?

--

Jeremiah

CONFIDENTIALITY NOTICE: The information contained in this email (and any attachments) is privileged and confidential and protected from disclosure. If you are not the intended recipient of this email or the attachments, be aware that any disclosure, copying, distribution or use of this email or any attachment is strictly prohibited and you should not read the message or read or open any attachment. If you have received this email by mistake, please immediately notify the sender and delete it permanently from your system. Agri Stats, Inc. and its subsidiaries will not be held liable to any person or entity resulting from the unintended or unauthorized use of any information contained in this email.