Postgres Pro
Downloads
Home   >   mailing lists

Re: Large index - Mailing list pgsql-general

From Michael Lewis
Subject Re: Large index
Date
Msg-id CAHOFxGrSH8hAwA8qPhoR1K7xaHBBxAU1Ra8GXKVJrd1JfRrBfg@mail.gmail.com
Whole thread Raw
In response to Large index  (Yambu <hyambu@gmail.com>)
List pgsql-general
Tree view
On Thu, Nov 5, 2020, 6:52 AM Yambu <hyambu@gmail.com> wrote:
What disadvantage does a large table (30mil records) has over a small table about 20k records when it comes to querying using an indexed column?

Table with 20k rows will likely fit entirely into shared_buffers and not involve any disk i/o for its use.

pgsql-general by date:

Previous
From: luis.roberto@siscobra.com.br
Date:
Subject: Analyze and Statistics
Next
From: Yambu
Date:
Subject: greater than vs between in where clause