Upgrading to 7.2

From: Chris Field <cfields(at)affinitysolutions(dot)com>
To: Postgresql <pgsql-hackers(at)postgresql(dot)org>
Subject: Upgrading to 7.2
Date: 2002-02-14 16:25:00
Message-ID: 1013703900.1606.7.camel@tux.dogoodsoft.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2002-02-14 16:53:17 Re: [GENERAL] Postgres 7.2 - Updating rows in cursor problem
Previous Message Tom Lane 2002-02-14 14:57:50 Re: NAMEDATALEN Changes