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" <[EMAIL PROTECTED]> > To: "Andy" <[EMAIL PROTECTED]> > 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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > > http://www.wiles.org > > --------------------------------- > > > > > > -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
