Stack Overflow
Stack Overflow

Questions tagged [postgresql-9.6]

for PostgreSQL questions specific to version 9.6

On 29 September 2016, PostgreSQL 9.6.0 was released. Major enhancements in PostgreSQL 9.6 include:

  • Parallel sequential scans, joins and aggregates

  • Elimination of repetitive scanning of old data by autovacuum

  • Synchronous replication now allows multiple standby servers for increased reliability

  • Full-text search for phrases

  • Support for remote joins, sorts, and updates in postgres_fdw

  • Substantial performance improvements, especially in the area of improving scalability on many-CPU servers.

Use this tag for questions specific to any of the above new features.

The official documentation for this version is available at: http://www.postgresql.org/docs/9.6/static/index.html

767 questions
-1
votes
1 answer

POSTGRES 9.6: How do I make a disaggregation in percentages of each column of a table on a single query?

I have a table that store information on user clicks, like "so","browser","timezone". I need to make a dissaggregation of each column to build a pie chart of each one. I would need a json result like: {"results": { …
Juan
  • 1,451
  • 2
  • 21
  • 37
-2
votes
1 answer

How to create a named profile on EDB Postgresql?

Could someone guide how to create following profile define rules in EDB Postgresql: count failed login attempts lock an account due to excessive failed login attempts define rules for password complexity define rules that limit password re-use
Dheeraj Nambiar
  • 21
  • 1
1 2 3
…
51
52