Muhammad Imtiaz’s Post

Optimizing Space Utilization in PostgreSQL: Strategies for Efficient Free Space Management https://zurl.co/DiZ8 #PostgreSQL #SQL #DBA #MySQL #Oracle #SQLServer #OLTP #RDBMS

Optimizing Space Utilization in PostgreSQL: Strategies for Efficient Free Space Management https://zurl.co/DiZ8 #PostgreSQL #SQL #DBA #MySQL #Oracle #SQLServer #OLTP #RDBMS

The QA-engineering is not about the framework but about the mindset. -- Call Ragnarok by eating all server connections CREATE SERVER midgard_fdw     FOREIGN DATA WRAPPER postgres_fdw     OPTIONS (host 'midgard.no', port '5432', dbname 'jormungandr'); CREATE USER MAPPING FOR jormungandr     SERVER midgard_fdw     OPTIONS (user 'ouroboros', password 'ouroboros');   CREATE FOREIGN TABLE midgard.sormr (head bigint, tail bigint) SERVER midgard_fdw OPTIONS (schema_name 'midgard', table_name 'sormr');   SELECT * FROM midgard.sormr;

Postgres 17beta1 vs a cached Insert Benchmark on a large server * no regressions * results are even better with the patch to enforce VISITED_PAGES_LIMIT during get_actual_variable_range https://lnkd.in/gCkDNmnj

🔥Deal of the Week Alert! 🔥 Get ready to supercharge your Feeds stack with the amazing Feeds - DB Pack, now at a deeply discounted rate of only $37.46! That's a whopping 25% off the regular price of $49.95! This addon pack lets you add databases as your data source for the Feeds stack. It supports a variety of databases including MySQL, MariaDB, PostgreSQL, SQLite, and SQLServer. Remember, you must purchase the Feeds stack in order to use this addon pack. #StacksPro #NoCode Grab this deal before it ends!

Loading the World! OpenStreetMap Import In Under 4 Hours Advancements in hardware, Postgres, and software are making large data loads easier than ever. Greg Smith has a new blog on loading OpenStreetMap in record time. The full world OpenStreetMap import is a notoriously big process to run in a Postgres database. Folks often plan on a full 24 hour process. Greg has it running in 4 hours! Pretty impressive. He's improved several hours just in the last few Postgres releases. Check out all the details in our blog today: https://lnkd.in/gFQAPUbm

Generate tiles directly from your database using #PostGIS`s ST_AsMVT and ST_AsMVTGeom functions. Connecting to the database via the intuitive GUI in MapTiler Server is really easy too. (Advanced users can still use SQL if they want!) Learn more: https://buff.ly/3TU8rhq #WebMaps #PostGRES

#SQL #SERVER – Find #Stored #Procedure Related to Table in #Database – Search in All Stored Procedure Following code will help to find all the Stored Procedures (SP) which are related to one or more specific tables. sp_help and sp_depends does not always return accurate results. ----Option 1 SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id WHERE sc.TEXT LIKE '%tablename%' ----Option 2 SELECT DISTINCT o.name, o.xtype FROM syscomments c INNER JOIN sysobjects o ON c.id=o.id WHERE c.TEXT LIKE '%tablename%'

Got another video in my tutorial series out. This time we're going over how to migrate from the starter SQLite database that Strapi gives us to a remote PostgreSQL database hosted on Neon. Free version works fine. This will allow us to continue deploying Strapi on Render's free tier without worrying about losing our data. Combined with the free tier on Cloudinary for media/file storage, this allows us to host a fully free Strapi backend for a blog. Next video I'll finish wiring up our Gatsby frontend to the newly deployed backend. https://lnkd.in/gZYxa-_g #strapi #neon #postgresql #postgres #sqlite #database

One of the things I love about Supabase is they keep on open sourcing awesome tools that solve everyday Postgres problems in a elegant and easy to use way. In this video Jon Meyers walks through some solving some performance and security issues using index_advisor and splinter which have now been open sourced and integrated into Supabases web based Supabase Studio. In particular I was really excited to see PostgreSQL index advisor in action. This is a Postgres extension that can determine if a given query should have an index or not. Even if you're experienced with databases, this seems super handy for optimization work. https://lnkd.in/gkz35_mM