Timeline for Match rows from different tables by comparing similar lat lon coordinates
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 21, 2023 at 11:10 | vote | accept | dancesWithCycles | ||
| Jun 2, 2023 at 12:56 | comment | added | geozelot |
@dancesWithCycles Do you have a GIST index on tbl_stops_2? Don't forget to run VACUUM ANALYZE on both tables, just in case but necessarily after creating a missing index.
|
|
| Jun 2, 2023 at 12:50 | comment | added | dancesWithCycles |
I updated about 50 thousand columns from table tbl_stops_1 with about 800 thousand columns from table tbl_stops_2 which took about half a day on a single core virtual machine with about 10 gigabytes of main memory with the processor being the limiting factor. Any ideas how to speed up this update?
|
|
| May 25, 2023 at 14:32 | history | answered | geozelot | CC BY-SA 4.0 |