Re: Postgres & large tables on average machine

Nicholay P. Chuprynin writes:

> 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?

It is perfectly normal for queries to take an absolutely unacceptable
amount of time, but without providing any sort of detail about the
involved schema and data it's impossible to figure out if the performance
could be improved.

--
Peter Eisentraut peter_e(at)gmx(dot)net