Performance question (PostgreSQL 7.1.3)
От
Medve Gábor
Тема
Performance question (PostgreSQL 7.1.3)
Дата
Msg-id
D6A8137C15878B4780C96979E9E3C19510A8B6@mrxch3.pgsm.hu
Список
Дерево обсуждения
Performance question (PostgreSQL 7.1.3) Medve Gábor <GMedve@PGSM.HU>
Re: Performance question (PostgreSQL 7.1.3) "Josh Berkus" <josh@agliodbs.com>
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've read the documentation and I've checked the kernel parameters (sem.h and shmparam.h) and the parameter values in postgresql.conf and I have no idea what could I do to get the results in shorter time period. Thanks for any kindness in advance. Greetings from Hungary, Gabor
В списке pgsql-novice по дате отправления