Fraud Blocker

THE ART OF COPYING WITHOUT COPYING: FORKING DATABASES

A query about how to fork PostgreSQL databases like you can on Heroku was sent to me. Since I could not find any good examples of how to do this, I ma…

Continue Reading

Introduction to Connection Pooling: PGBouNCER and PGPOOL-II

During recent PostgreSQL consulting, the subject of connection pools came up. Specifically, what strategies and products are widely used and work well…

Continue Reading

POSTGRESSQL JOINS PGSTROM ON A GPU 

I decided to try joins after reading the information on the pgstrom wiki page to see how much speed we could gain by offloading some of the work that …

Continue Reading

Time Series Pattern Search: A Poor Man’s Method

A lot has been written about timeseries analysis and how to deal with temporal data in general. There have been countless papers submitted and publish…

Continue Reading

MERGING DATA FROM DIFFERENT POSTGRESS DATABASES 

It is sometimes necessary to join or search data from various absolutely regular and independent PostgreSQL databases (i.e., no built-in clustering ex…

Continue Reading

Thank you, the form has been submitted.