shared_buffers + Windows - Mailing list pgsql-general

From Gordon
Subject shared_buffers + Windows
Date
Msg-id 1125555778.869982.44420@o13g2000cwo.googlegroups.com
Whole thread Raw
Responses Re: shared_buffers + Windows
List pgsql-general
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


pgsql-general by date:

Previous
From: Bob
Date:
Subject: Re: Select All Columns
Next
From: "Gordon"
Date:
Subject: Re: shared_buffers + Windows