Re: Improving Inner Join Performance

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@wiles.org>
> To: "Andy" <frum@ar-sd.net>
> 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@ar-sd.net> 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@wiles.org>
> >   http://www.wiles.org
> > ---------------------------------
> >
> >
> >

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461