Re: how to configure my new server

pgsql-performance-owner@postgresql.org wrote:
> Objet : [PERFORM] how to configure my new server
> Importance : Haute
>
>
> I've a new configuration for our web server
>
> Processor    Processeur Intel Xeon 2.0 Ghz / 512 Ko de cache L2
> Memoiry    1 Go DDR SDRAM
> Disk1    18Go Ultra 3 (Ultra 160) SCSI 15 Ktpm
> Disk2    18Go Hot Plug Ultra 3 (Ultra 160) SCSI 15 Ktpm
> Disk3    18Go Hot Plug Ultra 3 (Ultra 160) SCSI 15 Ktpm
> Disk4    18Go Hot Plug Ultra 3 (Ultra 160) SCSI 15 Ktpm
> Disk5    36Go Hot Plug Ultra 3 (Ultra 160) SCSI 15 Ktpm
>
> I will install a Mandrake 8.2
>
> It's an application server that runs things other than just
> postgresql. It also runs: apache + Php , bigbrother, log analyser.
>
>
> At the moment, on my old server, there's postgresql 7.2.3
>  my database takes 469M and there are approximatively
> 5 millions query per day
>
>
> what values should I use for
>
> linux values:
> kernel.shmmni = 4096
> kernel.shmall = 32000000
> kernel.shmmax = 256000000
>
> postgresql values:
> shared_buffers
> max_fsm_relations
> max_fsm_pages
> wal_buffers
> wal_files
> sort_mem
> vacuum_mem
>
>
> any other advices are welcome
>
> thanks in advance
>
>
>
> ---------------------
> Philip johnson
> 01 64 86 83 00
> http://www.atempo.com
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 4: Don't 'kill -9' the
> postmaster

Someone is able to help me ?