tablespace - datafile location

9.2 on Red Hat 6

Up to now I have been creating the sub-directories that (hold) the OS level files that are associated with individual tablespaces directly under the

..../psql/data directory i.e.

db=# create tablespace test owner test_admin location '/var/lib/pgsql/data/test';
Is this standard/best practise - I can see that the data directory could get 'cluttered' in a db that has many tablespaces.

Is there a standard/recommended alternative for tablespace location for db which have many tablespaces?

Thanks in advance as always

Austen

Austen Birchall  Senior Database Administrator
Met Office