Re: Performance Optimisation - Identifying the correct DB
От
Ravi Krishna
Тема
Re: Performance Optimisation - Identifying the correct DB
Дата
Msg-id
emcfc2fff3-8022-4d73-95be-f020f9a13171@ravis-macbook-pro.local
Ответ на
Список
Дерево обсуждения
Performance Optimisation - Identifying the correct DB Renjith Gk <renjithgk@gmail.com>
RE: Performance Optimisation - Identifying the correct DB Eshara Mondal <emondal@edanalytics.org>
Re: Performance Optimisation - Identifying the correct DB "Ravi Krishna" <srkrishna@myself.com>
What is the optimal execution time for Reading 200k records in Postgres. We had issues for reading records in cassandra which faced time out for ~200K records.any ideal solution or recommendation towards Postgres.
Without knowing your application it is hard to predict how long will it take to read 200K records.
Does the query to fetch 200K records use index.
Does it fetch a small portion or a large portion of total rows. If later, then most likely PG will do table scan.
How wide is the table.
What is the timeout setting?
В списке pgsql-admin по дате отправления
От: Eshara Mondal
Дата:
