Activity
From 06/25/2005 to 07/24/2005
07/21/2005
- 04:59 PM Revision 2518 (metacat): Added target for upgrading DB to version 1.6
- 04:54 PM Revision 2517 (metacat): Changed the name of the function
- 04:52 PM Revision 2516 (metacat): Modified xmltables script so that:
- 1. Foreign key for rootnodeid in xml_revision points to xml_node_revision table instead of xml_nodes
2. Added a new... - 04:46 PM Revision 2515 (metacat): Fixed bug in previous commit
- 04:31 PM Revision 2514 (metacat): Modified postgres script so that:
- 1. Foreign key for rootnodeid in xml_revision points to xml_node_revision table instead of xml_nodes
2. Added a new t... - 04:18 PM Revision 2513 (metacat): Added a new property 'indexed_paths'. All the paths mentioned under this property will be configured in xml_path_index table.
- See bug 2154
- 04:08 PM Revision 2512 (metacat): Added a new function which can used to control the carriage return at the end of the debug message and 'Metacat' in front of the message...
07/20/2005
- 01:07 PM Bug #2153: Metacat Performace: Add/drop indices on key columns
Indexes can also be added to docid and nodetype in xml_nodes.....- 10:28 AM Bug #2152: Metacat Performace: Reduce size of xml_nodes table
From Postgres documentation, the limits on the sequence...
"Sequences are based on bigint arithmetic, so the range c...
07/19/2005
- 12:42 PM Bug #2154: Metacat Performace: Configurable path condition indices
It will also speed up queries like the following which are used while creating
the doclist...
select xml_nodes.d...
07/13/2005
- 06:37 PM Bug #2154: Metacat Performace: Configurable path condition indices
From my email:
Metacat can have a new index table for admin specified fields. This will be
helpful as both xml_nod...- 06:16 PM Bug #2154 (Resolved): Metacat Performace: Configurable path condition indices
- From Matt's email...
Configurable path condition indices -- this would allow admins to
configure specific XML pat... - 06:35 PM Bug #2152: Metacat Performace: Reduce size of xml_nodes table
While implementing this, have to check whats the limit on the sequence numbers
that are being assigned to xml_nodes...- 06:11 PM Bug #2152 (Resolved): Metacat Performace: Reduce size of xml_nodes table
- xml_nodes is huge (6.8x106 records), and grows with every insert and
update by many thousands of records. By design... - 06:34 PM Bug #2159 (New): Metacat Performance: Divide xml_nodes based on the doctype
- Matt suggested that xml_nodes table can probably be divided into multiple
tables based on the doctype. For example,... - 06:27 PM Bug #2158 (Resolved): Metacat Performance on KNB: Bring the logging level down on ecoinfo.
- Dont know how much this effects the performance but we might be logging more
than required on the production server... - 06:24 PM Bug #2157 (Resolved): Metacat Performance: Optimize Postgres and Tomcat...
- There might be some options in Tomcat to speed things up a little bit. e.g.
Chris suggested about turning off autol... - 06:20 PM Bug #2156 (Resolved): Metacat Performance: Send result back to web client in blocks
- Comparing Metacat with other search engines, there is a major
difference in the metacat web interface when compared ... - 06:17 PM Bug #2155 (In Progress): Metacat Performace: Rewrite the xml_nodes queries
- From Matt's email...
Rewrite the xml_nodes queries. In general we use the IN clause a lot
which is less than eff... - 06:14 PM Bug #2153 (Resolved): Metacat Performace: Add/drop indices on key columns
- From Matt's email...
DB indices aren't created on some key columns such as
xml_nodes.nodedata (originally because... - 02:39 PM Revision 2511 (metacat): Add servlet mapping for replication.
07/12/2005
- 03:24 PM Bug #2136: Replicate deleted documents in Replication
- Here is the new approach:
When metacat A send a command "update" to metacat B, B will send two doclist to A.
The fir...
07/07/2005
07/05/2005
- 11:54 AM Bug #2136 (Resolved): Replicate deleted documents in Replication
- Currently in Delta-timed replication, metacat only replicated the documents in
xml_documents table. So even after th...
Also available in: Atom