postgresql

Welcome to the 'postgresql' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'postgresql'.

Are you an expert about 'postgresql'? Do you want to be the Technorati authority on 'postgresql'? You can write a description that will appear right here: Join Blogcritics!

Latest blogosphere posts tagged “postgresql”

 

• Explaining the unexplainable – part 3

  
  — Authority:
  In previous post in the series I wrote about how to interpret single line in explain analyze output, its structure, and later on described all basic data-getting operations (nodes in explain tree). Today, well move towards more complicated operations. Function Scan Example: $ EXPLAIN analyze SELECT * FROM ...
  2 weeks ago

• Discourse org On Appfog

  
  — Authority:
  I would like an instance of the Discourse org forum software to be configured in an free AppFog account A custom domain will be provided as the entry point for the forum A document with instructions screenshots of how the AppFog account was configured needs to be created… Required Skills: Linux, PostgreSQL, Ruby, ...
  2 weeks ago

• How to install PostgreSQL 9.2 on Ubuntu 13.04

  
  — Authority:
  How to install PostgreSQL 9.2 on Ubuntu 13.04 How to install PostgreSQL 9.2 on Ubuntu 13.04 was first posted on May 6, 2013 at 7:58 am. " Leave No Bit Unturned " The material presented in this feed is Copyright © Mikko Kortelainen, unless otherwise indicated. All material is licensed under a Creative Commons ...
  2 weeks ago

• Moving to C++

  
  — Authority:
  GCC 4.8 was recently released. This isthe first GCC release that is written in C++ instead of C. Which gotme thinking ... Would this make sense for PostgreSQL? I think its worth a closer look. Much of GCCs job isnt actually that much different from PostgreSQL.It parses language input, optimizes it, and produces ...
  3 weeks ago

• Which PostGIS should you use with PostgreSQL 9.3

  
  — Authority:
  PostgreSQL 9.3 will be coming out in beta soon and with that, some who want to experiment with both PostGIS and PostgreSQL 9.3 have asked if they can use PostGIS 2.0. The answer is NO . A lot of major changes happened in PostgreSQL 9.3 that required us to patch up upcoming PostGIS 2.1. These changes were not ...
  3 weeks ago

• Set Default search_path for a User in PostgreSQL

  
  — Authority:
  Here’s how to do it: ALTER ROLE myuser IN DATABASE mydb SET search_path = myschema; The same syntax works for any configuration parameter, such as localization parameters. Set Default search_path for a User in PostgreSQL was first posted on April 29, 2013 at 2:03 pm. " Leave No Bit Unturned " The material ...
  3 weeks ago

• Explaining the unexplainable – part 2

  
  — Authority:
  Last time I wrote about what explain output shows. Now Id like to talk more about various types of “nodes" / operations that you might see in explain plans. The most basic one is Seq Scan. It looks like this: EXPLAIN analyze SELECT * FROM pg_class; QUERY PLAN ...
  3 weeks ago

• Win a book contest – PostgreSQL Backup and Restore How-to

  
  — Authority:
  Around the time that Xzilla wrote about the book, Packt contacted me and asked for a review. Since I generally dont really read technical books, I declined the offer, but Sandy from Packt was very persistent, and asked if I could inform about book giveaway contest. The book is definitely PostgreSQL related, and Xzilla ...
  4 weeks ago

• 在 PostgreSQL 上用 GPU 加速計算…

  
  — Authority:
  看到 PGStorm 這個 PostgreSQL 上的惡搞套件，可以把本來 CPU 要做的事情丟到 GPU 上加速… 不過例子很怪啊，不是用 R-tree index 解決的事情嗎？PostgreSQL 明明就有支援 R-tree index 啊？為什麼會要這樣設計，然後用 table scan？我再回去想想好了… ...
  4 weeks ago

Comments about postgresql