Query cost - Mailing list pgsql-admin

From Yambu
Subject Query cost
Date
Msg-id CALhHtcBqYpsckv88JXZVdGUSkzAbxUCr+wxytp_qoG07Y7_7bg@mail.gmail.com
Whole thread Raw
Responses Re: Query cost  (Holger Jakobs <holger@jakobs.com>)
List 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

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Logical replication alternative
Next
From: Holger Jakobs
Date:
Subject: Re: Query cost