Hi.
Right direction is to use btree index.
Hash indexes are sensitive to power failures.
2011/10/5, Justin Naifeh :
> In Postgres 8.4, I have a table called java_types with two columns,
> package_name and class_name. There is another table called java_objects
> that defines a column called type
In Postgres 8.4, I have a table called java_types with two columns,
package_name and class_name. There is another table called java_objects
that defines a column called type whose value matches the concatenation
of package_name and class_name. A typical join and result looks like this:
SELECT
