diff options
author | Andreas Baumann <abaumann@yahoo.com> | 2013-04-17 12:26:58 +0200 |
---|---|---|
committer | Andreas Baumann <abaumann@yahoo.com> | 2013-04-17 12:26:58 +0200 |
commit | c54ea201b80a28fb5285d9c72f012bfda0a3741a (patch) | |
tree | e4a18a4b95c014cd79bf4ff7bd4d6b3eed8c4275 /schema.sql | |
parent | 0ca43761e7ed260055c692d7f2cf804bcaa647b3 (diff) | |
download | pgfuse-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.sql | 6 |
1 files changed, 3 insertions, 3 deletions
@@ -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 |