TBD 3rd Informatics Summer Camp Trainer Sponsor Profelis
BD 3rd IT Summer Camp: Profelis, Instructor Sponsor At the 3rd IT Summer Camp organized by the Türkiye IT Association, Profelis served as the instructor sponsor. The camp attracted significant interest from students enrolled in Computer Engineering and Information Management programs at universities. On September 24–25, at our facility...
Profelis was at Istanbul KAK 2018.
Profelis was at Istanbul KAK 2018. At the Istanbul KAK 2018 event, held between October 2-4, 2018, Profelis Bilişim introduced its SambaBOX product to visitors. The conference, held for the first time in Istanbul under the leadership of TÜBİTAK ULAKBİM, was hosted by the Pendik Municipality. PostgreSQL and... by instructors from Profelis Bilişim.
PostgreSQL 10: Logical – Table-Based Replication
With PostgreSQL 10, along with the existing Streaming Replication (Physical Replication) feature, the Logical Replication feature was introduced. Thanks to this feature, we can now use some flexible replication capabilities that we could not do before. To define Logical Replication basically and first its differences from physical Streaming Replication...
IBM – EnterpriseDB Event
On December 14, 2017, at the 'EnterpriseDB / PostgreSQL on IBM Power Systems" event held in Istanbul in collaboration with IBM and Profelis, EnterpriseDB and IBM partnership was highlighted, covering EnterpriseDB Postgres Advanced Server and PostgreSQL database supports on Power systems.
Are you ready to migrate from Oracle to EDB Postgres Advanced Server?
Especially corporate companies are researching the process of migrating all or part of their existing Oracle databases to open-source PostgreSQL, along with the benefits it will bring, the risks, and the investment cost. Due to the size of the databases used in corporate structures, the complexity of business processes, and the project intensity, this subject...
Achieving PCI-DSS Compliance with PostgreSQL
PCI-DSS version 4 is about to be released. PCI-DSS is an international security regulation that determines security standards when shopping with credit cards and makes certificates mandatory according to merchants' levels. PCI-DSS standards (regulations), among its members, include major companies such as Mastercard, Visa, American Express, Discover Services, Veracode...
PostgreSQL 101: Indexes and Index Types
The index types supported by PostgreSQL are B-tree, hash, GiST, GIN, and BRIN. The PostgreSQL database supports single-column, multicolumn, partial index, unique index, expression index, implicit index, and concurrent indexes.
PostgreSQL 101: Index Maintenance
Markası ne olursa olsun, her veritabanında dizinler (indexes) yüksek yazma/silme işlemine maruz kalan sistemlerde problem oluşturma potansiyeline sahiptir. Tablolar şişebileceği gibi dizinler de şişebilir. Birincil anahtar olmayan dizinler normal insert işlemlerinde dahi şişebilmektedir. Buna karşın otomatik vakum (autovacuum) bu şişmiş...
PostgreSQL – JSON Data Type Operations
JSON veri tipi ve destekleyici işlevler PostgreSQL 9.2 sürümü ile desteklenmeye başladığında büyük olay olmuştu. Bugün ise PostgreSQL'in ardından diğer veritabanları da birer birer bu veri tipine destek vermeye başlarken, PostgreSQL'de oturmuş bir json desteği mevcut. JSON, web uygulamaları, JavaScript...
PostgreSQL Performance: max_connections
max_connections PostgreSQL performans ayarlarında önemli bir yere sahiptir. Her açılan bağlantının, kapatılıp yeniden açılması esnasında bir yoğunluk ve kaynak tüketimi oluşmaktadır. Dolayısı ile güçlü donanımlar üzerinde bu değer yüzlerce olarak ifade edilebilir ancak ihtiyacının daha fazlası ise, örneğin binlerce bağlantı ihtiyacınız...

