In EG 2.6 with Pg 9.2 Marc Expert searches always return no entries found. Looking into the database I found very long running queries associated with the searches. Example from pg_stats_statements data:
SELECT query, calls, total_time, rows, 100.0 * shared_blks_hit /
nullif(shared_blks_hit + shared_blks_read, 0) AS hit_percent
FROM pg_stat_statements ORDER BY total_time DESC limit 3;
-[ RECORD 1 ]---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
query | SELECT f.record, sum(f.sum), count(DISTINCT cp.id), sum(f.sum)
| FROM (SELECT x.record, sum(x.sum) FROM ((SELECT record, AVG(ts_rank(index_vector, to_tsquery(?,?))) as sum FROM metabib.full_rec WHERE ( tag = ? AND subfield LIKE ? AND index_vector @@ to_tsquery(?,?) ) GROUP BY record)) x GROUP BY 1 HAVING COUNT(x.record) = ? ORDER BY 2 DESC ) f,
| asset.call_number cn,
| asset.copy cp,
| config.copy_status cs,
| asset.copy_location cl,
| biblio.record_entry br,
| metabib.rec_descriptor rd,
| actor.org_unit_descendants(?) d
| WHERE br.id = f.record
| AND cn.record = f.record
| AND rd.record = f.record
| AND cp.status = cs.id
| AND cp.location = cl.id
| AND br.deleted IS FALSE
| AND cn.deleted IS FALSE
| AND cp.deleted IS FALSE
| AND cn.owning_lib = d.id
| AND cp.call_number = cn.id
| AND d.opac_visible IS TRUE AND cp.opac_visible IS TRUE AND cs.opac_visible IS TRUE AND cl.opac_visible IS TRUE
|
|
|
|
|
| GROUP BY f.record HAVING count(DISTINCT cp.id) > ?
| ORDER BY 4 DESC,3 DESC
| ;
calls | 1
total_time | 527175.736
rows | 38
hit_percent | 100.0000000000000000
This is very likely caused by the (useless) inclusion of metabib.
http://