Skip site navigation (1) Skip section navigation (2)

Re: selects from large tables

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: selects from large tables
Date: 2002-11-18 15:43:02
Message-ID: 20021118104302.F30738@mail.libertyrms.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, Nov 18, 2002 at 03:36:08PM -0000, Nikk Anderson wrote:
> Hi, 
> 
> Unfortunately explain analyze does not work on our postgres version (7.1) ?

No, it doesn't.

> I think I will download and compile 7.2, and try to compile in 64bit mode to
> see if that helps improve performance.

I have seen something like a 40% improvement in performance from 7.1
to 7.2 on Solaris 7 in my tests.  There are some problems with the 64
bit compilation, by the way, so make sure that you check out the
FAQ and test carefully.  You need to make some modifications of the
source files in order to avoid some buggly libraries on Solaris.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info>                              M2P 2A8
                                         +1 416 646 3304 x110


In response to

pgsql-performance by date

Next:From: Charles H. WoloszynskiDate: 2002-11-18 15:46:11
Subject: Re: selects from large tables
Previous:From: Nikk AndersonDate: 2002-11-18 15:36:08
Subject: Re: selects from large tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group