Forum: >>> Magnum BBS <<<

[Info-ingres] index problem on a partitioned table

From Martin Bowes@21:1/5 to All on Fri Oct 8 07:28:09 2021

Hi All,

II 11.1.0 (a64.lnx/100) +p15599

I have a partitioned table (pidapp) with an index (pidapp_pid). The table is fine, but the index is now bumping into max pages.

BBA_CTSU_OX_AC_UK ::[42297 , 11346 , 0000000000000000:00007faf22db5ac0, dm1p.c:4471 ]: Thu Oct 7 18:39:18 2021 E_DM92BF_DM1P_TABLE_TOO_BIG Error extending table past maximum table size of 8388608, Database ace_trexy_live,
Table ace.pidapp_pid, Current size 8388596 pages, Extend size 16 pages

The index looks like this:
ame: pidapp_pid
Owner: ace
Created: 20/02/2020 13:41:32
Location: ii_database
Type: secondary index on pidapp
Version: II10.0
Page size: 8192
Cache priority: 0
Alter table version: 0
Alter table totwidth: 12
Row width: 12
Number of rows: 1124378214
Storage structure: btree
Compression: none
Duplicate Rows: allowed
Number of pages: 7272402
Overflow data pages: 0
Journaling: enabled if journaling on the base table is enabled
Base table for view: no
Permissions: none
Integrities: none
Optimizer statistics: will use any existing statistics on the base table

Index Column Information:
Key
Column Name Type Length Nulls Defaults Seq
pid integer 4 no no 1
tidp integer 8 no no 2

I'm not sure if we can partition an index. I'm not sure if bumping the index to a higher page size will help either as the data is so small we can easily fit the max number of tids per page into 8k as it is.

Ideas?

Martin Bowes

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style>
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
Hi All,<o:p></o:p>
<o:p> </o:p>
II 11.1.0 (a64.lnx/100) +p15599<o:p></o:p>
<o:p> </o:p>
I have a partitioned table (pidapp) with an index (pidapp_pid). The table is fine, but the index is now bumping into max pages.<o:p></o:p>
<o:p> </o:p>
BBA_CTSU_OX_AC_UK ::[42297             , 11346     ,&
nbsp; 0000000000000000:00007faf22db5ac0, dm1p.c:4471           ]: Thu
Oct  7 18:39:18 2021 E_DM92BF_DM1P_TABLE_TOO_BIG  Error extending table past maximum table size of 8388608, Database ace_trexy_live,  Table ace.pidapp_pid, Current size
8388596 pages, Extend
size 16 pages<o:p></o:p>
<o:p> </o:p>
The index looks like this:<o:p></o:p>
ame:                 pidapp_pid<o:p></o:p>
Owner:                ace<o:p></o:p>
Created:              20/02/2020 13:41:32<o:p></o:p>
Location:             ii_database<o:p></o:p>
Type:                 secondary index on pidapp<o:p></o:



Version:              II10.0<o:p></o:p>
Page size:            8192<o:p></o:p>
Cache priority:       0<o:p></o:p>
Alter table version:  0<o:p></o:p>
Alter table totwidth: 12<o:p></o:p>
Row width:            12<o:p></o:p>
Number of rows:       1124378214<o:p></o:p>
Storage structure:    btree<o:p></o:p>
Compression:          none<o:p></o:p>
Duplicate Rows:       allowed<o:p></o:p>
Number of pages:      7272402<o:p></o:p>
Overflow data pages:  0<o:p></o:p>
Journaling:           enabled if journaling on the base table is enabled<o:p></o:p>
Base table for view:  no<o:p></o:p>
Permissions:          none<o:p></o:p>
Integrities:          none<o:p></o:p>
Optimizer statistics: will use any existing statistics on the base table<o:p></o:p>
<o:p> </o:p>
Index Column Information:<o:p></o:p>
                       &
nbsp;                                         &
nbsp;Key<o:p></o:p>
Column Name              Type       
        Length Nulls Defaults Seq<o:p></o:p>
pid                     
integer                 4   no      no     1<o:p></o:p>
tidp                     integer&
nbsp;                8   no      no     2<o:p></o:p>
<o:p> </o:p>
I’m not sure if we can partition an index. I’m not sure if bumping the index to a higher page size will help either as the data is so small we can easily fit the max number of tids per page into 8k as it is.<o:p></o:p>
<o:p> </o:p>
Ideas?<o:p></o:p>
<o:p> </o:p>
Martin Bowes<o:p></o:p>
</div>
</body>
</html>

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

