Subject | Re: Firebird 2.0 Indexing (Cont.) vs. PostgreSQL |
---|---|
Author | buppcpp |
Post date | 2005-06-03T21:41:01Z |
> Well, it doesn't make big difference. I've performed a quick testwith FB
> 1.5.2 and PG 8.0 on win32. On second run FB is faster than PG,except the
> GROUP BY clause (where PG slightly wins). But the first run (whenour page
> cache is empty) makes a very big difference: PG is about 20xfaster than FB.
> I don't believe in miracles, so I suspect some in advance databasecaching
> on the PG side, but neither of the PG backend processes occupiedmore than
> 10MB of RAM whilst the test table was 50M. I think this should beThanks Dmitry for taking a look at this and acknownledging that FB
> investigated a bit further.
>
>
> Dmitry
could handle this better.
That goes a long way in my book to be able to admit that another
product does something better and then say "I think this should be
investigated a bit further.".
Again, Thanks