Did you originally post some problem queries? The settings look OK, though 1G of memory isn't very much now-a-days. On Mon, Jan 09, 2006 at 09:56:52AM +0200, Andy wrote: > shared_buffers = 10240 > effective_cache_size = 64000 > RAM on server: 1Gb. > > Andy. > > ----- Original Message ----- > > From: "Frank Wiles" <frank@xxxxxxxxx> > To: "Andy" <frum@xxxxxxxxx> > Sent: Friday, January 06, 2006 7:12 PM > Subject: Re: [PERFORM] Improving Inner Join Performance > > > > On Fri, 6 Jan 2006 09:59:30 +0200 > > "Andy" <frum@xxxxxxxxx> wrote: > > > >> Yes I have indexes an all join fields. > >> The tables have around 30 columns each and around 100k rows. > >> The database is vacuumed every hour. > > > > What are you settings for: > > > > shared_buffers > > effective_cache_size > > > > And how much RAM do you have in the server? > > > > --------------------------------- > > Frank Wiles <frank@xxxxxxxxx> > > http://www.wiles.org > > --------------------------------- > > > > > > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
