Faster 'select count(*) from table' ?
От
Matt Mello
Тема
Faster 'select count(*) from table' ?
Дата
Msg-id
3E5BF1BD.9070301@spaceship.com
Ответ на
Список
Дерево обсуждения
Really bad insert performance: what did I do wrong? Kevin White <kwhite@digital-ics.com>
Re: Really bad insert performance: what did I do wrong? Tom Lane <tgl@sss.pgh.pa.us>
Re: Really bad insert performance: what did I do wrong? Kevin White <kwhite@digital-ics.com>
Faster 'select count(*) from table' ? Matt Mello <alien@spaceship.com>
Re: Faster 'select count(*) from table' ? "scott.marlowe" <scott.marlowe@ihs.com>
Re: Really bad insert performance: what did I do wrong? Andrew Sullivan <andrew@libertyrms.info>
Re: Really bad insert performance: what did I do wrong? Kevin White <kwhite@digital-ics.com>
Re: Really bad insert performance: what did I do wrong? Andrew Sullivan <andrew@libertyrms.info>
Re: Really bad insert performance: what did I do wrong? Tom Lane <tgl@sss.pgh.pa.us>
Re: Really bad insert performance: what did I do wrong? "scott.marlowe" <scott.marlowe@ihs.com>
Re: Really bad insert performance: what did I do wrong? Tom Lane <tgl@sss.pgh.pa.us>
Re: Really bad insert performance: what did I do wrong? Kevin White <kwhite@digital-ics.com>
Re: Really bad insert performance: what did I do wrong? "Shridhar Daithankar<shridhar_daithankar@persistent.co.in>" <shridhar_daithankar@persistent.co.in>
Does anyone know if there is a fast way to find out how many records are in a table? "Select count(*) from table" is very slow. I would think that PG would keep up with the number of undeleted rows on a realtime basis. Is that the case? If so, how would I query it? Hope this is the correct list for this question. Thanks! -- Matt Mello
В списке pgsql-performance по дате отправления
