| From: | Efraín Déctor <efraindector(at)motumweb(dot)com> |
|---|---|
| To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Sequential Scans |
| Date: | 2012-04-02 18:40:21 |
| Message-ID: | B25FC9C4A56C402081D0A47BDD689C99@CMOTUM25PC |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thank you.
-----Mensaje original-----
From: Scott Marlowe
Sent: Monday, April 02, 2012 1:33 PM
To: Efraín Déctor
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Sequential Scans
On Mon, Apr 2, 2012 at 12:30 PM, Efraín Déctor
<efraindector(at)motumweb(dot)com> wrote:
> Hello. What is the difference between Sequential Scans and Sequential
> Tuples Read?.
A sequential scan is what happens when the table is read sequentially.
One sequential scan can result in MANY tuples being read
sequentially. I.e. a table with 1M rows being sequentially scanned
from end to end will result in 1M sequential tuples being read.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bartosz Dmytrak | 2012-04-02 18:40:28 | Re: How to check the role has been granted to which role. Help me to double check . Thanks. |
| Previous Message | Scott Marlowe | 2012-04-02 18:33:08 | Re: Sequential Scans |