sql-info.de

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Index

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 2005-02-28 08:14:00

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 2005-02-01 09:58:00

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

Reference:

Posted at 2005-01-26 00:02:00

2005-01-19 14:28:00

PostgreSQL | PostgreSQL 8.0 released

PostgreSQL 8.0 has been released and is available for download.

Posted at 2005-01-19 14:28:00

2005-01-12 18:15:00

PostgreSQL | Official SUSE RPMs

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

Posted at 2005-01-12 18:15:00

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Index