sql-info.de
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Index

Some interesting PostgreSQL-related links which have come my way this week:

Posted at 6:00 PM

The latest version of DBD::Pg, the PostgreSQL DBI driver, has been released and provides some useful new functionality, including support for server-side prepares, SQLSTATE code retrieval, and a last_insert_id() function. See below for a brief overview.

Posted at 9:41 AM

PostgreSQL's command line utility psql provides a settings toggle \timing which displays the time it takes to run a statement, right down to thousandths of a millisecond. This is very useful for debugging speed-critical statements, especially for web-based applications where a few milliseconds either way can make a noticeable cumulative difference.

Recently I was struggling with a particular statement which normally executed in less than 10ms, but with the addition of a single additional condition in the WHERE clause, execution time went up by a factor of five to around 50ms. (In human terms that might not sound a lot, "only" 1/20th of a second, but the app should be able to deliver the entire dynamic web page within 250ms - in that case 40ms is suddenly a very long time).

The usual suspects in this kind of situation - differing query plans, lack of recent VACUUM ANALYZE etc. - were evidently not guilty, and no amount of SQL voodoo would make any difference.

Posted at 7:14 AM

Due to a potential security hole recently identified with the LOAD command, security updates for currently supported PostgreSQL versions (7.2 to 8.0) have been released.

Posted at 8:58 AM

Privilege-checking weaknesses with the LOAD command may permit local privilege escalations in all current versions. Updates are expected on Friday.

Reference:

Posted at 11:02 PM

January 19, 2005

PostgreSQL 8.0 has been released and is available for download.

Posted at 1:28 PM

January 12, 2005

SUSE is now making RPMs available for current PostgreSQL versions (7.2, 7.3, 7.4 and 8.0rc builds):

Posted at 5:15 PM

Well, the previous prediction doesn't seem to have been quite accurate. A number of last-minute bug-fixes, including the solution for a hard-to-reproduce table definition problem (more info) have been added, bringing the Release Candidate total up to 5.

An initdb is not required.

Posted at 6:59 AM

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Index