Re: Limitations on 7.0.3?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Limitations on 7.0.3?
Дата
Msg-id 4669A6D2.60507@g2switchworks.com
обсуждение исходный текст
Ответ на Re: Limitations on 7.0.3?  ("ARTEAGA Jose" <Jose.Arteaga@alcatel-lucent.com>)
Список pgsql-general
ARTEAGA Jose wrote:
> Also worth mentioning is that I just this week found out about a very,
> very important parameter "shared buffers". Ever since the original
> person setup our PG (individual no longer with us) this DB had been
> running without any major glitches, albeit slow. All this time the
> shared buffers were running at default of "64" (8192 block size). Once I
> have got this back up and running I have since set this to 1600 shared
> buffers (~125MB). I've since noticed a dramatic performance improvement,
> I hope that I've striked gold. But cannot claim victory yet it's only
> been up for 2 days.
If you think increasing shared buffers in 7.0 improves things, you
should see what upgrading to 8.2.4 will do.

Seriously, you'll freak at the increase in speed.

7.0 = handcar: http://www.handcar.net/
8.2 = TGV:  http://en.wikipedia.org/wiki/TGV

(p.s. please upgrade before 7.0 eats your data...)

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Wider than float8
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Record Types Structure in PL/pgSQL