Parallelism is now a reality in PostgreSQL. With 9.6, I hope we will see many different forms of queries that can use parallelism to execute. For now, I will limit...
Open source software has been saving organizations money for years in operating systems with Linux, in the middleware layer with tools like JBoss, and virtualization with Xen and other options...
It doesn’t take a specialized solution to create an unstructured database to support workloads for emerging mobile, social and machine data. Certainly, NoSQL-only solutions have a place in the data...
A very popular standalone NoSQL database solution came under criticism about their security posture this week. It’s not the kind of publicity a database company – or any company for...
When a well-prepared DBA begins to consider their Postgres rollout, they should think about their database strategy sooner rather than later. Thinking about key database variables and questions in advance...
The idea of ‘horizontal scalability’ was discussed in great detail at PGCon 2014 in Ottawa this year. It is great to see the community discussing ideas on how PostgreSQL can...
That famous journey began simply—just follow the yellow brick road. But as we all learned, that pretty little lane entered some pretty challenging territory pretty quickly.
Postgres' parameters have an associated context, which determines when that parameter can be changed. You can see the context of every parameter using the following query. A sample output is...
