Here's an interesting one.

Not being sure how Ingres handles LOBs, I started snooping around.
I noticed for long varchar, Ingres creates a catalog table to store
the actual data. Some cryptic table name i.e. iietab_77blabla.....

Now I'm worried because this table will become huge, I created it
with 32K pages to stay under the 8 million page limit.

BUT, the catalog table created to store the long varchars, is only
a plain jane uncompressed, 2K page table.
I'm afraid this catalog table with all the long varchar data will max
out the number of pages way before the actual user table.

Can/should I modify this system catalog table to 32K pages ?

Andre

Hello André,
Yes you can. Try this :
sysmod -page_size=32768
Jean-Pierre
2005/9/22, Laframboise André <andre.laframboise (AT) lac-bac (DOT) gc.ca>:

Will that convert all catalog tables to 32K ?



Do I want to do that ?



Andre

_____

From: Jean-Pierre Zuate [mailto:jpzuate (AT) gmail (DOT) com]
Sent: Thursday, September 22, 2005 1:26 PM
To: Laframboise André
Cc: info-ingres (AT) cariboulake (DOT) com
Subject: Re: [Info-ingres] Ingres and LOBs



Hello André,



Yes you can. Try this :

sysmod -page_size=32768


Jean-Pierre


2005/9/22, Laframboise André <andre.laframboise (AT) lac-bac (DOT) gc.ca
<mailto:andre.laframboise (AT) lac-bac (DOT) gc.ca> >:


Here's an interesting one.

Not being sure how Ingres handles LOBs, I started snooping around.
I noticed for long varchar, Ingres creates a catalog table to store
the actual data. Some cryptic table name i.e. iietab_77blabla.....

Now I'm worried because this table will become huge, I created it
with 32K pages to stay under the 8 million page limit.

BUT, the catalog table created to store the long varchars, is only
a plain jane uncompressed, 2K page table.
I'm afraid this catalog table with all the long varchar data will max
out the number of pages way before the actual user table.

Can/should I modify this system catalog table to 32K pages ?

Andre


_______________________________________________
Info-ingres mailing list
Info-ingres (AT) cariboulake (DOT) com <mailto:Info-ingres (AT) cariboulake (DOT) com>
http://mailman.cariboulake.com/mailm...py/info-ingres
<http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres>

At 1:12 PM -0400 9/22/2005, Laframboise André wrote:
Not to worry. If an etab fills up, Ingres just starts another one.
(At least, that's the theory. I've never attempted to actually fill up
an etab to watch it happen.)

Also, there is are configuration settings that control blob etab
storage structure and page size defaults. Look for blob_etab_structure
and blob_etab_page_size.

Karl

Thanks Karl,

That would make since, assuming and hoping it works.

Since a 2K page X 8 Million = about 16 GB.
That's only 8 rows if the LOB is 2GB.

Andre

-----Original Message-----
From: Karl & Betty Schendel [mailto:schendel (AT) kbcomputer (DOT) com]
Sent: Thursday, September 22, 2005 1:48 PM
To: Laframboise André; info-ingres (AT) cariboulake (DOT) com
Subject: Re: [Info-ingres] Ingres and LOBs

At 1:12 PM -0400 9/22/2005, Laframboise André wrote:
Not to worry. If an etab fills up, Ingres just starts another one.
(At least, that's the theory. I've never attempted to actually fill up
an etab to watch it happen.)

Also, there is are configuration settings that control blob etab
storage structure and page size defaults. Look for blob_etab_structure
and blob_etab_page_size.

Karl

Weird,

Now that I'm looking for it, blob etab settings are right there in CBF.
Funny I never noticed them before........

-----Original Message-----
From: Laframboise André
Sent: Thursday, September 22, 2005 1:53 PM
To: Karl & Betty Schendel; Laframboise André; info-ingres (AT) cariboulake (DOT) com
Subject: RE: [Info-ingres] Ingres and LOBs


Thanks Karl,

That would make since, assuming and hoping it works.

Since a 2K page X 8 Million = about 16 GB.
That's only 8 rows if the LOB is 2GB.

Andre

-----Original Message-----
From: Karl & Betty Schendel [mailto:schendel (AT) kbcomputer (DOT) com]
Sent: Thursday, September 22, 2005 1:48 PM
To: Laframboise André; info-ingres (AT) cariboulake (DOT) com
Subject: Re: [Info-ingres] Ingres and LOBs

At 1:12 PM -0400 9/22/2005, Laframboise André wrote:
Not to worry. If an etab fills up, Ingres just starts another one.
(At least, that's the theory. I've never attempted to actually fill up
an etab to watch it happen.)

Also, there is are configuration settings that control blob etab
storage structure and page size defaults. Look for blob_etab_structure
and blob_etab_page_size.

Karl