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

Re: Tryint to match Solaris-Oracle performance with directio?

From: Shachar Shemesh <psql(at)shemesh(dot)biz>
To: ischamay(dot)andbergsay(at)activestateway(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Tryint to match Solaris-Oracle performance with directio?
Date: 2004-09-18 17:02:48
Message-ID: 414C6A38.1060800@shemesh.biz (view raw or flat)
Thread:
Lists: pgsql-performance
Mischa Sandberg wrote:

> In the meantime, what I gather from browsing mail archives is that 
> postgresql on Solaris seems to get hung up on IO rather than CPU.

Well, people more knowledgeable in the secrets of postgres seem 
confident that this is not your problem. Fortunetly, however, there is a 
simple way to find out.

Just download the utinyint var type from pgfoundry 
(http://pgfoundry.org/projects/sql2pg/). There are some stuff there you 
will need to compile yourself from CVS. I'm sorry, but I haven't done a 
proper release just yet. In any case, the utinyint type should provide 
you with the data type you seek, and thus allow you to find out whether 
this is, indeed, the problem.

-- 
Shachar Shemesh
Lingnu Open Source Consulting ltd.
http://www.lingnu.com/


In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2004-09-18 19:48:13
Subject: Re: Planner having way wrong estimate for group aggregate
Previous:From: Steinar H. GundersonDate: 2004-09-18 17:01:17
Subject: Planner having way wrong estimate for group aggregate

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