Largest table size
This topic came up as part of the "Strip and Mirror Everything" thread. I excerpt it here because I'd like clarify my understanding, of this specific issue (orthogonal to the SAME discussion), and some folks may not be following that other, more general, thread. >if any single table reaches a certain size, it becomes to big to fit into a single >dbspace (under 9.40). You must then fragment the table, and (under >9.40 and earlier), each fragment must go into a separate dbspace It sounds like the poster is saying that maximum table size (for an unfragmented table) is less than the size of the dbspace in which it was created. I am trying to find info on this in the docs. Might anyone know what the max size of a table is, and how it relates to the size of the dbspace in which it exists? Thank you. DG -- David Grove - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - "I think not," said Descartes, and disappeared.
If you have a 2k page size, the limit for an unfragmentted table is 32GB. The limiting factor is listed in Release Notes as Data pages per fragment. Dave Griffen "David E. Grove" <david_grove@correct.state.ak.us> wrote in message news:10kjoi6n1k5v9b3@corp.supernews.com... > This topic came up as part of the "Strip and Mirror Everything" thread. I > excerpt it here because I'd like clarify my understanding, of this specific > issue (orthogonal to the SAME discussion), and some folks may not be > following that other, more general, thread. > > > >if any single table reaches a certain size, it becomes to big to fit into a > single > >dbspace (under 9.40). You must then fragment the table, and (under > >9.40 and earlier), each fragment must go into a separate dbspace > > It sounds like the poster is saying that maximum table size (for an > unfragmented table) is less than the size of the dbspace in which it was > created. I am trying to find info on this in the docs. Might anyone know > what the max size of a table is, and how it relates to the size of the > dbspace in which it exists? > > Thank you. > > > DG > > > > > > -- > David Grove > > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > "I think not," said Descartes, and disappeared. > >
Thank you, Dave. I was looking in the manuals, I should have thought to check the release notes. DG "Dave Griffen" <dgriffen@finishline.com> wrote in message news:cicqv5$11v$1@news.onecall.net... > If you have a 2k page size, the limit for an unfragmentted table is 32GB. > The limiting factor is listed in Release Notes as Data pages per fragment. > > Dave Griffen > > "David E. Grove" <david_grove@correct.state.ak.us> wrote in message > news:10kjoi6n1k5v9b3@corp.supernews.com... > > This topic came up as part of the "Strip and Mirror Everything" thread. I > > excerpt it here because I'd like clarify my understanding, of this > specific > > issue (orthogonal to the SAME discussion), and some folks may not be > > following that other, more general, thread. > > > > > > >if any single table reaches a certain size, it becomes to big to fit into > a > > single > > >dbspace (under 9.40). You must then fragment the table, and (under > > >9.40 and earlier), each fragment must go into a separate dbspace > > > > It sounds like the poster is saying that maximum table size (for an > > unfragmented table) is less than the size of the dbspace in which it was > > created. I am trying to find info on this in the docs. Might anyone know > > what the max size of a table is, and how it relates to the size of the > > dbspace in which it exists? > > > > Thank you. > > > > > > DG > > > > > > > > > > > > -- > > David Grove > > > > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > > "I think not," said Descartes, and disappeared. > > > > > >