From Karl Schendel@21:1/5 to All on Fri Oct 8 09:24:31 2021

You can't partition an index. That was a feature in the original partitioned tables spec,
but never got implemented. Part of the reason is that a partitioned index would
require three identifiying numbers: base table, index, partition, and we only have two.
Adding a number, or somehow rejiggering the numbering scheme, would be a massive
change throughout DMF and other places. The can has been kicked down the road ever since.

I'm not sure what exactly to suggest in this case. You might have to split up the base
table, or do a manual pseudo-index that's explicitly referenced in queries.

Karl

On Oct 8, 2021, at 3:28 AM, Martin Bowes <martin.bowes@ndph.ox.ac.uk> wrote:

Hi All,

II 11.1.0 (a64.lnx/100) +p15599

I have a partitioned table (pidapp) with an index (pidapp_pid). The table is fine, but the index is now bumping into max pages.

BBA_CTSU_OX_AC_UK ::[42297 , 11346 , 0000000000000000:00007faf22db5ac0, dm1p.c:4471 ]: Thu Oct 7 18:39:18 2021 E_DM92BF_DM1P_TABLE_TOO_BIG Error extending table past maximum table size of 8388608, Database ace_trexy_live,

Table ace.pidapp_pid, Current size 8388596 pages, Extend size 16 pages

The index looks like this:
ame: pidapp_pid
Owner: ace
Created: 20/02/2020 13:41:32
Location: ii_database
Type: secondary index on pidapp
Version: II10.0
Page size: 8192
Cache priority: 0
Alter table version: 0
Alter table totwidth: 12
Row width: 12
Number of rows: 1124378214
Storage structure: btree
Compression: none
Duplicate Rows: allowed
Number of pages: 7272402
Overflow data pages: 0
Journaling: enabled if journaling on the base table is enabled
Base table for view: no
Permissions: none
Integrities: none
Optimizer statistics: will use any existing statistics on the base table

Index Column Information:
Key
Column Name Type Length Nulls Defaults Seq
pid integer 4 no no 1
tidp integer 8 no no 2

I’m not sure if we can partition an index. I’m not sure if bumping the index to a higher page size will help either as the data is so small we can easily fit the max number of tids per page into 8k as it is.

Ideas?

Martin Bowes
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

From Paul White@21:1/5 to Karl Schendel on Sat Oct 9 00:39:01 2021

Hi there Karl,

I suggested to Marty earlier he may like to try to create the index with multiple locations.

I created two locations pointing to the same path. It seems to work:

create index p1_idx on p1 (v)
with structure=btree,
page_size = 8192,
location=(ii_database, ii_database2, ii_database3)

ls -l /data4/ingresII/ingres/data/default/pw
total 0
-rw-------. 1 ingres ingres 0 Oct 8 19:24 aaaaanfo.t01
-rw-------. 1 ingres ingres 0 Oct 8 19:24 aaaaanfo.t02

Paul

On 8/10/2021 11:24 pm, Karl Schendel wrote:

You can't partition an index. That was a feature in the original partitioned tables spec,
but never got implemented. Part of the reason is that a partitioned index would
require three identifiying numbers: base table, index, partition, and we only have two.
Adding a number, or somehow rejiggering the numbering scheme, would be a massive
change throughout DMF and other places. The can has been kicked down the road
ever since.

I'm not sure what exactly to suggest in this case. You might have to split up the base
table, or do a manual pseudo-index that's explicitly referenced in queries.

Karl

On Oct 8, 2021, at 3:28 AM, Martin Bowes <martin.bowes@ndph.ox.ac.uk> wrote: >>
Hi All,

II 11.1.0 (a64.lnx/100) +p15599

I have a partitioned table (pidapp) with an index (pidapp_pid). The table is fine, but the index is now bumping into max pages.

BBA_CTSU_OX_AC_UK ::[42297 , 11346 , 0000000000000000:00007faf22db5ac0, dm1p.c:4471 ]: Thu Oct 7 18:39:18 2021 E_DM92BF_DM1P_TABLE_TOO_BIG Error extending table past maximum table size of 8388608, Database ace_trexy_live,

