Hello all it’s the annual release time for PostgreSQL Database community.
From the last few years, I have been following PostgreSQL
community and they never disappoint me. And here they are with the promising
power packed features embedded into the popular Open Source Database in the
World. Yes, Its about the PostgreSQL and surely these features make it the MOST
ADVANCED OPEN SOURCE DATABASE in the world.
I have become a big FAN of this Database, Firstly because
its Open Source, Secondly because it
never falls behind the Commercial database in terms of features and also
many few know this, Today’s Most advanced commercial database( Greenplum,
Vertica ,…) come from the PostgreSQL database as the base.
So now moving to Latest Release of PostgreSQL
The latest release in still in the Beta phase and the beta
phase has been launched on June 27th .
This is PostgreSQL 9.3 Beta 2 version and can be downloaded
from http://www.postgresql.org/
This time around we can see feature in all aspects of
PostgreSQL database
New Features
- Configuration
directive 'include_dir'
- COPY
FREEZE for more efficient bulk loading
- Custom
Background Workers
- JSON:
Additional functionality
- LATERAL
JOIN
- Parallel
pg_dump for faster backups
- 'pg_isready'
server monitoring tool
- Switch
to Posix shared memory and mmap()
- Streaming-Only
Remastering
- Fast
Failover
- Architecture-Independent
Streaming
- pg_basebackup
conf setup
With all these changes surely PostgreSQL is eyeing a good place in Database and Datawarehouse Industry. I will go through many of these in my upcoming
blogs…. So stay tuned for interesting blogs ahead
This is an exclusive post about PostgreSQL and the use of foreign data wrapper actually overcomes and helps people solve the most complex problems and errors.
ReplyDeleteSSIS PostgreSql Write