Re: Performance aggregates
От | snpe |
---|---|
Тема | Re: Performance aggregates |
Дата | |
Msg-id | 01051620574703.00882@spnew обсуждение исходный текст |
Ответ на | Performance aggregates (snpe <snpe@infosky.net>) |
Список | pgsql-general |
On Tuesday 15 May 2001 14:40, you wrote: > Hello, > > I have 2 tables : > > CREATE TABLE e_kalkn ( > id INT4 NOT NULL, > roba VARCHAR(6) NOT NULL, > dat DATE NOT NULL, > datv DATE NOT NULL, > val VARCHAR(3) NOT NULL, > kod VARCHAR(3) NOT NULL, > tb VARCHAR(2) NOT NULL, > ts VARCHAR(2) NOT NULL, > dob VARCHAR(6), > status VARCHAR(1) > ); > CREATE TABLE e_kalkns ( > id INT4 NOT NULL, > redbr INT NOT NULL, > osn NUMERIC(30,6), > proc NUMERIC(30,6), > izn NUMERIC(30,6) > ); > > and indexes : > > create unique index e_kalkn_id on e_kalkn(id); > create index e_kalkns_id on e_kalkns(id); > > Table e_kalkn have 4668 rows and e_kalkns 101170 rows. > > Query : > > select roba,sum(izn) > from e_kalkn k,e_kalkns ks > where k.id=ks.id > group by roba > order by roba > > is 2.5 times faster on one commercial database (there are tests on Internet > that say 'Postgresql is faster than that database). > I can't say which database it is. > MySQL is 2.5 times faster, too. regards,
В списке pgsql-general по дате отправления: