I found this same problem. It's the "group by" that is the killer.
PostgreSQL's implementation of "group by" requires a sort of the entire
table on the group by criteria, even if there is an index on the group
by column. It's to bad this caused us not to be able to use Postgresql
for a project.
>
> My inquiry:
>
> Please discuss as to your point of view the advantage of
> PostgreSQL over
> Interbase and/or vise versa. I'm considering three (3)
> important points
>
> 1. Speed
Postgresql is "spotty". Some things it can do fast other
things are very slow. It's really mixed. So P
> -Original Message-
> From: Erick Papadakis [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, May 05, 2001 9:13 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] Re: Re: How to install on Windows?
>
>
> hi fabrice,
>
> thanks for taking the time to write that. i have indeed read
> the manu
egas [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 02, 2001 7:51 PM
> To: Albertson, Chris
> Subject: Re: [GENERAL] Ideal hardware configuration for pgsql
>
>
> I was wondering about those boxes, though more so as Web
> servers... I'm
> interested in any other th
What can I do to speed up queries like the following
select count(*) from ttt group by xxx;
Using Postgres 7.1 on Solaris 8 the above query on a 1M row
database takes 6 times longer than the following
select count(*) from ttt;
With Postgres "group by" is apparently quite expensive. Usi
We just bought a brand new Sun Netra X1. List pice from Sun was
$995.00. Yes under one grand. It is a 1U tall box. For once
Sun beats Intel prices. It comes with Solaris 8 preinstaled.
Basically just plug in and boot. We got a discount to $907.
We upgraded the RAM to 1GB (it uses PC133 RAM
