Query cost

From: Yambu <hyambu(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Query cost
Date: 2020-11-05 13:33:54
Message-ID: CALhHtcBqYpsckv88JXZVdGUSkzAbxUCr+wxytp_qoG07Y7_7bg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

What cost is involved in querying a table that has 100k rows versus one
that has 20mil rows, and what are the specific advantages in terms of
memory,speed etc when a table is smaller?

regards

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2020-11-05 14:13:04 Re: Query cost
Previous Message Laurenz Albe 2020-11-04 15:35:08 Re: Logical replication alternative