Archiwizowane November, 2007

November 22nd, 2007 by depesz | Tags: | 1 comment »

in previous post i described how to find overlapping ranges in a way that will work with indexes. now, i'd like to discuss something else. how to check how many ranges are in given moment?

November 21st, 2007 by depesz | Tags: | 11 comments »

hannesd on irc had a problem with finding overlapping date/time ranges. basically - in postgresql there is "overlaps" operator, but unfortunately it doesn't use indexes:

November 14th, 2007 by depesz | Tags: | 1 comment »

another patch from Aleksander 'A.L.E.C' Machniak. Changes: make it possible to sort by avg query runtime round() summary values SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk

November 14th, 2007 by depesz | Tags: | 1 comment »

patch from Aleksander 'A.L.E.C' Machniak. Changes: It's now possible to return analysis as html table (set $HTML_OUTPUT to 1) It's now easier to change sorting of generated analysis (set $SORT_ORDER) In html output, all numbers are formatted to %.2f. Some edits by me, mostly indentation. SVN ...

November 13th, 2007 by depesz | Tags: | 12 comments »

i'm recently under impression that pg developers are overprotective. who do they protect? us, users. i mean - don't get me wrong - i live with, and (to some extent) thanks to the piece of marvelous technology which is postgresql ordbms. i use ...

November 6th, 2007 by depesz | Tags: | No comments »

Changes: skip non-query lines SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk

November 5th, 2007 by depesz | Tags: | 37 comments »

in most applications you have some variant of this table: CREATE TABLE users ( id serial PRIMARY KEY, username TEXT NOT NULL, passwd TEXT ); and, usually, the passwd stores user password in clear ...

November 2nd, 2007 by depesz | Tags: , | 5 comments »

in postgresql 8.2, in contrib, is great new datatype called hstore. if you're not familiar with it - check the docs. in short - this is indexable associative-array (hash) in one field. i was given a task to convert some text field to ...