Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance of count(*) on large tables vs SQL Server - Mailing list pgsql-performance

From PFC
Subject Re: Performance of count(*) on large tables vs SQL Server
Date
Msg-id opslite4tuth1vuj@musicbox
Whole thread Raw
In response to Performance of count(*) on large tables vs SQL Server  (Andrew Mayo <ajmayo@kohuconsulting.com>)
List pgsql-performance
Tree view 

> clause will be a cheap query  - and use it to test if
> a table is empty, for instance. (because for
> Oracle/Sybase/SQL Server, count(*) is cheap).

    To test if a table is empty, use a SELECT EXISTS or whatever SELECT with
a LIMIT 1...

pgsql-performance by date:

Previous
From: Stef
Date:
Subject: Re: Performance of count(*) on large tables vs SQL Server
Next
From: Alex Turner
Date:
Subject: Re: High end server and storage for a PostgreSQL OLTP system