Text search with a commonly-known book

2013-08-06 08:54:43 +0000

Just yesterday on hackers, a post by Kevin Grittner mentionned using pg_trgm to find similar sentences in a text. His example involved using “War and Peace” (which is under the public domain). When trying to tune queries, you might want to use always the same set of examples to actually analyze easily if there is a potential gain for your query. Just by thinking about that, using classic books available directly is a great way for people to evaluate the performance of a text search algorithm or a given application implementation. This could be even useful to compare the performance of several database systems regarding index scans because the data is the same, only counts the search speed, assuming that all the systems have been tuned to scan data the same way (for example all data on memory).

Postgres 9.4 feature highlight - session_preload_libraries for library loading

2013-08-05 06:24:32 +0000

PostgreSQL already offers a couple of ways to load custom library into a server instance:

Modifications of APIs for bgworkers in Postgres 9.3

2013-07-29 01:47:51 +0000

Just to make a short recall, Background worker is a new plug-in facility similar to hook, extension or FDW, but this time allowing to run customized code in a daemon process managed by the postmaster. This allows, without modifying the core code of the Postgres server, to run automatic maintenance tasks, to collect statistics or to do more fancy stuff like running for example a licence checker for a Postgres server running in a cloud (do what you want with this idea…). However, all the people that have begun development of a background worker module based on PostgreSQL 9.3 beta1 or beta2 need to be aware that there have been modifications in the APIs used by this facility. Those modifications have been made for a couple of reasons.

Postgres 9.4 feature highlight - REFRESH CONCURRENTLY a materialized view

2013-07-22 00:51:54 +0000

Postgres 9.3 has introduced the first features related to materialized views. The upcoming version of Postgres is adding many basic things like the possibility to create, manage and refresh a materialized views. However, materialized views in Postgres 9.3 have a severe limitation consisting in using an exclusive lock when refreshing it. This basically blocks any attempts to read a materialized view while it is being refreshed with new data from its parent relations, which is particularly a handicap for large materialized views on production servers.

Postgres module highlight - pg_rewind, to quickly recycle a Postgres master into a slave

2013-07-16 07:33:42 +0000

Managing wisely server resources has always been a critical matter for all kinds of systems. A lack of resource would mean a loss of performance and scalability for applications running on those infrastructures, blocking the potential growth of a service, while using too much resource could create a cost that the application provider might not be able to afford, resulting indirectly on a loss of income in long-term.

« Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Next »

Michael Paquier - PostgreSQL committer

Text search with a commonly-known book

Postgres 9.4 feature highlight - session_preload_libraries for library loading

Modifications of APIs for bgworkers in Postgres 9.3

Postgres 9.4 feature highlight - REFRESH CONCURRENTLY a materialized view

Postgres module highlight - pg_rewind, to quickly recycle a Postgres master into a slave

Search

Social

RSS Feeds

Sponsor