Opened 12 years ago

Closed 9 years ago

#106 closed enhancement (wontfix)

use tablespaces

Reported by: Peter Baumann Owned by: Dimitar Misev
Priority: major Milestone: 10.0
Component: reladminif Version: 8.0
Keywords: tablespace, tables, PostgreSQL Cc:
Complexity: Very Hard

Description

now that PG meantime supports tablespaces as well, these should be used (again) by rasdaman to allow tuning according to the individual table characteristics.
This will require adding TABLESPACE declarations in the table creation module, reladminif.

Change History (6)

comment:1 by Dimitar Misev, 12 years ago

Often I use tablespaces like this:

CREATE TABLESPACE rasdaman LOCATION '/home/rasdaman/db';
createdb RASBASE -D rasdaman

then all tables go to /home/rasdaman/db

comment:2 by Peter Baumann, 11 years ago

Milestone: → 9.0
Version: → 8.0

comment:3 by Peter Baumann, 11 years ago

Owner: changed from Peter Baumann to abeccati
Status: new → assigned

comment:4 by Dimitar Misev, 11 years ago

The LOCATION could be a parameter to the configure script, e.g.

./configure --db-location=/home/rasdaman/db

comment:5 by Dimitar Misev, 9 years ago

Complexity: → Very Hard
Milestone: 9.0.x → 10.0
Owner: changed from abeccati to Dimitar Misev

This is perhaps not so relevant anymore if we plan to switch to sqlite/filesystem by default in v10?

comment:6 by Peter Baumann, 9 years ago

Resolution: → wontfix
Status: assigned → closed

indeed, agree on this, closing therefore.

Note: See TracTickets for help on using tickets.