hi shridhar,
> Heiko Kehlenbrink wrote:
>
>> hi list,
>>
>> i want to convince people to use postgresql instead of ms-sql server, so i
>> set up a kind of comparission insert data / select data from postgresql /
>> ms-sql server
>>
>> the table i use was pretty basic,
>>
>> id bigserial
>> dist
Heiko Kehlenbrink wrote:
i want to convince people to use postgresql instead of ms-sql server, so i
set up a kind of comparission insert data / select data from postgresql /
ms-sql server
[...]
do you have any hints like compiler-flags and so on to get the answering
time from postgresql equal
Heiko Kehlenbrink wrote:
Hmm... I would suggest if you are testing, you should try 7.4.2. 7.4 has
some
good optimisation for hash agregates though I am not sure if it apply to
averaging.
would be the last option till we are runing other applications on that 7.2
system
I can understand..
Also try f
Heiko Kehlenbrink wrote:
[EMAIL PROTECTED]:~> psql -d test -c 'explain analyse select avg(dist)
from massive2 where dist > (100*sqrt(3.0))::float8 and dist <
(150*sqrt(3.0))::float8;'
NOTICE: QUERY PLAN:
Aggregate (cost=14884.61..14884.61 rows=1 width=8) (actual
time=3133.24..3133.24 row
Heiko Kehlenbrink wrote:
i use suse 8.1
postgresql 7.2 compiled from the rpms for using postgis, but that is
Try v7.4, there are many performance improvements. It may not make up
all the differences but it should help.
---(end of broadcast)---
"Heiko Kehlenbrink" <[EMAIL PROTECTED]> writes:
> i use suse 8.1
> postgresql 7.2 compiled from the rpms for using postgis, but that is
> anothe story...
7.4 might be a little quicker; but in any case you should be doing this
sort of comparison using the current release, no?
Heiko Kehlenbrink wrote:
hi list,
i want to convince people to use postgresql instead of ms-sql server, so i
set up a kind of comparission insert data / select data from postgresql /
ms-sql server
the table i use was pretty basic,
id bigserial
dist float8
x float8
y float8
z float
hi list,
i want to convince people to use postgresql instead of ms-sql server, so i
set up a kind of comparission insert data / select data from postgresql /
ms-sql server
the table i use was pretty basic,
id bigserial
dist float8
x float8
y float8
z float8
i filled the table wit
Heiko,
> 100.000 from 50.000.000:
>
> postgres: 0.88 sec
> ms-sql: 0.38 sec
>
> 200.000 from 50.000.000:
>
> postgres: 1.57 sec
> ms-sql: 0.54 sec
>
> 500.000 from 50.000.000:
>
> postgres: 3.66 sec
> ms-sql: 1.18 sec
Questions:
1. Is this the time to return *all rows* or just the first row? G