Table ace.pidapp_pid, Current size 8388596 pages, Extend size 16 pages

The index looks like this:
ame: pidapp_pid
Owner: ace
Created: 20/02/2020 13:41:32
Location: ii_database
Type: secondary index on pidapp
Version: II10.0
Page size: 8192
Cache priority: 0
Alter table version: 0
Alter table totwidth: 12
Row width: 12
Number of rows: 1124378214
Storage structure: btree
Compression: none
Duplicate Rows: allowed
Number of pages: 7272402
Overflow data pages: 0
Journaling: enabled if journaling on the base table is enabled
Base table for view: no
Permissions: none
Integrities: none
Optimizer statistics: will use any existing statistics on the base table

Index Column Information:
Key
Column Name Type Length Nulls Defaults Seq
pid integer 4 no no 1
tidp integer 8 no no 2

I’m not sure if we can partition an index. I’m not sure if bumping the index to a higher page size will help either as the data is so small we can easily fit the max number of tids per page into 8k as it is.

Ideas?

Martin Bowes
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres

_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

--
Paul White 
Shift Seven Solutions 
m: 0414681799 
p: 0754482137 
e: paul.white@shift7solutions.com.au 
w: https://www.shift7solutions.com.au 
International: +61414681799 

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

From Martin Bowes@21:1/5 to All on Fri Oct 8 14:43:40 2021

To: info-ingres@lists.planetingres.org (info-ingres@lists.planetingres.org)

