Hello I have next problem: I have Windows 2000 s. Postgresql 8.0 database have 300MB and hardware configuration (2 x P3 1Ghz,1GB RAM and SCSI HD). How set the shared_buffers and other parameters to better performance. for example: When i read table from workstation (20.000 record and 20 column) on the Windows 2000 s. - 40 sec. on the Debian (P 8.0) the same DB, the same Table - 3 sec. Kris ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
