diff options
| author | randomdan <randomdan@localhost> | 2010-08-16 19:15:19 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-08-16 19:15:19 +0000 |
| commit | 688262d611bae71262304d59252123e73c10f341 (patch) | |
| tree | 3f9f140917dce2673367c8c64ea1368bf403d534 | |
| parent | Add missing filetypeid filter (diff) | |
| download | gentoobrowse-688262d611bae71262304d59252123e73c10f341.tar.bz2 gentoobrowse-688262d611bae71262304d59252123e73c10f341.tar.xz gentoobrowse-688262d611bae71262304d59252123e73c10f341.zip | |
Add option to use a temporary view instead of a table to reduce WAL churn during SqlMerge
| -rw-r--r-- | gentoobrowse/console/bugassociate.xml | 2 | ||||
| -rw-r--r-- | gentoobrowse/console/packageimport.xml | 14 |
2 files changed, 8 insertions, 8 deletions
diff --git a/gentoobrowse/console/bugassociate.xml b/gentoobrowse/console/bugassociate.xml index b026205..626638e 100644 --- a/gentoobrowse/console/bugassociate.xml +++ b/gentoobrowse/console/bugassociate.xml @@ -2,7 +2,7 @@ <bugassoc name="bugassociate" xmlns:xi="http://www.w3.org/2001/XInclude" xmlns:project2="http://project2.randomdan.homeip.net"> <xi:include href="../datasources/postgres.xml" /> - <project2:sqlmerge name="bugbind" datasource="postgres" targettable="package_bugs"> + <project2:sqlmerge name="bugbind" datasource="postgres" targettable="package_bugs" useview="yes"> <sql> SELECT b.bugid, p.packageid FROM bugs b, packages p, categories c diff --git a/gentoobrowse/console/packageimport.xml b/gentoobrowse/console/packageimport.xml index 84872ed..12bca02 100644 --- a/gentoobrowse/console/packageimport.xml +++ b/gentoobrowse/console/packageimport.xml @@ -3,14 +3,14 @@ xmlns:project2="http://project2.randomdan.homeip.net"> <xi:include href="../datasources/postgres.xml" /> - <project2:sqlmerge name="categories" datasource="postgres" targettable="categories"> + <project2:sqlmerge name="categories" datasource="postgres" targettable="categories" useview="yes"> <sql>SELECT DISTINCT (REGEXP_MATCHES(filename, '^[^/]+'))[1] AS name FROM files WHERE filetypeid = 1</sql> <columns> <column key="true">name</column> </columns> </project2:sqlmerge> - <project2:sqlmerge name="packages" datasource="postgres" targettable="packages"> + <project2:sqlmerge name="packages" datasource="postgres" targettable="packages" useview="yes"> <sql> SELECT c.categoryid, f.name, fc.content AS description FROM ( SELECT MAX(fileid) AS fileid, @@ -30,7 +30,7 @@ </columns> </project2:sqlmerge> - <project2:sqlmerge name="ebuilds" datasource="postgres" targettable="ebuilds"> + <project2:sqlmerge name="ebuilds" datasource="postgres" targettable="ebuilds" useview="yes"> <sql> SELECT packageid, version, fileid AS ebuildid, ebuildversion_constructor(version) AS versioninst FROM ( SELECT f.fileid, @@ -51,7 +51,7 @@ </columns> </project2:sqlmerge> - <project2:sqlmerge name="archs" datasource="postgres" targettable="ebuild_archs"> + <project2:sqlmerge name="archs" datasource="postgres" targettable="ebuild_archs" useview="yes"> <sql> SELECT DISTINCT f.fileid AS ebuildid, REGEXP_SPLIT_TO_TABLE(fc.content, ' ') AS arch FROM filecache fc, files f @@ -65,7 +65,7 @@ </columns> </project2:sqlmerge> - <project2:sqlmerge name="uses" datasource="postgres" targettable="ebuild_uses"> + <project2:sqlmerge name="uses" datasource="postgres" targettable="ebuild_uses" useview="yes"> <sql> SELECT DISTINCT fc.fileid AS ebuildid, REGEXP_SPLIT_TO_TABLE(fc.content, ' ') AS use FROM filecache fc, files f @@ -79,7 +79,7 @@ </columns> </project2:sqlmerge> - <project2:sqlmerge name="urls" datasource="postgres" targettable="package_urls"> + <project2:sqlmerge name="urls" datasource="postgres" targettable="package_urls" useview="yes"> <sql> SELECT DISTINCT e.packageid, REGEXP_SPLIT_TO_TABLE(fc.content, ' ') AS url FROM filecache fc, ebuilds e, files f @@ -94,7 +94,7 @@ </columns> </project2:sqlmerge> - <project2:sqlmerge name="deps" datasource="postgres" targettable="ebuild_deps"> + <project2:sqlmerge name="deps" datasource="postgres" targettable="ebuild_deps" useview="yes"> <sql> SELECT fileid AS ebuildid, packageid, COALESCE(slot, '') AS slot, COALESCE(op, '') AS op, COALESCE(versionspec, '') AS versionspec, COALESCE(flags, '') AS flags |