I had to deal with this question, or some version of it, quite a few times. So, decided to write a summary on what one could (or should) do, after data is in database, and application is running. Namely - ...

On 18th of January, Stephen Frost committed patch: Add ALTER TABLESPACE ... MOVE command This adds a 'MOVE' sub-command to ALTER TABLESPACE which allows moving sets of objects from one tablespace to another. This can be extremely handy and avoids a lot of ...

Gregory Stark wrote, and Bruce Momjian committed (on 14th of July) patch which shows storage type in psql.

i recently got new toy for tests - brand new dell powervault md1000. what's this, you ask? basically - a rather nice das (direct attached storage) from dell. the box i got had 15 sas discs, each disc being 72gb, 15krpm. since this ...