| From: | Holger Jakobs <holger(at)jakobs(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Query cost |
| Date: | 2020-11-05 14:13:04 |
| Message-ID: | 6867479E-8600-4A2C-8A2B-9336AE36E593@jakobs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
This is difficult to tell because many factors a role. It's best to try it on your machine. Generate data and query them.
Don't forget to optimize your settings. They are far from optimal after installation.
Am 5. November 2020 14:33:54 MEZ schrieb Yambu <hyambu(at)gmail(dot)com>:
>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
--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Walters Che Ndoh | 2020-11-05 18:03:13 | Change from BIGINT to INT in prod. |
| Previous Message | Yambu | 2020-11-05 13:33:54 | Query cost |