Ah. Good point. I think the indexes are not exported by pg_dump in my
config. This will definitely help.
Btw. here is the EXPLAIN ANALYZE output
SELECT
TLC.CAPTION AS FIELDNAME,
REGEXP_REPLACE(RCF.CODE, '^([rR][^aA]+)[aA]?$', '\1') AS CODE,
RCF.NAME AS NAME,
RCF.TASK_TYPE AS ACTION,
SRL.DESCRIPTION AS DESCRIPTION,
VISIBLE AS ISDISPLAY,
FALSE AS ISKEY,
TLC.COLUMN_FORMAT AS FORMAT,
CASE RCF.STATUS WHEN '5. Geaccepteerd' THEN 'ACCEPTED' WHEN '4. Nieuwe
controle' THEN 'NEW' ELSE 'TEST' END AS RULE_STATUS,
CAST(((CHT.DOMAIN_TYPE = 'java.lang.Double')
AND ((RCF.ENTITY_NAME = 'tsk_normenkader')
AND (LOWER(CHT.COLUMN_NAME) LIKE 'actie_impact%'))) AS BOOLEAN) AS
ISCURRENCY
FROM PUBLIC.VCP_TASKLIST_COLUMN TLC
/* PUBLIC.VCP_TASKLIST_COLUMN.tableScan */
/* WHERE UPPER(TLC.CAPTION) <> 'OPLOSSER'
*/
/* scanCount: 51410 */
LEFT OUTER JOIN PUBLIC.VCP_TASKLIST TLT
/* PUBLIC.VCP_TASKLIST.tableScan */
ON TLC.TLT_ID = TLT.ID
/* scanCount: 26754736 */
LEFT OUTER JOIN PUBLIC.VCP_RULE_CONFIG RCF
/* PUBLIC.VCP_RULE_CONFIG.tableScan */
ON RCF.TASKLIST = TLT.CODE
/* scanCount: 18682624 */
LEFT OUTER JOIN PUBLIC.VCP_SITE_RULE SRL
/* PUBLIC.VCP_SITE_RULE.tableScan */
ON RCF.CODE = SRL.CODE
/* scanCount: 162867228 */
LEFT OUTER JOIN PUBLIC.VCP_CHARACTERISTIC_SET CHS
/* PUBLIC.VCP_CHARACTERISTIC_SET.tableScan */
ON TLC.CHS_ID = CHS.ID
/* scanCount: 1753309766 */
LEFT OUTER JOIN PUBLIC.VCP_CHARACTERISTIC_TYPE CHT
/* PUBLIC.VCP_CHARACTERISTIC_TYPE.tableScan */
ON CHS.CHT_ID = CHT.ID
/* scanCount: 365811732 */
WHERE (RCF.CODE = 'R06408')
AND (UPPER(TLC.CAPTION) <> 'OPLOSSER')
ORDER BY =COLUMN_INDEX
On Monday, March 30, 2015 at 11:59:40 AM UTC+2, Noel Grandin wrote:
>
> Ah, I missed that part of your original post where you said you killed it
> after 30 mins.
>
> Hmmm, that may not be practical in that case.
>
> Are you sure you created indexes when you did this?
> It seems to be doing tablescans exclusively, which does not make a lot of
> sense.
> Possibly pg_dump is not writing them out, or they did not get imported to
> H2 correctly?
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
