Listing Links for tag PostgreSQL

PostgreSQL x

Tags

see all

GitHub - jimjonesbr/nominatim_fdw: PostgreSQL Extension to harvest and resolve addresses from Nominatim servers (github.com)

PostgreSQL Nominatim Foreign Data Wrapper OpenStreetMap SQL Docker

The nominatim_fdw is a PostgreSQL extension facilitating the harvesting and resolution of addresses from Nominatim servers. It enables PostgreSQL databases to seamlessly interact with Nominatim servers through a set of SQL commands and functions, supporting a range of operations from server creation to data retrieval. The extension can also be deployed using Docker.
Main Points
- nominatim_fdw OverviewNominatim Foreign Data Wrapper (nominatim_fdw) enables PostgreSQL to access data from Nominatim servers efficiently.
- FunctionalityIt offers streamlined operations like CREATE SERVER, ALTER SERVER, and various functions to directly interact with Nominatim data.
- Deployment Optionsnominatim_fdw can be deployed traditionally or via Docker, ensuring flexibility in the deployment process.
12

200

47

63
Look ma, I wrote a new JIT compiler for PostgreSQL – Pinaraf's website (www.pinaraf.info)

PostgreSQL JIT Compiler programming Database Technology

The article discusses the creation of pg-copyjit, a new JIT compiler for PostgreSQL developed by the author after being inspired by a recently proposed JIT compiler construction methodology. It explores the limitations of using LLVM for JIT compilation in PostgreSQL and introduces the advantages of the copy-and-patch methodology used by pg-copyjit. The author shares insights into the current performance of pg-copyjit, as well as future goals for optimization and expanding architecture support. Links to a research paper that inspired the project, the project’s GitHub repository, and a mentioned tool, PoWA, are also provided.
Main Points
- Introduction of pg-copyjitThe author introduced pg-copyjit, a new JIT compiler for PostgreSQL, inspired by a new compiler construction methodology.
- Copy-and-patch methodologypg-copyjit is designed using a copy-and-patch methodology, allowing for faster query execution compared to traditional JIT compilers like LLVM.
- Performance and future plansThe current implementation of pg-copyjit shows significant performance improvements and plans for future optimization and support for multiple architectures are outlined.
- Limitations of LLVMThe limitations and challenges of using LLVM for JIT compilation in PostgreSQL were highlighted, including its expensive optimization process.
12

200

47

63