an altarpiece can be as small as a tiny painting put on the wall above a table in someone's home. or it can be so big that it fills the wall of a huge cathedral. the word is usually used for artworks which are quite big. a small painting may be called a "holy picture" or an "icon".