Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Michael Kopljan
  Where is Michael Kopljan?
 Novi Sad
 Serbia
 Michael Kopljan
 To: Camil Ghircoias
  Where is Camil Ghircoias?
 Sibiu
 Romania
 Camil Ghircoias
 Tags
Subject: RE: postgresql tuning
Thread ID: 310526 Message ID: 310725 # Views: 36 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, June 23, 2011 8:53:34 PM         
   


> Hi,
>
> I have a MS server 2008 RS 64 bits on a server machine at one of my clients.
> It runs a postgresql 9 server database
> The server has 8 GB of ram and 16 cores
>
> What would be the best configuration for postgresql.conf file ?
> It seems it not uses enough memory, and queries processed on stored procedures takes longer as tested on an old pc with windows xp and 32 bits os.
>
> I tried to increase some of the parameters (effective_cache_size and shared_buffers) but with no great effect.
>
> Any help would be appreciated.
>
> Camil Ghircoias
> Vfp likes me.

Run "Application Stack Builder" and download EnterpriseDB TuningWizard. That utility analyze hardware configuration and setup postgresql.conf file.

ENTIRE THREAD

postgresql tuning Posted by Camil Ghircoias @ 6/22/2011 9:57:55 AM
RE: postgresql tuning Posted by Michael Kopljan @ 6/23/2011 8:53:34 PM
RE: postgresql tuning Posted by Camil Ghircoias @ 6/23/2011 9:58:38 PM