> Hi All, > > Porting Oracle's NUMBER datatype to Postgres' numeric datatype > might seem very straight-forward. But the NUMERIC datatype is known to > have a huge performance impact on the query run-times. > > So we have decided to convert the number columns to > SMALLINT/INTEGER/BIGINT wherever possible. In the last conference > call, Jeff opined that we first target those columns for migration > which are NUMBERs and are part of PRIMARY KEY, as this will help us > in migrating the FOREIGN KEY columns pointing to these PKey columns; > and these two categories of columns will cover most NUMBER columns > that might affect the performance. > > Please find attached the list of primary key columns of datatype > NUMBER, their table names, precision and scale (under the columns > "P,S"), the names of the PRIMARY KEY constraints. > > What we are looking for from the developers is that they should > comment about the possible MAX_VAL for these columns. For example, > Devan pointed out the other day that in the application there are only > around 50 action types, which limits the number of values of > "rhnActionType"."id" column to no more than 50 values. Now equipped > with this knowledge, this column can be easily converted to SMALLINT; > also, other columns referencing this column can also be converted to > SMALLINT. > A lot of the primary keys are put into various tablespaces such as [[2m_tbs]], [[4m_tbs]], [[64k_tbs]].
Is the intention that those tablespaces indicate roughly the size that each key could occupy? Is it possible to use those as a guide when converting from number to a postgres sized number column? > So please come forward and comment on what would be the best data > type for the columns listed in the attached file. We need this. > > Thanks and best regards, > -- > gurjeet[.sin...@enterprisedb.com > EnterpriseDB http://www.enterprisedb.com > > singh.gurj...@{ gmail | hotmail | indiatimes | yahoo }.com > > _______________________________________________ > Spacewalk-devel mailing list > Spacewalk-devel@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-devel -- Jason Dobies (jason.dob...@redhat.com) RHN Satellite & Spacewalk RHCE# 805008743336126 Freenode: jdob @ #spacewalk, #spacewalk-devel _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
