PostgreSQL 8.3 has been released and available for download. PostgreSQL considered as the world’s most advanced open source database. From the announcement page:
This release includes a record number of new and improved features which will greatly enhance PostgreSQL for application designers, database administrators, and users, with more than 280 patches by dozens of PostgreSQL contributors from 18 countries. Version 8.3 provides greater consistency of performance than previous versions, ensuring that every user can depend on the same high performance demonstrated in recent benchmarks for every transaction, whether in peak hours or not, seven days a week, 52 weeks per year. Major performance enhancements include:
-> Heap Only Tuples (HOT), which eliminate up to 3/4 of the maintenance overhead of frequently updated tables
-> Spread checkpoints and background writer autotuning, which reduce the impact of checkpoints on response times
-> Asynchronous commit option for much faster response times on some transactionsThese changes also significantly accelerate transaction processing throughput, between 5% and 30%, depending on the workload.
Download PostgreSQL 8.3 Database Server
=> Visit official project web site to grab PostgreSQL 8.3 Database Server
You may find following document interesting while using PostgreSQL:
- Debian / Ubuntu Linux Install PostgreSQL Database Server
- CentOS / RHEL Linux Install Postgresql Database Server
- PostgreSQL add or create a user account and grant permission for database
- How Do I Enable remote access to PostgreSQL database server?
- Howto Backup PostgreSQL Databases Server With pg_dump command
🐧 Get the latest tutorials on Linux, Open Source & DevOps via:
- RSS feed or Weekly email newsletter
- Share on Twitter • Facebook • 5 comments... add one ↓
| Category | List of Unix and Linux commands |
|---|---|
| File Management | cat |
| Firewall | Alpine Awall • CentOS 8 • OpenSUSE • RHEL 8 • Ubuntu 16.04 • Ubuntu 18.04 • Ubuntu 20.04 |
| Network Utilities | dig • host • ip • nmap |
| OpenVPN | CentOS 7 • CentOS 8 • Debian 10 • Debian 8/9 • Ubuntu 18.04 • Ubuntu 20.04 |
| Package Manager | apk • apt |
| Processes Management | bg • chroot • cron • disown • fg • jobs • killall • kill • pidof • pstree • pwdx • time |
| Searching | grep • whereis • which |
| User Information | groups • id • lastcomm • last • lid/libuser-lid • logname • members • users • whoami • who • w |
| WireGuard VPN | Alpine • CentOS 8 • Debian 10 • Firewall • Ubuntu 20.04 |
I’ll want to know a lot of Postgre
thanks a lot
thanx…postgre makes my works all-done
PostgreSQL *most advanced* open source database.
MySQL *most popular* open source database
Hope this helps!
at one moment you say that MySQL is the most popular open source database and the next moment you say its PostgreSQL. whats the mess here ??