In this article, we will see the Daily Tips for PostgreSQL.
Tip-1 : Date: 07-Dec-20 Provided By (Linkedin): Ankush Chawla
Public Role and Schema:
👉 This very interesting feature of PostgreSQL.
👉 When a new database is created PostgreSQL by default creates a schema and role named public.
👉 All the new users and roles are by default granted this public role. If a user want to provide an access on particular object to all users 👉 you can grant it to public role it will eventually granted to all users.
👉 Access on Public Schema is also granted to Public Role, and therefore all users can create objects in the public schema.
Tip-2 : Date: 09-Dec-20 Provided By (Linkedin): Ankush Chawla
👉 Temporarydata if are not able to fit in temporary buffers creates Temporary files (for operations such as sorting) within PGDATA/base/pgsql_tmp, or within a pgsql_tmp subdirectory of a tablespace directory.
👉 The name of a temporary file has the form pgsql_tmpPPP.NNN, where PPP is the PID of the owning backend and NNN distinguishes different temporary files of that backend