Question : LINK TO FIDDLE: https://www.db-fiddle.com/f/a6FXTqJHpU9smuJTUKqwuV/0 My tables are as follows: => d ops; Table “public.ops” Column | Type | […]
Chat schema for PostgreSQL and MongoDB
Question : I’m designing a schema for a very large chat app. I had problems with NoSQL databases such as […]
PostgreSQL Database Migration
Question : How can I migrate data from on PostgreSQL database to another PostgreSQL database? Is there any technique to […]
How PostgresSQL stores duplicated VARCHAR values in a column
Question : I have a VARCHAR(255) column in a table with about 50 million rows. In that column there is […]
How to edit `postgresql.conf` with pgAdmin 4?
Question : Same Question as this: How to edit postgresql.conf with pgAdmin 3? but updated for the completely new (total […]
Recovering a dropped table in PostgreSQL
Question : I have : CREATE TABLE ketoan_vn.Customers ( CustomerId character varying(10) NOT NULL, CustomerName character varying(150), CONSTRAINT Customers_PK_CustomerID PRIMARY […]
Is there anything wrong with splitting a complicated view into many small ones?
Question : I have a view where each row is associated with a customer, and the columns are various computed […]
iterate through Postgres enum values?
Question : I have a Postgres enumerated type used to describe the node class (order sensitive) of a source/destination relationship […]
What does it mean there is multiple sources in a SELECT’s “FROM” clause? [duplicate]
Question : This question already has answers here: What does [FROM x, y] mean in Postgres? (2 answers) Closed 4 […]
Finding by ID in postgresql very slow on big table
Question : I have videos table with 18M rows. When I search for particular video by ID, it takes up […]