Re: MSSQL versus Postgres timing

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Joel Fradkin <jfradkin(at)wazagua(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: MSSQL versus Postgres timing
Date: 2005-02-01 16:59:07
Message-ID: 1107277147.16640.162.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 2005-02-01 at 10:54, Joel Fradkin wrote:
> All is moving along well.
>
> I have all my views and data and am testing things out a bit.
>
> A table with 645,000 records for associates has view (basically select
> * from tblassociates where clientnum = ‘test’)

What does

explain analyze select * from tblassociates where clientnum = ‘test’

say?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dennis Sacks 2005-02-01 17:00:30 Re:
Previous Message Joel Fradkin 2005-02-01 16:54:11 MSSQL versus Postgres timing