Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: postgis

Diffrence in result from PostgreSQL (PostGIS) and SQL Server (Spatial)

By adminPosted on January 3, 2023

Question : I have two points and I have to calculate difference between them. I using below query in SQL […]

Change owner of relation in PostgreSQL database

By adminPosted on December 29, 2022

Question : I just started using PostgreSQL and have problems in changing the ownwer of a table. I have a […]

Why does this PostGIS query take so long to run?

By adminPosted on December 18, 2022

Question : I am new to PostGIS and SQL in general. I am running a query on polygons which, I […]

Deciding the best way to partition (Postgresql)

By adminPosted on December 7, 2022

Question : I have been trying to research this for quite a while now and I am having a hard […]

How to verify that at least one point fall into a polygon with Postgis?

By adminPosted on December 4, 2022

Question : I have two tables where table A has a geometry (4326) column that contains surfaces (~20M). A second […]

Can’t get this PostgreSQL query to run faster

By adminPosted on November 29, 2022

Question : I’m running PostgreSQL 9.6 with PostGIS 2.3.3 I’m trying to make this rather critical query go faster (looking […]

SQL query: insert values into polygon where features of the polygon intersects another polygon [closed]

By adminPosted on November 24, 2022

Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]

Using SELECT to call a function in a jdbc migration

By adminPosted on November 21, 2022

Question : I’m looking to set up some Postgres/PostGIS migrations with clojure/jdbc. running side-effect functions with SELECT is proving to […]

Finding road segements which are not split at intersection.(Query Optimization )

By adminPosted on November 19, 2022

Question : I have a query in which I am trying to find the road segments which intersect but are […]

Set field values to newly imported rows in PostgreSQL table with existing data

By adminPosted on November 2, 2022

Question : I have a PostgreSQL table with existing data, and needs to import all the rows in a CSV […]

  • 1
  • 2
  • 3
  • …
  • 13

Recent Posts

  • Order of returned rows with IN statement
  • Do not want to allow Queries to take more than x minutes?
  • How would i create a report involving multiple many to many relationships
  • web interface port for oracle 11g
  • Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL
  • How can I check if a user have a quota on tablespace
  • Can alias in SQL Server contain slash?
  • Why store /var/lib/mysql when you can just create SQL dumps for backup purposes?
  • Fix OGR2OGR “failed when converting the varchar value to data type int” issue in the MSSQL table –
  • Sum on distinct and group by
  • Is a join optimized to a where clause at runtime?
  • Simple select is taking too long
  • GROUP BY with subqueries for a Group?
  • SERVERPROPERTY(‘Edition’) AS [Edition]
  • Do MySQL sub-queries essentially use as much overhead as separate queries?
  • select fieldvalues and column-description of a table
  • Secure database access from particular applications
  • How to optimize and estimate DB recovery times?
  • How to make a FULLTEXT search with ORDER BY fast?
  • De-duplicate rows in place vs de-duplicate on transfer

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding