|
|
| (15 intermediate revisions by 6 users not shown) |
| Line 1: |
Line 1: |
| {{header|docs}} | | {{header|docs}}{{Docs_beat_open}} |
| | | [[Category:Docs Project]] |
| = <span style="color:red;">Warning - Beat Converted</span> =
| | [[Category:Draft documentation]] |
| {{admon/warning| Beat has already been converted to XML|Be sure to set Wiki Good to '''*''' and In Publican to '''0''' if this beat is modified}} | | [[Category:Documentation beats]] |
| | |
| | |
| | |
| = mysql =
| |
| | |
| Fedora 17 includes '''mysql''' 5.5.20, updated from 5.5.14 in Fedora 16.
| |
| | |
| | |
| = postgresql =
| |
| | |
| '''postgresql''' has been upgraded to 9.1.2
| |
| | |
| {{admon/warning | Potentially Incompatible Change | If you rely on the information_schema.referential_constraints view, or if you have columns of type citext, you may need to take special action. Refer to http://www.postgresql.org/docs/9.1/static/release-9-1-2.html }}
| |
| | |
| This is primarily a bugfix release.
| |
| | |
| | |
| = sqlite =
| |
| | |
| '''sqlite''' has been upgraded to 3.7.9
| |
|
| |
|
| {{admon/warning | Potentially Incompatible Change | If a search token (on the right-hand side of the MATCH operator) in FTS4 begins with "^" then that token must be the first in its field of the document. }}
| | == PostgreSQL 9.4.1 == |
|
| |
|
| There are many changes and improvements:
| | In Fedora 22, the '''postgresql''' packages have been updated to the upstream version 9.4.1, which provides various bug fixes and enhancements described on upstream [http://www.postgresql.org/docs/9.4/static/release-9-4.html 9.4.0 release notes] and [http://www.postgresql.org/docs/9.4/static/release-9-4-1.html 9.4.1 release notes] pages. |
| * Orders of magnitude performance improvement for CREATE INDEX on very large tables.
| |
| * Improved the windows VFS to better defend against interference from anti-virus software.
| |
| * Improved query plan optimization when the DISTINCT keyword is present.
| |
| * Allow more system calls to be overridden in the unix VFS - to provide better support for chromium sandboxes.
| |
| * Increase the default size of a lookahead cache line from 100 to 128 bytes.
| |
| * Enhancements to the test_quota.c module so that it can track preexisting files.
| |
| * Added options SQLITE_DBSTATUS_CACHE_HIT and SQLITE_DBSTATUS_CACHE_MISS to the sqlite3_db_status() interface.
| |
| * Removed support for SQLITE_ENABLE_STAT2, replacing it with the much more capable SQLITE_ENABLE_STAT3 option.
| |
| * Enhancements to the sqlite3_analyzer utility program, including the --pageinfo and --stats options and support for multiplexed databases.
| |
| * Enhance the sqlite3_data_count() interface so that it can be used to determine if SQLITE_DONE has been seen on the prepared statement.
| |
| * Added the SQLITE_FCNTL_OVERWRITE file-control by which the SQLite core indicates to the VFS that the current transaction will overwrite the entire database file.
| |
| * Increase the default lookaside memory allocator allocation size from 100 to 128 bytes.
| |
| * Enhanced the query planner so that it can factor terms in and out of OR expressions in the WHERE clause in an effort to find better indices.
| |
| * Added the SQLITE_DIRECT_OVERFLOW_READ compile-time option, causing overflow pages to be read directly from the database file, bypassing the page cache.
| |
| * Remove limits on the magnitude of precision and width value in the format specifiers of the sqlite3_mprintf() family of string rendering routines.
| |
|
| |
|
| | | Migration to new PostgreSQL version may be done by running of the post-upgrade script <code>postgresql-setup</code> (meaning that you may firstly update your Fedora installation from version 21 to 22 and then perform database stack update). Users are encouraged to do full database dump (for backup purposes) before Fedora upgrade to 22. For more info about migration look into the <code>README.rpm-dist</code> file distributed in <code>postgresql</code> package. |
| [[Category:Docs Project]]
| |
| [[Category:Draft documentation]]
| |
| [[Category:Documentation beats]]
| |
Beat is open
This beat is now ready to have Fedora 25 content added by the beat writer
PostgreSQL 9.4.1
In Fedora 22, the postgresql packages have been updated to the upstream version 9.4.1, which provides various bug fixes and enhancements described on upstream 9.4.0 release notes and 9.4.1 release notes pages.
Migration to new PostgreSQL version may be done by running of the post-upgrade script postgresql-setup (meaning that you may firstly update your Fedora installation from version 21 to 22 and then perform database stack update). Users are encouraged to do full database dump (for backup purposes) before Fedora upgrade to 22. For more info about migration look into the README.rpm-dist file distributed in postgresql package.
