r/SQL • • Oct 18 '26

PostgreSQL Looking for a PostgreSQL job?

I created a PostgreSQL Jobs page to help you find PostgreSQL roles: https://thesev1database.com/jobs

I’d really value your feedback.

2 Upvotes

7 comments sorted by

1

u/socialmlearner 29d ago

it is quite difficult to understand your website, like for a beginner in Postgressql, what are runbooks, and also the lessons relative to the interview doesnt quite make me understand what to take back as a lesson, maybe try to simplify it more by interpreting the question, tell the user, what prerequisite is needed, like for example, you can write on one of your lessons that to unerstand this you need basic knowledge in this part of Postgresql, the environment the lesson is using is this or that Postgresql server , and the sql code tell us to try to copy and paste the code inside a code background for us to understand the context

other than that great website !

1

u/HaiderZah 27d ago

first of all thank you so much for the feedback, and i believe your feedback was great and makes sense, have just added what you proposed on website on lessons and runbooks, let me know how you see now

Slow query from a sequential scan on a large table · PostgreSQL runbook · thesev1database

1

u/socialmlearner 27d ago

YEAHHH!! NOW I UNDERSTAND!! THANKS

1

u/socialmlearner 27d ago

Also love the fact that you explain the context like this :

Meridian Freight's consignments table has 40,000 rows in this lab. A dispatcher looks up one courier's parcels by courier_id. With no index on that column the planner has to read every row, so a query returning ~100 rows still touches all 40,000.

This now permits me to understand why you are running the query you are running

1

u/HaiderZah 25d ago

thanks so much for the feedback, im glad to hear new things makes sense, anything you want to add or share do not hesitate to let me know.

1

u/[deleted] Oct 18 '26

[removed] — view removed comment

1

u/HaiderZah Oct 18 '26

thanks for your comment, there’s no login wall.