Tags » PostgreSQL

How to check and terminate PostgreSql DB connections

If you want to manage your postgresql db connections, you can get the connection client_address, username, how much time this connection is active and which query is run by this connection. 51 more words

Software

Telemetry metrics roll-ups

Our Telemetry aggregation system has been serving us well for quite some time. As Telemetry evolved though, maintaining the codebase and adding new features such as keyed histograms has proven to be challenging. 1,011 more words

Blog

PostgreSQL: How to remove a column from a table ?

Use this sintaxe:

ALTER TABLE {TABLE_NAME} DROP COLUMN {COLUMN_NAME};

Example:

ALTER TABLE material DROP COLUMN classificacao;
PostgreSQL

Java Developer - London, UK

Position: Java Developer Location: London, UK Duration: 3 – 6 Months Contract

Job Description:

  • Financial Tech project: ground up build of a trade compression engine in the OTC Swap area…
  • 90 more words
Java

Introducing HypoPG, hypothetical indexes for PostgreSQL

“DALIBO is proud to present the first release of HypoPG, an extension that adds hypothetical indexes in PostgreSQL.

An hypothetical index is an index which doesn’t exists on disk. 71 more words

Programming

Installing SonarQube on Ubuntu

credits go to Anna Bansaghi for the how-to found here:
http://mamikon.net/blog/installing-sonarqube-ubuntu/

Prerequisites

– Java JRE
– DBMS (MySQL for example)

Create SonarQube database and user… 381 more words

Code Analysis