Citus: Gerçek Zamanlı, Yatay Büyüyebilen PostgreSQL Veri Hattı
Yatayda PostgreSQL veritabanlarını birden fazla sistem üzerine sharding ve replikasyon kullanarak "yayan", özel sorgu motoru sayesinde kendisine gelen sorguları paralel süreçler halinde bu sistemler üzerinde çalıştırıp büyük veri setleri üzerinden gerçek zamanlı (1 saniyeden az) cevaplar alınmasını sağlayan bir yapı.
Shell Control Box, Uzak Oturum İzleme ve Yönetim uygulamasının LTS sürümü için güncelleme 3 Kasım 2016’da duyuruldu.
Shell Control Box, Uzak Oturum İzleme ve Yönetim uygulamasının LTS sürümü için güncelleme 3 Kasım 2016’da duyuruldu. Shell Control Box, Uzak Oturum İzleme ve Yönetim uygulamasının LTS sürümü için güncelleme 3 Kasım 2016’da duyuruldu. Güncelleme ile aşağıdaki hatalar giderildi. Hata...
TSE Emphasizes the Importance of PostgreSQL
Eda BİTLİSLİ and Cem ERDİVAN from the TSE Cyber Security Certification Directorate attended the program on Tuesday, November 10, of the Public Open Source Conference, organized by ULAKBİM and the Open Source Advisory Committee at TOBB ETU between November 9-13, 2015.
4. We were at the Turkiye PostgreSQL Conference!
We Attended the 4th Turkiye PostgreSQL Conference! The PostgreSQL Users and Developers Association organized the 4th Turkiye 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.
PostgreSQL 101: Activity Monitoring
When track_activities is set to on, PostgreSQL starts collecting data for all executed queries. Users with appropriate privileges can monitor user activity through this feature using the system view pg_stat_activities.
PostgreSQL 101: Connected Users
One of the PostgreSQL system views, pg_stat_activity, keeps a list of all currently running PostgreSQL background processes. This information includes which queries are running, connected users and when they connected, and the start time of running transactions and queries.
We were at PostgreSQL Day
We attended the 3rd PostgreSQL Conference held in Ankara on December 6, 2015. Profelis sponsored the event as an EnterpriseDB (EDB) Strategic Partner.