Postgres Pro
Downloads
Home   >   mailing lists

Thread: Large index

Large index

From
Yambu
Date:
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?

Re: Large index

From
Michael Lewis
Date:
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.