Re: count * performance issue
От | Dave Cramer |
---|---|
Тема | Re: count * performance issue |
Дата | |
Msg-id | 3E9C3A51-C28E-4B75-9739-E344DAC72880@fastcrypt.com обсуждение исходный текст |
Ответ на | count * performance issue ("sathiya psql" <sathiya.psql@gmail.com>) |
Ответы |
Re: count * performance issue
|
Список | pgsql-performance |
Hi,
On 6-Mar-08, at 6:58 AM, sathiya psql wrote:
Yes it is the latest stable version.The only thing that is going to help you is really fast disks, and
more memory, and you should consider moving to 8.3 for all the other
performance benefits.Is 8.3 is a stable version or what is the latest stable version of postgres ??
You will have to test this yourself. There may be issuesmoving my database from 7.4 to 8.3 will it do any harm ??
Every version of postgresql has improved performance, and robustness; so you will get better overall performance. However I want to caution you this is not a panacea. It will NOT solve your seq scan problem.what are all the advantages of moving from 7.4 to 8.3
Dave
В списке pgsql-performance по дате отправления: