From planetsysadmin.com
()
Last time I wrote code with psycopg2 was around 2006, but I was reacquainted with it over the past couple of weeks, and I wanted to make some notes on a couple of features that are not well documented, imho. Portions of this post have been snipped from mailing list threads I was involved in.
Calling PostgreSQL Functions with psycopg2
So you need to call a function. Me too. I had to call a function called ‘myapp.new_user’. It expects a bunch of...
- Dave's PostgreSQL Blog: JPUG Anniversary conference pics (blogsearch.google.com)
- Bruce Momjian: Elephant Roads: PostgreSQL Patches and Variants (planet.postgresql.org)
LYONS, N.Y., Dec. 1 /PRNewswire/ -- Many MySQL(R) and PostgreSQL DBAs are frustrated by their inability to account for high server usage. The engineers at Software Workshop had similar feelings when trying to find 'usage hogs' among web hosting clients.
From rss.prnewswire.com
()
- Leo Hsu and Regina Obe: An almost idiot's guide to Install and Upgrade to... (planet.postgresql.org)
- David Fetter: PostgreSQL Conference Japan...and onward (planet.postgresql.org)
- US PostgreSQL Association: PgUS Community Member Update 11/09: (planet.postgresql.org)
LinuxSecurity.com: Database security is the single biggest concern with today's Web-based applications. Without control, you risk exposing sensitive information about your company or, worse yet, your valuable customers. In this article, learn about security measures you can take to protect your PostgreSQL database.
More perspectives...
From linuxsecurity.com
()
The Linux OOM Killer heuristic can be summed up as:
Run out of memory.
Kill PostgreSQL.
Look for processes that might be using too much memory, and kill them, hopefully freeing memory.
Notice that step #2 is independent of factors like:
Is PostgreSQL consuming a significant share of the memory resources?
Will killing PostgreSQL alleviate any memory pressure at all?
The reason for this is because linux, when under memory pressure, invokes...
More perspectives...
From planet.postgresql.org
()
Searching and calculating Median in databases was terrible. Still median isn't ANSI SQL aggregate function. There are two commons method how to calculate median of some column. First - very old, and very slow based on self join alchemy, second - new - based on analytic function. Now, I will be test some newer methods on one million rows large table:postgres=# create table milrows(a real);CREATE TABLETime: 7,975 mspostgres=# insert into milrows...
From planet.postgresql.org
()
- Pavel Golub: PostgreSQL client libraries update (planet.postgresql.org)
DeZign for Databases supports Oracle, MySQL, MS SQL Server, MS Access, DB2, InterBase, PostgreSQL, Firebird, Sybase, DBISAM, Paradox, FoxPro, dBase, Clipper, Pervasive SQL, Informix. Pricing and Availability ------------------------ ...
From blogsearch.google.com
()
- PostgreSQL 8.5alpha2 Now Available (postgresql.org)
- Download Jet Profiler for MySQL , Jet Profiler for MySQL 1.0.7 ... (blogsearch.google.com)
- RazorSQL 5 SQL Editor and Database Query Tool Released (postgresql.org)
Updated Postgres Plus includes enterprise featuresEnterpriseDB is touting enterprise level capabilities of its Postgres Plus Standard Server 8.4 open source database, which was released this week. The company says the database, which is based on PostgreSQL database technology, offers enterprises cost benefits of open source, performance benefits of a community developed product, and the reassurance of vendor support.
From techworld.com
()
- EnterpriseDB cites enterprise capabilities in open source database... (rss.news.yahoo.com)
- EnterpriseDB Unveils PostgreSQL 8.4 (tmcnet.com)
