Project

General

Profile

Saurabh Garg's activity

From 07/05/2005 to 08/03/2005

07/25/2005

12:59 PM Metacat Bug #2060: Documents not indexed because of error generated during indexing of documents

Changin severity of teh bug to Critical because with the new changes if the
indexing thread fails, the paths will n... Saurabh Garg

07/20/2005

01:07 PM Metacat Bug #2153: Metacat Performace: Add/drop indices on key columns

Indexes can also be added to docid and nodetype in xml_nodes..... Saurabh Garg
10:28 AM Metacat 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... Saurabh Garg

07/19/2005

12:42 PM Metacat 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... Saurabh Garg

07/18/2005

02:37 PM Morpho Bug #2162: eml versions and dateTimeDomain requirements

this is a morpho bug... moving it under Morpho Saurabh Garg

07/13/2005

06:37 PM Metacat 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... Saurabh Garg
06:16 PM Metacat 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... Saurabh Garg
06:35 PM Metacat 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... Saurabh Garg
06:11 PM Metacat 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... Saurabh Garg
06:34 PM Metacat 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,... Saurabh Garg
06:27 PM Metacat 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... Saurabh Garg
06:24 PM Metacat 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... Saurabh Garg
06:20 PM Metacat 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 ... Saurabh Garg
06:17 PM Metacat 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... Saurabh Garg
06:14 PM Metacat 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... Saurabh Garg
 

Also available in: Atom