PostgreSQL 9.2 uses less power, works faster
·
Only four months after the first beta version now appears ready to PostgreSQL 9.2. It should be made much faster than its predecessor. Have reached the developers of the free relational database. Primarily through index-only scans which the server if possible answers questions only from the index data, without accessing the actual database tables
Typical data warehouse queries to run PostgreSQL, thanks to this technology 20 times faster than previously. In other queries to read the answer arrive faster: The announcement speaks of 350,000 requests per second, but not the names used for this measurement hardware. Despite the higher throughput is 9.2, consume almost a third less power. This is partly because an idle server wakes up less often than before.
Developers can create new data types for the JavaScript Object Notation (JSON) and use intervals (range). For a JSON column the server checks as for all other data types, whether the incoming data as a string matches the rule. With the functions row_to_json () and array_to_json () is one of PostgreSQL results for further processing in Web applications directly in JSON format:
SELECT row_to_json (demo) FROM demo
-------------------------------------------------- ----------------------- {"username": "johny", "posts": 127, "email address": "johny@nowhere.com"}
As with the INSERT of JSON strings, the column names are used as the attribute identifier.
Ranges can with basic data types such as integer, date or timestamp can be limited to an interval. This interval can be open (the borders are not among them), closed (this includes the boundaries) or semi-open (a limit is one of them, the other not). Ranges can be used as complex constraints, the server checks to see if the values are in the interval. This avoids some double occupancy of rooms. Also you can use it for calculations, around the intersection of two intervals determined.
The release notes summarize the changes in PostgreSQL 9.2 compactly. Describes in more detail the changes in a longer article. On the download page of the project binary packages are available for BSD, Linux, Solaris, Mac OS X and Windows, as well as the source code.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment