summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorAndreas Baumann <abaumann@yahoo.com>2013-04-17 12:26:58 +0200
committerAndreas Baumann <abaumann@yahoo.com>2013-04-17 12:26:58 +0200
commitc54ea201b80a28fb5285d9c72f012bfda0a3741a (patch)
treee4a18a4b95c014cd79bf4ff7bd4d6b3eed8c4275 /schema.sql
parent0ca43761e7ed260055c692d7f2cf804bcaa647b3 (diff)
downloadpgfuse-c54ea201b80a28fb5285d9c72f012bfda0a3741a.tar.gz
pgfuse-c54ea201b80a28fb5285d9c72f012bfda0a3741a.tar.bz2
some first results in statfs, but some sizes are weird, also PGDATA handling is missing
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/schema.sql b/schema.sql
index 2f5c202..555fb25 100644
--- a/schema.sql
+++ b/schema.sql
@@ -24,12 +24,12 @@ CREATE TABLE data (
);
-- create indexes for fast data access
-CREATE INDEX data_dir_id_idx ON data( dir_id );
-CREATE INDEX data_block_no_idx ON data( block_no );
+CREATE INDEX data_dir_id_idx ON data( dir_id ) tablespace test2;
+CREATE INDEX data_block_no_idx ON data( block_no ) tablespace test2;
-- create an index on the parent_id for
-- directory listings
-CREATE INDEX dir_parent_id_idx ON dir( parent_id );
+CREATE INDEX dir_parent_id_idx ON dir( parent_id ) tablespace test2;
-- 16384 == S_IFDIR (S_IFDIR)
-- TODO: should be created by the program after checking the OS