We were at the 2015 Public Open Source Conference
Organized for the first time by ULAKBİM and the Open Source Advisory Committee, the Public Open Source Conference (KAK'15) was held at TOBB ETÜ between November 9 and 13.
We held meetings with TETSOFT in the USA.
Türkiye's leading 18 internet technology and software development companies launched an initiative in the US. A delegation from many companies, including Profelis, met with American firms first in Boston and then in Washington, DC. Operating under the umbrella of IMMIB and supported by the Ministry of Economy, the Electrical and Electronics...
4. We were at the Türkiye PostgreSQL Conference!
We Attended the 4th Türkiye PostgreSQL Conference! The PostgreSQL Users and Developers Association organized the 4th Türkiye PostgreSQL Conference on May 9, 2015. PGDay is the collective name for one-day PostgreSQL-related events held around the world. More than 300 participants attended PGDay 2015, which was organized this year with the support of Boğaziçi University and sponsored by Profelis....
PostgreSQL 101: Why Are My Queries Slow?
We are not talking about slow queries; let's talk about queries that we noticed have slowed down suddenly, out of nowhere, while they were working normally until yesterday. These are queries that used to take milliseconds but now take seconds, or used to take a few seconds and now take minutes.
PostgreSQL 101: Pending Queries
The pg_stat_activity view has a boolean field called the waiting column. When selected for the values of this column, it runs as queries waiting for a system lock to be released. To explain it another way; if we filter the pg_stat_activity view as waiting = TRUE, then the first query above...
PostgreSQL 101: Who is Using This Table?
It is a popular and dangerous motto, especially in the IT sector: If it works, leave it alone! However, as a responsible database administrator or application developer, let's take the initiative and see who is using these tables, and which tables are no longer used at all.