The JDBC Howto on the official site explains how to setup the database. However it does not describe, how to tune it.

At least, you should create indices on some SQL tables. For Postgres these SQL statements can be used:

CREATE INDEX children_uri ON children(uri);
CREATE INDEX latestrevisions_uri ON latestrevisions(uri);
CREATE INDEX links_to ON links(linkto);
CREATE INDEX links_from ON links(link); 
CREATE INDEX permissions_object ON permissions(object);
CREATE INDEX revision_uri ON revision(uri);
CREATE INDEX property_revision ON property(uri,xnumber);

JdbcStoreSetup (last edited 2009-09-20 22:02:35 by localhost)