Re: Improving Inner Join Performance

От: Andy
Тема: Re: Improving Inner Join Performance
Дата: ,
Msg-id: 009301c614f2$41d55920$0b00a8c0@forge
(см: обсуждение, исходный текст)
Ответ на: Improving Inner Join Performance  ("Andy")
Ответы: Re: Improving Inner Join Performance  ("Jim C. Nasby")
Список: pgsql-performance

Скрыть дерево обсуждения

Improving Inner Join Performance  ("Andy", )
 Re: Improving Inner Join Performance  (Frank Wiles, )
 Re: Improving Inner Join Performance  ("Andy", )
  Re: Improving Inner Join Performance  (Michael Glaesemann, )
 Re: Improving Inner Join Performance  ("Andy", )
 Re: Improving Inner Join Performance  (Pandurangan R S, )
 Re: Improving Inner Join Performance  ("Andy", )
  Re: Improving Inner Join Performance  (Jaime Casanova, )
 Re: Improving Inner Join Performance  ("Andy", )
  Re: Improving Inner Join Performance  ("Jim C. Nasby", )

shared_buffers = 10240
effective_cache_size = 64000
RAM on server: 1Gb.

Andy.

----- Original Message -----

From: "Frank Wiles" <>
To: "Andy" <>
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" <
> 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 <
>
>  
http://www.wiles.org
> ---------------------------------
>
>
>

В списке pgsql-performance по дате сообщения:

От: Alessandro Baretta
Дата:
Сообщение: 500x speed-down: Wrong query plan?
От: Kelly Burkhart
Дата:
Сообщение: Re: help tuning queries on large database