From: Jim C. Nasby <jnasby@pervasive.com>
To: Andy <frum@ar-sd.net>
Cc: Frank Wiles <frank@wiles.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Improving Inner Join Performance
Date: Wed, 11 Jan 2006 12:25:45 -0600
Message-ID: <20060111182545.GR3902@pervasive.com> (raw)
In-Reply-To: <009301c614f2$41d55920$0b00a8c0@forge>
References: <20060106111231.28cdcb72.frank@wiles.org>
<009301c614f2$41d55920$0b00a8c0@forge>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jnasby@pervasive.com, frum@ar-sd.net, frank@wiles.org
Subject: Re: Improving Inner Join Performance
In-Reply-To: <20060111182545.GR3902@pervasive.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox