Current environment
- Ubuntu 18.04
- PostgreSQL 13.1
- PostGIS 3.x.x + obsolete SFCGAL(somehow it was installed with PostGIS)
Target
- PostgreSQL 14.x
- Postgis 3.x.x
#!/bin/bash | |
### steps #### | |
# verify the system has a cuda-capable gpu | |
# download and install the nvidia cuda toolkit and cudnn | |
# setup environmental variables | |
# verify the installation | |
### | |
### to verify your gpu is cuda enable check |
Here is a list of cuda graphics cards for use with your favorite applications.
https://github.com/search?o=desc&q=cuda&s=stars&type=Repositories
ProductName | BusType | MemorySize | GpuClock | MemoryClock | CudaCores |
---|---|---|---|---|---|
RTX A40 | PCIe 4.0 x16 | 48 GB | 1305 MHz | 1812 MHz | 10752 |
RTX A6000 | PCIe 4.0 x16 | 48 GB | 1455 MHz | 2000 MHz | 10752 |
PostgreSQL Type | PostgreSQL Size | Description | Range | Diesel Type | Rust Type |
---|---|---|---|---|---|
Nullable Types | nullable | Nullable `` |
(Dijkstra and plain A* are generally not included here as there are thousands of | |
implementations, though I've made an exception for rare Ruby and Crystal versions, | |
and for Thor, Mapzen's enhanced A*. ) | |
A* Ruby https://github.com/georgian-se/shortest-path | |
A* Crystal https://github.com/petoem/a-star.cr | |
A* (bidirectional with shortcuts) C++ https://github.com/valhalla/valhalla | |
NBA* JS https://github.com/anvaka/ngraph.path | |
NBA* Java https://github.com/coderodde/GraphSearchPal | |
NBA* Java https://github.com/coderodde/FunkyPathfinding |
import ( | |
"net/http" | |
"sync" | |
"fmt" | |
) | |
type logBuffer struct { | |
stuff string | |
} |
package main | |
import ( | |
"context" | |
"log" | |
"net/http" | |
"os" | |
"os/signal" | |
"time" | |
) |
/** | |
* Copyright 2012 Akseli Palén. | |
* Created 2012-07-15. | |
* Licensed under the MIT license. | |
* | |
* <license> | |
* Permission is hereby granted, free of charge, to any person obtaining | |
* a copy of this software and associated documentation files | |
* (the "Software"), to deal in the Software without restriction, | |
* including without limitation the rights to use, copy, modify, merge, |