Upgrading to 7.2

Поиск
Список
Период
Сортировка
От Chris Field
Тема Upgrading to 7.2
Дата
Msg-id 1013703900.1606.7.camel@tux.dogoodsoft.org
обсуждение исходный текст
Список pgsql-hackers
I have a couple wuick questions about upgrading to 7.2.

First, are there noticable performance improvements with 7.2?  I am
currently using 7.1.2 and it is having a real hard time with large
tables(about 10million records), queries take forever(even simple ones
that are index scans)?

Second, when compiling with gcc, what level of optimization is safe to
use?  I know that some code when it is compiler optimized can break
really badly.

Third, 7.2 will allow for the creation of fuinctional indexes right? In
my current version, it refuses to create them saying that it cannot
create index on max(int4);

And last of all, is 7.2 just a drop in replacement, or is this going to
ba a painful process?


--
Chris Field
Affinity Solutions Inc.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: NAMEDATALEN Changes
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: Upgrading to 7.2