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