Home > mailing lists

Re: MSSQL versus Postgres timing - Mailing list pgsql-sql

From	Scott Marlowe
Subject	Re: MSSQL versus Postgres timing
Date	February 1, 2005 19:59:17
Msg-id	1107277147.16640.162.camel@state.g2switchworks.com Whole thread Raw
In response to	MSSQL versus Postgres timing ("Joel Fradkin" <jfradkin@wazagua.com>)
Responses	Re: MSSQL versus Postgres timing
List	pgsql-sql

Tree view

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?

pgsql-sql by date:

From: "Joel Fradkin"
Date: 01 February 2005, 19:51:46
Subject: MSSQL versus Postgres timing

From: Dennis Sacks
Date: 01 February 2005, 19:59:32
Subject: Re:

Re: MSSQL versus Postgres timing - Mailing list pgsql-sql

Previous

Next