This is a multi-part message in MIME format.
------_=_NextPart_001_01C8B043.D9E40174
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Hi Everyone,
=20
I've answered my own question: the Config parameter:
blob_etab_page_size.
=20
Marty
=20
From: Martin Bowes=20
Sent: 07 May 2008 14:00
To: 'Ingres and related product discussion forum'
Subject: page_size on iietabs
=20
Hi Everyone,
=20
I have a table with 4 long varchar columns. The table itself has only
793613 rows on 142675 pages, but one of its sup****ting iietabs has just
reached the magical 8.3million rows (1 row per page). And so now an
insert into the table fails as the blob table cannot be extended.
=20
If this were an ordinary table I would simply expand the page size from
2k to 8k and buy myself some more time. But I can't seem to do that with
the iietab. I was hoping the page size would be copied from the base
table when creating the blob table but this doesn't appear to be the
case and its stuck on 2k pages.
=20
Is there a configuration parameter, or modify option that allows me to
specify the page size on the iietabs?
=20
Would making the base table partitioned help the iietab?
=20
Ingres version is: II 9.0.4 (a64.lnx/105)NPTL + patch12707
=20
Martin Bowes
------_=_NextPart_001_01C8B043.D9E40174
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"
=
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@[EMAIL PROTECTED]
15 5 2 2 2 4 3 2 4;}
@[EMAIL PROTECTED]
11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
..MsoChpDefault
{mso-style-type:ex****t-only;
font-size:10.0pt;}
@[EMAIL PROTECTED]
Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-GB link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>Hi =
Everyone,<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>I've answered my own =
question: the
Config parameter: blob_etab_page_size.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>Marty<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0cm 0cm 0cm'>
<p class=3DMsoNormal><b><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=3DEN-US =
style=3D'font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> Martin Bowes <br>
<b>Sent:</b> 07 May 2008 14:00<br>
<b>To:</b> 'Ingres and related product discussion forum'<br>
<b>Subject:</b> page_size on iietabs<o:p></o:p></span></p>
</div>
</div>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Hi Everyone,<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>I have a table with 4 long varchar columns. The =
table itself
has only 793613 rows on 142675 pages, but one of its sup****ting =
iietabs
has just reached the magical 8.3million rows (1 row per page). And so =
now an
insert into the table fails as the blob table cannot be =
extended.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>If this were an ordinary table I would simply =
expand the
page size from 2k to 8k and buy myself some more time. But I can't seem =
to do that
with the iietab. I was hoping the page size would be copied from the =
base table
when creating the blob table but this doesn't appear to be the case and =
its
stuck on 2k pages.<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Is there a configuration parameter, or modify =
option that
allows me to specify the page size on the iietabs?<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Would making the base table partitioned help the =
iietab?<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal> Ingres version is: II 9.0.4 (a64.lnx/105)NPTL =
+
patch12707<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Martin Bowes<o:p></o:p></p>
</div>
</body>
</html>
------_=_NextPart_001_01C8B043.D9E40174--
|
