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(at)wiles(dot)org>
> To: "Andy" <frum(at)ar-sd(dot)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(at)ar-sd(dot)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(at)wiles(dot)org>
> > http://www.wiles.org
> > ---------------------------------
> >
> >
> >

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