Re: Large index

2020-11-05 Thread Michael Lewis
On Thu, Nov 5, 2020, 6:52 AM Yambu 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 u

Large index

2020-11-05 Thread Yambu
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?