Re: table full scan or index full scan?

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: 旭斌 裴 <peixubin(at)yahoo(dot)com(dot)cn>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: table full scan or index full scan?
Date: 2009-10-18 05:00:22
Message-ID: 4ADAA0E6.5040500@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

旭斌 裴 escreveu:
> The postgresql database uses the table full scan.but in oracle, the
> similar SQL uses the index full scanning,speed quickly many than
> postgresql.
>
This was discussed many times on the pgsql mailing lists. Search the archives.
Also, take a look at [1].

[1] http://wiki.postgresql.org/wiki/Slow_Counting

--
Euler Taveira de Oliveira
http://www.timbira.com/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2009-10-18 05:05:40 Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2?
Previous Message Karl Denninger 2009-10-18 04:13:47 Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2?