Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Camil Ghircoias
  Where is Camil Ghircoias?
 Sibiu
 Romania
 Camil Ghircoias
 To: Michael Kopljan
  Where is Michael Kopljan?
 Novi Sad
 Serbia
 Michael Kopljan
 Tags
Subject: RE: postgresql tuning
Thread ID: 310526 Message ID: 310730 # Views: 27 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, June 23, 2011 9:58:38 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.

Thank's

Camil Ghircoias
Vfp likes me.

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