Medve Gábor wrote:
> Hi there,
>
> I have no experiences with big databases. Now I have a database that's size
> is appr. 7,6GB (HW/OS: Intel Pentium III 600MHz, 512MB RAM, GNU/Linux 2.2.19
> kernel). There is a big table in it with 25318267 tuples today. If I make a
> simple query (SELECT x,y,z FROM table WHERE x = something) then it takes
> 2m42s to get the results. Is it a good value?
I don't know, you tell me ;) How many results are exactly returned? Can
you run an EXPLAIN query? Did you VACUUM ANALYZE? Any indices defined on
"x"?
Jochem