SEO

I once though a sysmod might include iietabs, but it doesn't.

I considered a modify to the new page size on an iietab table once, but eventually opted out.
Not being familiar with the 'behind the scenes' iietab management, I went for the safe, much longer way.

________________________________

From: Martin Bowes [mailto:martin.bowes@ctsu.ox.ac.uk]
Sent: May 7, 2008 9:51 AM
To: Ingres and related product discussion forum
Cc: Laframboise André
Subject: RE: [Info-Ingres] page_size on iietabs



Hi Andre,



Dropping the original and recreating would take at least two hours.



I'm lucky enough to have an agreement with the owner to take the database offline at the moment and connect with +U and modify the catalog directly. I'm not sure how long that will take, but it should be less.



BTW. Expanding to 8k will probably buy me another year before I'm in this problem again ... on this column. Can I make the etab a partitioned table?



Marty



From: info-ingres-bounces@kettleriverconsulting.com [mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of Laframboise André
Sent: 07 May 2008 14:25
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] page_size on iietabs



There's a page size and structure parameter for iietabs in CBF.



We have ours at 64K pages.



blob_etab_page_size
blob_etab_structure



Once you set this, copy your existing table to a temp table, drop the original and re-create/copy.



Andre

________________________________

From: info-ingres-bounces@kettleriverconsulting.com [mailto:info-ingres-bounces@kettleriverconsulting.com] 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,



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.



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.



Is there a configuration parameter, or modify option that allows me to specify the page size on the iietabs?



Would making the base table partitioned help the iietab?



Ingres version is: II 9.0.4 (a64.lnx/105)NPTL + patch12707



Martin Bowes