Tsearch2 full-text indexing. [Online version] of this document is available. The tsearch2 module is available to add as an extension to the PostgreSQL database to allow for Full Text Indexing. This document is an introduction to installing, configuring, using and maintaining the database with the tsearch2 module activated. Please, note, tsearch2 module is fully incompatible with old tsearch, which is deprecated in 7.4 and will be obsoleted in 7.5. This documentation is provided as a short guide on how to quickly get up and running with tsearch2 and PostgreSQL, for those who want to implement a full text indexed based search engine.
It is not meant to be a complete in-depth guide into the full ins and outs of the contrib/tsearch2 module, and is primarily aimed at beginners who want to speed up searching of large text fields, or those migrating from other database systems such as MS-SQL. The README.tsearch2 file included in the contrib/tsearch2 directory contains a brief overview and history behind tsearch. PostGIS Manual. Abstract PostGIS is an extension to the PostgreSQL object-relational database system which allows GIS (Geographic Information Systems) objects to be stored in the database. PostGIS includes support for GiST-based R-Tree spatial indexes, and functions for analysis and processing of GIS objects. This is the manual for version 2.0.6SVN This work is licensed under a Creative Commons Attribution-Share Alike 3.0 License.
Feel free to use this material any way you like, but we ask that you attribute credit to the PostGIS Project and wherever possible, a link back to. PostgreSQL Manual. Using oracle streams (10gR2) for simple replication. The Oracle (tm) Users' Co-Operative FAQ Setting up one-way replication at the schema level between two databases using Oracle Streams 10gR2 Back to index of questions Data to be replicated is not obtained by direct access to OLTP database. Data extraction process interferes with regular database operation. The source of the information is Oracle's archived log files. This is much less intrusive for online users. Streams uses Oracle’s Log Miner infrastructure to read redo logs. (For an introduction to Streams, basic concepts, list of reference documentation, and an example of a single table one-way replication procedure, please refer to Sanjay Mishra's article , “ Making Data Flow” at ) The single PL/SQL procedure - dbms_streams_adm.maintain_schemas completely sets up basic schema level replication. 1. 2. 3 . 4. 5. 6 . 8 . 9.
Steps in detail For steps 1 – 4, please refer to the Mishra's article mentioned above. 5. 6. 7 . Hibernate. Annotations. The Objective-Caml system.