pgtune

type AutoConfFile struct {
	Parameters map[string]*AutoConfParameter
	Comments   []string // standalone comments (not associated with parameters)
}

type AutoConfParameter struct {
	Name    string
	Value   string
	Comment string // inline comment if any
}

type OptimizeOptions struct {
	Enabled        bool
	DataDir        string
	DBType         string
	MaxConnections int
	MemoryMB       int
	Cores          int
	SystemInfo     *sysinfo.SystemInfo
}

type PostProcessor func(*pkg.PostgresConf, *sysinfo.SystemInfo) error

type TunedParameters struct {
	// Memory parameters (in KB unless noted)
	SharedBuffers      Size `pretty:"format=bytes" json:"shared_buffers,omitempty"`       // shared_buffers
	EffectiveCacheSize Size `pretty:"format=bytes" json:"effective_cache_size,omitempty"` // effective_cache_size
	MaintenanceWorkMem Size `pretty:"format=bytes" json:"maintenance_work_mem,omitempty"` // maintenance_work_mem
	WorkMem            Size `pretty:"format=bytes" json:"work_mem,omitempty"`             // work_mem

	// WAL parameters (in KB unless noted)
	WalBuffers                 Size    `pretty:"format=bytes" json:"wal_buffers,omitempty"`  // wal_buffers
	MinWalSize                 Size    `pretty:"format=bytes" json:"min_wal_size,omitempty"` // min_wal_size
	MaxWalSize                 Size    `pretty:"format=bytes" json:"max_wal_size,omitempty"` // max_wal_size
	CheckpointCompletionTarget float64 `json:"checkpoint_completion_target,omitempty"`       // checkpoint_completion_target

	// Performance parameters
	RandomPageCost          float64 `json:"random_page_cost,omitempty"`          // random_page_cost
	EffectiveIoConcurrency  *int    `json:"effective_io_concurrency,omitempty"`  // effective_io_concurrency (nil if not applicable)
	DefaultStatisticsTarget int     `json:"default_statistics_target,omitempty"` // default_statistics_target

	// Parallel processing parameters
	MaxWorkerProcesses            int  `json:"max_worker_processes,omitempty"`             // max_worker_processes
	MaxParallelWorkers            int  `json:"max_parallel_workers,omitempty"`             // max_parallel_workers (PG 10+)
	MaxParallelWorkersPerGather   int  `json:"max_parallel_workers_per_gather,omitempty"`  // max_parallel_workers_per_gather
	MaxParallelMaintenanceWorkers *int `json:"max_parallel_maintenance_workers,omitempty"` // max_parallel_maintenance_workers (PG 11+)

	// WAL level settings
	WalLevel      string `json:"wal_level,omitempty"`       // wal_level
	MaxWalSenders *int   `json:"max_wal_senders,omitempty"` // max_wal_senders (set to 0 when wal_level=minimal)

	// Connection parameters
	MaxConnections int `json:"max_connections,omitempty"` // max_connections

	// Huge pages setting
	HugePages string `json:"huge_pages,omitempty"` // huge_pages

	// Warning messages for memory constraints
	Warnings []string `json:"warnings,omitempty"`
}

type TuningConfig struct {
	sysinfo.Resources

	PostgreSQLVersion float64

	// MaxConnections is the maximum number of database connections
	MaxConnections int

	// DBType is the database workload type
	DBType string

	OSType sysinfo.OSType

	// DiskType overrides detected disk type if specified
	DiskType *sysinfo.DiskType
}