[jira] [Closed] (JENA-28) Drop Temporary Tables in Postgres (PATCH)

["Andy Seaborne (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/JENA-28?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andy Seaborne closed JENA-28.
-----------------------------

> Drop Temporary Tables in Postgres (PATCH)
> -----------------------------------------
>
>                 Key: JENA-28
>                 URL: https://issues.apache.org/jira/browse/JENA-28
>             Project: Apache Jena
>          Issue Type: Improvement
>          Components: SDB
>         Environment: Effects SDB PostgreSQL
>            Reporter: Gavin Carothers
>            Assignee: Damian Steer
>            Priority: Minor
>
> Current behaviour to truncate the temporary tables leaves the table objects, and thanks to MVCC in Postgres the data in those tables around for far longer then expected. This causes HUGE write loads on the database when loading a large number of quads or triples transactionally.
> Fix is VERY simple:
> Index: src/com/hp/hpl/jena/sdb/layout2/hash/TupleLoaderHashPGSQL.java
> ===================================================================
> --- src/com/hp/hpl/jena/sdb/layout2/hash/TupleLoaderHashPGSQL.java      (revision 8420)
> +++ src/com/hp/hpl/jena/sdb/layout2/hash/TupleLoaderHashPGSQL.java      (working copy)
> @@ -26,7 +26,7 @@
>         }
>  
>         public String[] getCreateTempTable() {
> -               return new String[] { "CREATE TEMPORARY TABLE" , "ON COMMIT DELETE ROWS" };
> +               return new String[] { "CREATE TEMPORARY TABLE" , "ON COMMIT DROP" };
>         }



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)