Upgrading PostgreSQL 8.1 databases to 8.2
Here’s a great tip from Dick Visser for upgrading the database cluster from PostgreSQL 8.1 to postgreSQL 8.2. It’s amazingly simple and it just works.
Enjoyed this post?, why not subscribe to the RSS feed!
Archive for the ‘Databases’
Full-Text Search Engines
It is obvious that the matter of a full-text search engine implementation is becoming more and more important (at least as far as my work is concerned) .
A while ago I implemented the TSearch2 full-text search engine with one of our PostgreSQL databases1. Let me say that it wasn’t easy (mostly because I wanted to make it support the Romanian language), although I did get it working properly with quite impressive effects2. (more…)
- I have yet to use my TSearch2 implementation in a heavy traffic environment. ⇑
- From what I could gather from my experience until now and by reading other reviews, tests and opinions, I know that TSearch2 updates it’s indexes in real-time while searching and indexing becomes increasingly slower with large-sized indexes. ⇑
Enjoyed this post?, why not subscribe to the RSS feed!