Re: More Praise for 7.4RC2
От | Reece Hart |
---|---|
Тема | Re: More Praise for 7.4RC2 |
Дата | |
Msg-id | 1068687983.5532.10.camel@whoville обсуждение исходный текст |
Ответ на | Re: More Praise for 7.4RC2 (jake@omnimode.com (jake johnson)) |
Ответы |
Re: More Praise for 7.4RC2
Re: More Praise for 7.4RC2 |
Список | pgsql-general |
On Wed, 2003-11-12 at 09:04, jake johnson wrote:
I agree that this seems likely, except that the 7.3.4 database is vacuumed nightly, and analyzed periodically. And about a week ago I reclustered on the index intended to most facilitate this select. Furthermore, merely hardcoding the subselect result achieves a tremendous improvement (which was the workaround I used). So, I'm pretty sure that it's not a vacuum, index use, or cleanliness issue.
I also meant to add in my original post that the system is a dual 2.4G xeon with 4GB of RAM.
-Reece
I also posted about the performance increase of 7.4, but I think that much of the difference you're seeing (because it's such a large difference) is probably due to the cleanliness of a newly restored database from backup.
I agree that this seems likely, except that the 7.3.4 database is vacuumed nightly, and analyzed periodically. And about a week ago I reclustered on the index intended to most facilitate this select. Furthermore, merely hardcoding the subselect result achieves a tremendous improvement (which was the workaround I used). So, I'm pretty sure that it's not a vacuum, index use, or cleanliness issue.
I also meant to add in my original post that the system is a dual 2.4G xeon with 4GB of RAM.
-Reece
-- Reece Hart, http://www.in-machina.com/~reece/, GPG:0x25EC91A0 0xD178AAF9 |
В списке pgsql-general по дате отправления: