Archiwizowane October, 2008

Let's imagine following situation: create table test (id int4 primary key, priority int4); insert into test (id) select distinct (random() * 100000000)::int4 from generate_series(1,1000); Table test will now contain some (up to 1000) records, with random ids. Now, we want to ...

Like practically any application, applications that I deal with evolve. They change their requirements when it comes to database storage - new tables, new columns, modified columns. Or perhaps - new base data - like new values in virtually static ...

SoftNum asked on irc: < SoftNum> does postgresql have a config option to automatically trim (both ' ' from blah) on string compares? So, can you? Of course there is no such option, but maybe there is a way to tell PostgreSQL to ...

Let's assume you have very simple table with users: # \d users Table "public.users" ...

On 4th of September Tom Lane committed another great patch. This one is very large, and even after applying - it's has some rough edges. There will be need for additional patches to make the functionality fully robust, but the ...

You might be familiar with hstore datatype in PostgreSQL - if you're not - check it out, as it is really cool. Basically it's hash in database, which you can search in.

On 30th of September, Heikki Linnakangas committed his patch that changes FSM: Rewrite the FSM. Instead of relying on a fixed-size shared memory segment, the free space information is stored in a dedicated FSM relation fork, with each relation (except for hash indexes; ...