TXVsdGlwbGUgbG9jYXRpb25zIHdvdWxkbid0IGhhdmUgYWx0ZXJlZCB0aGUgbnVtYmVyIG9mIHBh Z2VzIGF2YWlsYWJsZS4gLi4uIEkgdGhpbmsuDQoNCkkgbWFuYWdlZCB0byBhZGp1c3QgdGhlIHBh Z2Vfc2l6ZSBvZiB0aGUgaW5kZXggdG8gMTZLIGFuZCB0aGF0IGhhcyBnaXZlbiBtZSBiYWNrIGEg ZmV3IG1pbGxpb24gcGFnZXMgd2hpY2ggaXMgZW5vdWdoIHRvIGNvbnRpbnVlIGZvciBhIHdoaWxl Lg0KDQpJIHN1c3BlY3QgbXkgYmVzdCBhbnN3ZXIgaXMgdG8gY29udmVydCB0aGlzIHRhYmxlIHRv IGFuIHgxMDAgdGFibGUuIEFuZCBhbHRlciBhIGZldyBwcm9ncmFtcyB0byBtb2RpZnkgdG8gY29t YmluZS4gU2FkbHkgaXQgYWxzbyBtZWFucyBJIGhhdmUgdG8gdW5sb2FkLCByZWNyZWF0ZSB3aXRo IHgxMDAgYW5kIHJlbG9hZCB0aGlzIG9sZCBkYXRhYmFzZS4NCg0KU29tZXRoaW5nIHRvIGxvb2sg Zm9yd2FyZCB0b28uDQoNCk1hcnR5IA0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJv bTogUGF1bCBXaGl0ZSA8c2hpZnQ3c29sdXRpb25zQGdtYWlsLmNvbT4gDQpTZW50OiAwOCBPY3Rv YmVyIDIwMjEgMTU6MzkNClRvOiBpbmZvLWluZ3Jlc0BsaXN0cy5wbGFuZXRpbmdyZXMub3JnDQpT dWJqZWN0OiBSZTogW0luZm8taW5ncmVzXSBpbmRleCBwcm9ibGVtIG9uIGEgcGFydGl0aW9uZWQg dGFibGUNCg0KSGkgdGhlcmUgS2FybCwNCg0KSSBzdWdnZXN0ZWQgdG8gTWFydHkgZWFybGllciBo ZSBtYXkgbGlrZSB0byB0cnkgdG8gY3JlYXRlIHRoZSBpbmRleCB3aXRoIG11bHRpcGxlIGxvY2F0 aW9ucy4NCg0KSSBjcmVhdGVkIHR3byBsb2NhdGlvbnMgcG9pbnRpbmcgdG8gdGhlIHNhbWUgcGF0 aC4gSXQgc2VlbXMgdG8gd29yazoNCg0KDQpjcmVhdGUgaW5kZXggcDFfaWR4IG9uIHAxICh2KQ0K d2l0aCBzdHJ1Y3R1cmU9YnRyZWUsDQpwYWdlX3NpemUgPSA4MTkyLA0KbG9jYXRpb249KGlpX2Rh dGFiYXNlLCBpaV9kYXRhYmFzZTIsIGlpX2RhdGFiYXNlMykNCg0KDQpscyAtbCAvZGF0YTQvaW5n cmVzSUkvaW5ncmVzL2RhdGEvZGVmYXVsdC9wdw0KdG90YWwgMA0KLXJ3LS0tLS0tLS4gMSBpbmdy ZXMgaW5ncmVzIDAgT2N0wqAgOCAxOToyNCBhYWFhYW5mby50MDEgLXJ3LS0tLS0tLS4gMSBpbmdy ZXMgaW5ncmVzIDAgT2N0wqAgOCAxOToyNCBhYWFhYW5mby50MDINCg0KDQpQYXVsDQoNCg0KDQpP biA4LzEwLzIwMjEgMTE6MjQgcG0sIEthcmwgU2NoZW5kZWwgd3JvdGU6DQo+IFlvdSBjYW4ndCBw YXJ0aXRpb24gYW4gaW5kZXguICBUaGF0IHdhcyBhIGZlYXR1cmUgaW4gdGhlIG9yaWdpbmFsIA0K PiBwYXJ0aXRpb25lZCB0YWJsZXMgc3BlYywgYnV0IG5ldmVyIGdvdCBpbXBsZW1lbnRlZC4gIFBh cnQgb2YgdGhlIA0KPiByZWFzb24gaXMgdGhhdCBhIHBhcnRpdGlvbmVkIGluZGV4IHdvdWxkIHJl cXVpcmUgdGhyZWUgaWRlbnRpZml5aW5nIG51bWJlcnM6IGJhc2UgdGFibGUsIGluZGV4LCBwYXJ0 aXRpb24sIGFuZCB3ZSBvbmx5IGhhdmUgdHdvLg0KPiBBZGRpbmcgYSBudW1iZXIsIG9yIHNvbWVo b3cgcmVqaWdnZXJpbmcgdGhlIG51bWJlcmluZyBzY2hlbWUsIHdvdWxkIGJlIA0KPiBhIG1hc3Np dmUgY2hhbmdlIHRocm91Z2hvdXQgRE1GIGFuZCBvdGhlciBwbGFjZXMuICBUaGUgY2FuIGhhcyBi ZWVuIA0KPiBraWNrZWQgZG93biB0aGUgcm9hZCBldmVyIHNpbmNlLg0KPg0KPiBJJ20gbm90IHN1 cmUgd2hhdCBleGFjdGx5IHRvIHN1Z2dlc3QgaW4gdGhpcyBjYXNlLiAgWW91IG1pZ2h0IGhhdmUg dG8gDQo+IHNwbGl0IHVwIHRoZSBiYXNlIHRhYmxlLCBvciBkbyBhIG1hbnVhbCBwc2V1ZG8taW5k ZXggdGhhdCdzIGV4cGxpY2l0bHkgcmVmZXJlbmNlZCBpbiBxdWVyaWVzLg0KPg0KPiBLYXJsDQo+ DQo+DQo+PiBPbiBPY3QgOCwgMjAyMSwgYXQgMzoyOCBBTSwgTWFydGluIEJvd2VzIDxtYXJ0aW4u Ym93ZXNAbmRwaC5veC5hYy51az4gd3JvdGU6DQo+Pg0KPj4gSGkgQWxsLA0KPj4gICANCj4+IElJ IDExLjEuMCAoYTY0LmxueC8xMDApICtwMTU1OTkNCj4+ICAgDQo+PiBJIGhhdmUgYSBwYXJ0aXRp b25lZCB0YWJsZSAocGlkYXBwKSB3aXRoIGFuIGluZGV4IChwaWRhcHBfcGlkKS4gVGhlIHRhYmxl IGlzIGZpbmUsIGJ1dCB0aGUgaW5kZXggaXMgbm93IGJ1bXBpbmcgaW50byBtYXggcGFnZXMuDQo+ PiAgIA0KPj4gQkJBX0NUU1VfT1hfQUNfVUsgOjpbNDIyOTcgICAgICAgICAgICAgLCAxMTM0NiAg ICAgLCAgMDAwMDAwMDAwMDAwMDAwMDowMDAwN2ZhZjIyZGI1YWMwLCBkbTFwLmM6NDQ3MSAgICAg ICAgICAgXTogVGh1IE9jdCAgNyAxODozOToxOCAyMDIxIEVfRE05MkJGX0RNMVBfVEFCTEVfVE9P X0JJRyAgRXJyb3IgZXh0ZW5kaW5nIHRhYmxlIHBhc3QgbWF4aW11bSB0YWJsZSBzaXplIG9mIDgz ODg2MDgsIERhdGFiYXNlIGFjZV90cmV4eV9saXZlLCAgVGFibGUgYWNlLnBpZGFwcF9waWQsIEN1 cnJlbnQgc2l6ZSA4Mzg4NTk2IHBhZ2VzLCBFeHRlbmQgc2l6ZSAxNiBwYWdlcw0KPj4gICANCj4+ IFRoZSBpbmRleCBsb29rcyBsaWtlIHRoaXM6DQo+PiBhbWU6ICAgICAgICAgICAgICAgICBwaWRh cHBfcGlkDQo+PiBPd25lcjogICAgICAgICAgICAgICAgYWNlDQo+PiBDcmVhdGVkOiAgICAgICAg ICAgICAgMjAvMDIvMjAyMCAxMzo0MTozMg0KPj4gTG9jYXRpb246ICAgICAgICAgICAgIGlpX2Rh dGFiYXNlDQo+PiBUeXBlOiAgICAgICAgICAgICAgICAgc2Vjb25kYXJ5IGluZGV4IG9uIHBpZGFw cA0KPj4gVmVyc2lvbjogICAgICAgICAgICAgIElJMTAuMA0KPj4gUGFnZSBzaXplOiAgICAgICAg ICAgIDgxOTINCj4+IENhY2hlIHByaW9yaXR5OiAgICAgICAwDQo+PiBBbHRlciB0YWJsZSB2ZXJz aW9uOiAgMA0KPj4gQWx0ZXIgdGFibGUgdG90d2lkdGg6IDEyDQo+PiBSb3cgd2lkdGg6ICAgICAg ICAgICAgMTINCj4+IE51bWJlciBvZiByb3dzOiAgICAgICAxMTI0Mzc4MjE0DQo+PiBTdG9yYWdl IHN0cnVjdHVyZTogICAgYnRyZWUNCj4+IENvbXByZXNzaW9uOiAgICAgICAgICBub25lDQo+PiBE dXBsaWNhdGUgUm93czogICAgICAgYWxsb3dlZA0KPj4gTnVtYmVyIG9mIHBhZ2VzOiAgICAgIDcy NzI0MDINCj4+IE92ZXJmbG93IGRhdGEgcGFnZXM6ICAwDQo+PiBKb3VybmFsaW5nOiAgICAgICAg ICAgZW5hYmxlZCBpZiBqb3VybmFsaW5nIG9uIHRoZSBiYXNlIHRhYmxlIGlzIGVuYWJsZWQNCj4+ IEJhc2UgdGFibGUgZm9yIHZpZXc6ICBubw0KPj4gUGVybWlzc2lvbnM6ICAgICAgICAgIG5vbmUN Cj4+IEludGVncml0aWVzOiAgICAgICAgICBub25lDQo+PiBPcHRpbWl6ZXIgc3RhdGlzdGljczog d2lsbCB1c2UgYW55IGV4aXN0aW5nIHN0YXRpc3RpY3Mgb24gdGhlIGJhc2UgDQo+PiB0YWJsZQ0K Pj4gICANCj4+IEluZGV4IENvbHVtbiBJbmZvcm1hdGlvbjoNCj4+ICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBLZXkNCj4+ IENvbHVtbiBOYW1lICAgICAgICAgICAgICBUeXBlICAgICAgICAgICAgICAgTGVuZ3RoIE51bGxz IERlZmF1bHRzIFNlcQ0KPj4gcGlkICAgICAgICAgICAgICAgICAgICAgIGludGVnZXIgICAgICAg ICAgICAgICAgIDQgICBubyAgICAgIG5vICAgICAxDQo+PiB0aWRwICAgICAgICAgICAgICAgICAg ICAgaW50ZWdlciAgICAgICAgICAgICAgICAgOCAgIG5vICAgICAgbm8gICAgIDINCj4+ICAgDQo+ PiBJ4oCZbSBub3Qgc3VyZSBpZiB3ZSBjYW4gcGFydGl0aW9uIGFuIGluZGV4LiBJ4oCZbSBub3Qg c3VyZSBpZiBidW1waW5nIHRoZSBpbmRleCB0byBhIGhpZ2hlciBwYWdlIHNpemUgd2lsbCBoZWxw IGVpdGhlciBhcyB0aGUgZGF0YSBpcyBzbyBzbWFsbCB3ZSBjYW4gZWFzaWx5IGZpdCB0aGUgbWF4 IG51bWJlciBvZiB0aWRzIHBlciBwYWdlIGludG8gOGsgYXMgaXQgaXMuDQo+PiAgIA0KPj4gSWRl YXM/DQo+PiAgIA0KPj4gTWFydGluIEJvd2VzDQo+PiBfX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fXw0KPj4gSW5mby1pbmdyZXMgbWFpbGluZyBsaXN0DQo+PiBJ bmZvLWluZ3Jlc0BsaXN0cy5wbGFuZXRpbmdyZXMub3JnDQo+PiBodHRwczovL2xpc3RzLnBsYW5l dGluZ3Jlcy5vcmcvbWFpbG1hbi9saXN0aW5mby9pbmZvLWluZ3Jlcw0KPiBfX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0KPiBJbmZvLWluZ3JlcyBtYWlsaW5n IGxpc3QNCj4gSW5mby1pbmdyZXNAbGlzdHMucGxhbmV0aW5ncmVzLm9yZw0KPiBodHRwczovL2xp c3RzLnBsYW5ldGluZ3Jlcy5vcmcvbWFpbG1hbi9saXN0aW5mby9pbmZvLWluZ3Jlcw0KDQotLQ0K UGF1bCBXaGl0ZTxicj4NClNoaWZ0IFNldmVuIFNvbHV0aW9uczxicj4NCjxiPm06IDA0MTQ2ODE3 OTk8L2I+PGJyPg0KcDogMDc1NDQ4MjEzNzxicj4NCmU6IHBhdWwud2hpdGVAc2hpZnQ3c29sdXRp b25zLmNvbS5hdTxicj4NCnc6IGh0dHBzOi8vd3d3LnNoaWZ0N3NvbHV0aW9ucy5jb20uYXU8YnI+ DQpJbnRlcm5hdGlvbmFsOiArNjE0MTQ2ODE3OTk8YnI+DQoNCl9fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fDQpJbmZvLWluZ3JlcyBtYWlsaW5nIGxpc3QNCklu Zm8taW5ncmVzQGxpc3RzLnBsYW5ldGluZ3Jlcy5vcmcNCmh0dHBzOi8vbGlzdHMucGxhbmV0aW5n cmVzLm9yZy9tYWlsbWFuL2xpc3RpbmZvL2luZm8taW5ncmVzDQo=

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Who's Online
Recent Visitors
- Bob Worm
  Sat Oct 12 12:38:48 2024
  from Wales, Uk via Telnet
- Frut1ger_A3ro813
  Sat Oct 12 10:53:40 2024
  from England, Somerset via Telnet
- Keyop
  Fri Oct 11 19:33:23 2024
  from Huddersfield, West Yorkshire via SSH
- Keyop
  Fri Oct 11 19:28:14 2024
  from Huddersfield, West Yorkshire via SSH
- Bob Worm
  Fri Oct 11 11:27:11 2024
  from Wales, Uk via Telnet
- Bob Worm
  Fri Oct 11 08:32:50 2024
  from Wales, Uk via Telnet
- Chinaman
  Thu Oct 10 23:25:20 2024
  from Linkou,tw via Telnet
- Bob Worm
  Thu Oct 10 23:03:30 2024
  from Wales, Uk via Telnet

System Info

Sysop:	Keyop
Location:	Huddersfield, West Yorkshire, UK
Users:	354
Nodes:	16 (2 / 14)
Uptime:	39:54:30
Calls:	7,650
Calls today:	2
Files:	12,811
Messages:	5,699,585

[Info-ingres] index problem on a partitioned table

Who's Online

Recent Visitors

System Info