collections_bookmark Series

Postgres Tips

Short postgres tips that you can use every day

6 posts

schedule Apr 8, 2021 · 2 min read

How to generate dummy data in postgres?

Lets create an employee table with id, name and salary columns and load some data, Create a dummy table CREATE TABLE public.employee ( id int8 NOT NULL, name varchar(120) NOT NULL, salary int8 NOT NULL, CONSTRAINT emp_pk PRIMARY KEY (...

hashnodebootcamp PostgreSQL Programming Tips Databases

schedule Apr 9, 2021 · 4 min read

Postrgres vacuum 101

VACUUM in postgres in a garbage collection utility which is used to reclaim storage space occupied by the records that are stale due to update or delete operations. Whenever a row is deleted or updated, the old row becomes invisible to all other tra...

hashnodebootcamp PostgreSQL Databases 2Articles1Week

schedule Apr 20, 2021 · 3 min read

Offset based pagination in postgres

Imagine you have one million records in a table and you have to display them in a web page. Would you fetch 1 million records in a one shot and send it through an API? Probably not. Offset based pagination is one of the most common technique for fetc...

PostgreSQL Databases 2Articles1Week APIs

schedule Apr 21, 2021 · 2 min read

How to implement keyset based pagination in postgres?

Imagine you have one million record in a table, and you need to display them in a web page. Would you fetch 1 million records in a one shot and send it through an API? Probably not. Offset based pagination is one of the most common technique for fetc...

PostgreSQL 2Articles1Week Databases

schedule Apr 22, 2021 · 2 min read

How to set application_name for psql command line utility?

The application_name configuration is used to identify a database client from postgres backend. It is extremely useful in debugging client issues and connection resource consumption by client using the application_name. Backend servers use connectio...

PostgreSQL Databases Programming Tips

schedule Jul 5, 2021 · 6 min read

Posgres materialized views

In this article, we will learn about what is materialized views in postgres and when to use it, what you need to know before you use it and how to implement materialized view with an example. What is a view? Postgres view is a virtual table defined ...

PostgreSQL Databases Data Science