Jul 23, 2020. Download PostgreSQL packages or installers free from EDB. Get PostgreSQL for Windows, Linux and MacOS platforms. Download 32-bit or 64-bit versions. Download open-source PostgreSQL now. Windows installers Interactive installer by EDB. Download the installer certified by EDB for all supported PostgreSQL versions. This installer includes the PostgreSQL server, pgAdmin; a graphical tool for managing and developing your databases, and StackBuilder; a package manager that can be used to download and install additional PostgreSQL tools and drivers.
Posted on 2016-09-29 by PostgreSQL Global Development Group
PostgreSQL 9.6, the latest version of the world's leading open source database, was released today by the PostgreSQL Global Development Group. This release will allow users to both scale up and scale out high performance database workloads. Download avast for mac error message close firefox. New features include parallel query, synchronous replication improvements, phrase search, and improvements to performance and usability, as well as many more features.
Scale Up with Parallel Query
Version 9.6 adds support for parallelizing some query operations, enabling utilization of several or all of the cores on a server to return query results faster. This release includes parallel sequential (table) scan, aggregation, and joins. Depending on details and available cores, parallelism can speed up big data queries by as much as 32 times faster.
'I migrated our entire genomics data platform - all 25 billion legacy MySQL rows of it - to a single Postgres database, leveraging the row compression abilities of the JSONB datatype, and the excellent GIN, BRIN, and B-tree indexing modes. Now with version 9.6, I expect to harness the parallel query functionality to allow even greater scalability for queries against our rather large tables,' said Mike Sofen, Chief Database Architect, Synthetic Genomics.
Scale Out with Synchronous Replication and postgres_fdw
Two new options have been added to PostgreSQL's synchronous replication feature which allow it to be used to maintain consistent reads across database clusters. First, it now allows configuring groups of synchronous replicas. Second, the 'remote_apply' mode creates a more consistent view of data across multiple nodes. These features support using built-in replication to maintain a set of 'identical' nodes for load-balancing read workloads.
The PostgreSQL-to-PostgreSQL data federation driver, postgres_fdw, has new capabilities to execute work on remote servers. By 'pushing down' sorts, joins, and batch data updates, users can distribute workload across multiple PostgreSQL servers. These features should soon be added to other FDW drivers.
Download sim 4 mac free. 'With the capabilities of remote JOIN, UPDATE and DELETE, Foreign Data Wrappers are now a complete solution for sharing data between other databases and PostgreSQL. For example, PostgreSQL can be used to handle data input going to two or more different kinds of databases,' said Julyanto Sutandang, Director of Business Solutions at Equnix.
Better Text Search with Phrases
PostgreSQL's full text search feature now supports 'phrase search.' This lets users search for exact phrases, or for words within a specified proximity to each other, using fast GIN indexes. Combined with new features for fine-tuning text search options, PostgreSQL is the superior option for 'hybrid search' which puts together relational, JSON, and full text searching.
Smoother, Faster, and Easier to Use
Thanks to feedback and testing by PostgreSQL users with high-volume production databases, the project has been able to improve many aspects of performance and usability in this release. Replication, aggregation, indexing, sorting, and stored procedures have all been made more efficient, and PostgreSQL now makes better use of resources with recent Linux kernels. Administration overhead for large tables and complex workloads was also reduced, especially through improvements to VACUUM.
Other Features
Version 9.6 has many other features added over the last year of development, among them:
Additionally, the project has changed and improved the API for binary hot backups. As such, developers of custom backup software for PostgreSQL should do additional testing around the new version. See the Release Notes for more detail.
LinksPostgreSQL Downloads
PostgreSQL is available for download as ready-to-use packages or installers forvarious platforms, as well as a source code archive if you want to build ityourself.
Packages and Installers
Select your operating system family:
LinuxmacOS Windows Solaris BSD
Select your Linux distribution:
DebianRed Hat/CentOS SUSE Download Postgresql 9.4UbuntuOther Linux
Select your BSD operating system:
OpenBSDFreeBSD NetBSD ![]() Source code
The source code can be found in the main file browseror you can access the source control repository directlyat git.postgresql.org.Instructions for building from source can be found in thedocumentation.
Beta/RC Releases and development snapshots (unstable)
There are source code and binary packagesof beta and release candidates, and of the current development code availablefor testing and evaluation of new features. Note that these builds shouldbe used for testing purposes only, and not for production systems.
3rd party distributionsMachine Learning and Data Visualization with PostgreSQL
Download 2UDA for Windows, macOS, and Linux - certified by 2ndQuadrant for all supported versions of PostgreSQL.
2ndQuadrant Unified Data Analytics (2UDA) is a data analytics application suite that unifies databases, machine learning, data mining, and visualization. The application can be installed using a user-friendly, one-click desktop installer. 2UDA builds on the capabilities of Orange, an open source machine learning and data visualization tool, by integrating it with the PostgreSQL database.
Ready to run stacks
'LAPP', 'MAPP' and 'WAPP' (Linux/Mac/Windows + Apache + PHP + PostgreSQL)stacks are available fromBitNami.
Additional SoftwarePostgres 9.6 Download Mac InstallerSoftware Catalogue
There is much software available that is not bundled with PostgreSQL. The SoftwareCatalogue offers a listing of many commercial and Open Source applications, interfaces and extensions to PostgreSQLthat you may find useful.
If you wish to have your product listed in the catalogue, please fill out this form.
File BrowserDownload Postgresql 12
Download putty software for mac. You can download most of the software we publish from a mirror site using our File Browser.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |