Re: Index-speeds

On Fri, Aug 03, 2001 at 11:35:45PM +0530, some SMTP stream spewed forth:
> Hi,
> Could you just tell me, why do my Access queries run at
least 2 times faster than PG queries and 1.5 times faster than MS-SQL.
The query involves one master table containing 10000 records, left -
joined for getting Transactional sums from records in other tables...
Purchases, Sales, PurReturns, SalesReturns, OtherIssues.

> It takes 60-75 seconds in access, 100-120 seconds in SQL Server and 150 seconds in PG

We really need more information. We need things like table definitions
and queries.

> Secondly, is it possible to have an index like :
> create index in_a on a.id where a.id>5000

Not in a current release.
There was some really good work done on partial indices recently, I
suspect they will be in 7.2.

> Thanx
> Kapil

gh
--
What, no one sings along with Ricky Martin anymore?
My kid sister does (but then, she prefers pico to vi ...)
-- Suresh Ramasubramanian, alt.sysadmin.recovery