Postgres & large tables on average machine

Поиск
Список
Период
Сортировка
От Nicholay P. Chuprynin
Тема Postgres & large tables on average machine
Дата
Msg-id Pine.LNX.4.21.0203292322350.1811-100000@smash.infoport.uz
обсуждение исходный текст
Ответы Re: Postgres & large tables on average machine  (Peter Eisentraut <peter_e@gmx.net>)
Re: Postgres & large tables on average machine  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Список pgsql-admin
Hello, All!
Resently I had to create and manage the (relatively) large table.
In the mean time it's about 8 million rows, and surely will grow above
this size.
The problem is that queries takes absolutely not acceptable time.
Database located on average Celeron 400 machine with 128 Mb of RAM and
UDMA 33 capable IDE drive.
I run PostgreSQL 7.1 on Debian Linux with 2.4.18 kernel.
My question is what could be done in order to improve the performance?
I mean, is that normal behavior for Postgres on such computer or I
encounter a misconfiguration?

Nicholay


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

Предыдущее
От: Herb Blacker
Дата:
Сообщение: Index Existence
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Postgres & large tables on average machine