This is a multi-part message in MIME format.
------_=_NextPart_001_01C8B045.CC3E2844
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
There's a page size and structure parameter for iietabs in CBF.
=20
We have ours at 64K pages.
=20
blob_etab_page_size =20
blob_etab_structure
=20
Once you set this, copy your existing table to a temp table, drop the =
original and re-create/copy.
=20
Andre =20
________________________________
From: info-ingres-bounces@[EMAIL PROTECTED]
=
[mailto:info-ingres-bounces@[EMAIL PROTECTED]
On Behalf Of =
Martin Bowes
Sent: May 7, 2008 9:00 AM
To: Ingres and related product discussion forum
Subject: [Info-Ingres] page_size on iietabs
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 supporting 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_01C8B045.CC3E2844
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40"
xmlns:v =3D=20
"urn:schemas-microsoft-com:vml" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word" xmlns:m =3D=20
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.3243" name=3DGENERATOR>
<STYLE>@[EMAIL PROTECTED]
{
font-family: Calibri;
}
@[EMAIL PROTECTED]
Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 72.0pt 72.0pt =
72.0pt; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: =
"Calibri","sans-serif"
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: =
"Calibri","sans-serif"
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: =
"Calibri","sans-serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: =
personal-compose
}
..MsoChpDefault {
mso-style-type: export-only
}
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 vLink=3Dpurple link=3Dblue>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D390442213-07052008><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>There's a page size and structure parameter for =
iietabs in=20
CBF.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D390442213-07052008><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D390442213-07052008><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>We have ours at 64K pages.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D390442213-07052008><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff=20
size=3D2>blob_etab_page_size &nb=
sp; &nbs=
p; <BR>blob_etab_structure</FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial><FONT color=3D#0000ff><FONT size=3D2><SPAN=20
class=3D390442213-07052008>Once you set this, copy your existing table =
to a temp=20
table, drop the original and =
re-create/copy.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=3DArial><FONT color=3D#0000ff><FONT size=3D2><SPAN=20
class=3D390442213-07052008></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT><FONT><SPAN class=3D390442213-07052008></SPAN><FONT =
face=3DArial><FONT=20
color=3D#0000ff><FONT size=3D2><SPAN =
class=3D390442213-07052008>Andre</SPAN> =20
</FONT></FONT></FONT></FONT></FONT><BR></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B>=20
info-ingres-bounces@[EMAIL PROTECTED]
<B>On Behalf Of=20
</B>Martin Bowes<BR><B>Sent:</B> May 7, 2008 9:00 AM<BR><B>To:</B> =
Ingres and=20
related product discussion forum<BR><B>Subject:</B> [Info-Ingres] =
page_size on=20
iietabs<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=3DSection1>
<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=20
has only 793613 rows on 142675 pages, but one of its supporting =
iietabs=20
has just reached the magical 8.3million rows (1 row per page). And so =
now an=20
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=20
size from 2k to 8k and buy myself some more time. But I can't seem to do =
that=20
with the iietab. I was hoping the page size would be copied from the =
base table=20
when creating the blob table but this doesn't appear to be the case and =
its=20
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=20
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=20
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 =
+=20
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_01C8B045.CC3E2844--
|
