I wanted to understand how the WAL file internally looks -like is the below sequence one is correct. Transaction required->WAL logfile->WAL records->WAL segments ( each segements divided of 16MB size say ex)-> each segments have Pages(8KB) Also I would like…
I'm hoping to get some help on how to speed up an SQL query. To give you some context, here's an outline of the related db structure: table instruments - instruments have isin, trading_venue, start_trading_date, end_trading_date; one and the same…
I have 2 subqueries which give me a result consisting of dates. I would like to calculate the difference between them. For example: SELECT DATEDIFF( DAY, (SELECT MAX(invoices.date) FROM invoices WHERE invoices.orderno = odH.orderno), (SELECT min(history.date) FROM history WHERE history.orderno…
I want to make a full search query on a spécific value of my jsonb like the format of the json is : { "highlights": { "concise": null, "complete": null }, "gist": { "concise": [ { "text": "", "isHighlighted": false,…
I have the following table in Postgres: adjustments table id (pk) property_id value created_on_utc I would like to create a query that will get the top X most recent records based on the created_on_utc column and then group and count…
I'm having a reoccurring error in my SQL statement, and I cannot figure out how to fix it. The ERROR: syntax error at or near "WHERE" is not very helpful as well. This is the code snippet in question: INSERT…
Let's assume I have a table with 3 columns: Id, Value, date Time. I need to find the min, max, first and last value of each 1 minute window between the provided start and end time. And in case no…
The following SQL works well; it gives me the result I want for the counts and percentage: (please use EXTRACT (YEAR|MONTH|DAY ...) where required): SELECT YEAR(evt_date) AS yr, MONTH(evt_date) AS mth, DAY(evt_date) AS dy, COUNT(*) AS cnt, ROUND(COUNT(*)*100 / (SUM(COUNT(*))…
In Postgres when logical replication is hanging on conflict you can read pending WAL entries and see which row is conflicting as well as check LSN of that transaction using pg_logical_slot_peek_changes. There is possibility to skip failing LSN but in…
I have a problem with my Django database. When I enter: python manage.py makemigrations. I got this exception: AttributeError: module 'django.db.models' has no attribute 'PointField'. Here is my very simple code that cause the issue: from django.db import models import…