As long as you're subscribed to a publication and have push notifications enabled, you'll receive an app notification about any new posts. If you have notifications turned off for a newsletter or section of a publication, you won't receive a notification or see the post in your Inbox.
To completely turn off notifications, head to your Substack Account and click "Edit" next to the publication you'd like to make changes to.
Under "Notifications", uncheck the box next to the newsletter/podcast/section you'd like to stop receiving notifications about.
Note: Turning off all notifications will unsubscribe you from the publication but will not cancel your subscription if you're a paying subscriber. Learn more here on how to cancel your subscription.