shared_buffers + Windows

From: "Gordon" <krzysztofgorniak(at)wp(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: shared_buffers + Windows
Date: 2005-09-01 06:22:59
Message-ID: 1125555778.869982.44420@o13g2000cwo.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gordon 2005-09-01 06:26:30 Re: shared_buffers + Windows
Previous Message Art Fore 2005-09-01 06:12:09 syslog message I do not understand