Maybe we should convert the tables based on dependency.
Attached are the tables names as ordered in the universe-satellite.sql
that is created by the makefile.
Partha Aji wrote:
I generated an initial list of columns that were converted to bigint,
integer and float from NUMERIC that ora2pg spit out a while ago.... I
have attached the file.. It uses the space separated format
TableName ColumnName DataType
for example:
db_change_script_expanded line_no bigint
rhnaction id bigint
AFAIK its only problem is the non use of small-int... It should serve as
a comprehensive beginning list :)...
Partha
Gurjeet Singh wrote:
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.
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,
------------------------------------------------------------------------
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
------------------------------------------------------------------------
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
web_customer
rhnArchType
rhnChannelArch
rhnChannelProduct
rhnProductName
rhnChannel
rhnChannelFamily
rhnPublicChannelFamily
web_contact
rhnPrivateChannelFamily
rhnServerArch
rhnProvisionState
rhnServer
rhnServerChannel
rhnServerGroupType
rhnException
rhnServerGroup
rhnPackageEVR
rhnPackageArch
rhnPackageGroup
rhnSourceRPM
rhnPackage
rhnChannelPackage
rhnSet
rhn_command_groups
rhn_command_class
rhn_command_requirements
rhn_command
rhn_probe_types
rhn_probe
rhn_command_target
rhn_physical_location
rhn_sat_cluster
rhn_check_probe
rhn_check_suites
rhn_check_suite_probe
rhn_command_center_state
rhn_widget
rhn_semantic_data_type
rhn_command_parameter
rhn_command_queue_commands
rhn_command_queue_execs_bk
rhn_command_queue_instances
rhn_command_queue_execs
rhn_command_queue_instances_bk
rhn_command_queue_params
rhn_command_queue_sessions
rhn_config_group
rhn_environment
rhn_config_macro
rhn_config_security_type
rhn_config_parameter
rhn_method_types
rhn_pager_types
rhn_schedule_types
rhn_schedules
rhn_time_zone_names
rhn_notification_formats
rhnTimezone
rhnUserInfo
rhn_contact_methods
rhn_strategies
rhn_contact_groups
rhn_contact_group_members
web_user_prefix
web_user_personal_info
rhn_current_alerts
rhn_current_state_summaries
rhn_db_environment
rhn_deployed_probe
rhn_host_probe
rhn_host_check_suites
rhn_os
rhn_server_monitoring_info
rhnServerNetInterface
rhn_interface_monitoring
rhn_ll_netsaint
rhn_quanta
rhn_units
rhn_metrics
rhn_multi_scout_threshold
rhn_notifservers
rhn_os_commands_xref
rhn_probe_param_value
rhn_probe_state
rhn_redirect_types
rhn_redirects
rhn_redirect_match_types
rhn_redirect_criteria
rhn_redirect_email_targets
rhn_redirect_group_targets
rhn_redirect_method_targets
rhn_sat_cluster_probe
rhn_satellite_state
rhn_sat_node
rhn_sat_node_probe
rhn_schedule_days_norm
rhn_schedule_days
rhn_schedule_weeks
rhn_service_probe_origins
rhn_snmp_alert
rhn_threshold_type
rhn_url_probe
rhn_url_probe_step
demo_log
PXTSessions
rhnActionType
rhnAction
rhnActionStatus
rhnServerAction
rhnConfigChannelType
rhnConfigChannel
rhnActionConfigChannel
rhnActionConfigDateFile
rhnActionConfigDate
rhnConfigFileName
rhnConfigFileFailure
rhnConfigFileState
rhnConfigFile
rhnConfigInfo
rhnConfigContent
rhnConfigFileType
rhnConfigRevision
rhnActionConfigFileName
rhnActionConfigRevision
rhnActionConfigRevisionResult
rhnActionDaemonConfig
rhnErrataSeverity
rhnErrata
rhnActionErrataUpdate
rhnKSTreeType
rhnKSInstallType
rhnKickstartableTree
rhnActionKickstart
rhnFileList
rhnActionKickstartFileList
rhnKSData
rhnKickstartSessionState
rhnServerProfileType
rhnServerProfile
rhnKickstartVirtualizationType
rhnKickstartSession
rhnActionKickstartGuest
rhnActionPackage
rhnActionPackageAnswerfile
rhnPackageDelta
rhnActionPackageDelta
rhnActionPackageOrder
rhnPackageCapability
rhnActionPackageRemovalFailure
rhnActionScript
rhnTransaction
rhnActionTransactions
rhnActionVirtDestroy
rhnActionVirtReboot
rhnActionVirtRefresh
rhnActionVirtResume
rhnActionVirtSchedulePoller
rhnActionVirtSetMemory
rhnActionVirtShutdown
rhnActionVirtStart
rhnActionVirtSuspend
rhnActionVirtVcpu
rhnRegToken
rhnActivationKey
rhnAllowTrust
rhnAppInstallInstance
rhnAppInstallSession
rhnAppInstallSessionData
rhnArchTypeActions
rhnBeehivePathMap
rhnPackageNEVRA
rhnErrataFileType
rhnSnapshotInvalidReason
rhnTagName
rhnTag
rhnBlacklistObsoletes
rhnChannelComps
rhnChannelCloned
rhnFile
rhnDownloadType
rhnDownloads
rhnChannelDownloads
rhnChannelErrata
rhnChannelFamilyMembers
rhnVirtSubLevel
rhnChannelFamilyVirtSubLevel
rhnChannelNewestPackageAudit
rhnChannelNewestPackage
rhnChannelPackageArchCompat
rhnSnapshot
rhnSnapshotChannel
rhnChannelParent
rhnChannelPermissionRole
rhnChannelPermission
rhnChannelTrust
rhnClientCapabilityName
rhnClientCapability
rhn_command_param_threshold
rhnSnapshotConfigChannel
rhnSnapshotConfigRevision
rhnOrgQuota
rhnCpuArch
rhnCpu
rhnCryptoKeyType
rhnCryptoKey
rhnCryptoKeyKickstart
rhnCustomDataKey
rhnDaemonState
rhnDailySummaryQueue
rhnDevice
rhnDistChannelMap
rhnEmailAddressState
rhnEmailAddress
rhnEmailAddressLog
rhnEntitlementLog
rhnErrataBuglist
rhnErrataTmp
rhnErrataBuglistTmp
rhnErrataCloned
rhnErrataClonedTmp
rhnErrataCVE
rhnErrataFile
rhnErrataFileChannel
rhnErrataFileTmp
rhnErrataFileChannelTmp
rhnPackageSource
rhnErrataPackage
rhnErrataFilePackageSource
rhnErrataFilePackage
rhnErrataFilePackageTmp
rhnErrataKeyword
rhnErrataKeywordTmp
rhnErrataNotificationQueue
rhnErrataPackageTmp
rhnErrataQueue
rhnFAQClass
rhnFAQ
rhnFeature
rhnFileDownload
rhnFileListMembers
rhnFileLocation
rhnGrailComponentChoices
rhnUserGroupType
rhnGrailComponents
rhnIndexerWork
rhnInfoPane
rhnKickstartChildChannel
rhnKickstartCommandName
rhnKickstartCommand
rhnKickstartDefaultRegToken
rhnKickstartDefaults
rhnKickstartIPRange
rhnKickstartPackage
rhnKickstartPreserveFileList
rhnKickstartScript
rhnKickstartSessionHistory
rhnKickstartTimezone
rhnKSTreeFile
rhnMessagePriority
rhnMessageType
rhnMessage
rhnMonitorGranularity
rhnMonitor
rhnOrgChannelSettingsType
rhnOrgChannelSettings
rhnOrgEntitlementType
rhnOrgEntitlements
rhnOrgErrataCacheQueue
rhnOrgInfo
rhnPackageChangelog
rhnPackageConflicts
rhnTransactionOperation
rhnTransactionPackage
rhnPackageDeltaElement
rhnPackageFileDeleteQueue
rhnPackageFile
rhnPackageKeyType
rhnPackageProvider
rhnPackageKey
rhnPackageKeyAssociation
rhnPackageObsoletes
rhnPackageProvides
rhnPackageRequires
rhnPackageSense
rhnPackageSenseMap
rhnPackageSyncBlacklist
rhnPathChannelMap
rhnProductLine
rhnProduct
rhnProductChannel
rhnProxyInfo
rhnPushClientState
rhnPushClient
rhnPushDispatcher
rhnRam
rhnRedHatCanonVersion
rhnRegTokenChannels
rhnRegTokenConfigChannels
rhnRegTokenEntitlement
rhnRegTokenGroups
rhnRegTokenOrgDefault
rhnRegTokenPackages
rhnRelationshipType
rhnReleaseChannelMap
rhnSatelliteCert
rhnSatelliteChannelFamily
rhnSatelliteInfo
rhnSatelliteServerGroup
rhnSavedSearchType
rhnSavedSearch
rhnServerActionPackageResult
rhnServerActionScriptResult
rhnServerActionVerifyMissing
rhnServerActionVerifyResult
rhnServerCacheInfo
rhnServerChannelArchCompat
rhnServerConfigChannel
rhnServerCustomDataValue
rhnServerDMI
rhnServerEvent
rhnServerGroupMembers
rhnServerGroupNotes
rhnUserGroup
rhnSnapshotServerGroup
rhnServerGroupTypeFeature
rhnServerHistory
rhnServerInfo
rhnServerInstallInfo
rhnServerLocation
rhnServerLock
rhnServerMessage
rhnServerNeededErrataCache
rhnServerNeededPackageCache
rhnServerNetwork
rhnServerNotes
rhnServerPackageArchCompat
rhnServerPackage
rhnServerPath
rhnServerPreserveFileList
rhnServerProfilePackage
rhnServerServerGroupArchCompat
rhnServerTokenRegs
rhnServerUuid
rhnSGTypeBaseAddonCompat
rhnSGTypeVirtSubLevel
rhnSnapshotPackage
rhnSnapshotTag
rhnSNPErrataQueue
rhnSNPServerQueue
rhnSolarisPackage
rhnSolarisPatchedPackage
rhnSolarisPatchPackages
rhnSolarisPatchSet
rhnSolarisPatchSetMembers
rhnSolarisPatchType
rhnSolarisPatch
rhnSystemMigrations
rhnTaskQueue
rhnTemplateCategory
rhnTemplateString
rhnTextMessage
rhnTransactionElement
rhnTrustedOrgs
rhnUserDefaultSystemGroups
rhnUserGroupMembers
rhnUserInfoPane
rhnUserMessageStatus
rhnUserMessage
rhnUserMessageType
rhnUserReserved
rhnUserServerGroupPerms
rhnUserServerPerms
rhnUserServerPrefs
rhnVersionInfo
rhnVirtualInstance
rhnVirtualInstanceEventType
rhnVirtualInstanceState
rhnVirtualInstanceEventLog
rhnVirtualInstanceType
rhnVirtualInstanceInfo
rhnVirtualInstanceInstallLog
rhnVisibleObjects(
rhnWebContactChangeState
rhnWebContactChangeLog
state_change
time_series
valid_countries
valid_countries_tl
web_customer_notification
web_user_contact_permission
web_user_site_type
web_user_site_info
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
