Re: [ADMIN] select count is too slow

@postgresql.org Subject: [ADMIN] select count is too slow Date: Thu, 20 Aug 2009 15:06:45 +0530 Dear all, I face this problem from last few days. here is test2 table with only one column id erp_test= \d test2 Table public.test2 Column | Type | Modifiers +-+--- id

Re: [ADMIN] select count is too slow

On Thu, Aug 20, 2009 at 3:36 AM, Kumar Anandkumar.an...@merceworld.com wrote: Dear all, I face this problem from last few days. here is test2 table  with only one column id erp_test= \d test2    Table public.test2 Column |  Type   | Modifiers +-+--- id     |

[ADMIN] select count is too slow

Dear all, I face this problem from last few days. here is test2 table with only one column id erp_test= \d test2 Table public.test2 Column | Type | Modifiers +-+--- id | integer | I insert 10,000,000 entries in this table. erp_test= INSERT INTO test2 VALUES

Re: [ADMIN] select count is too slow

Did you vacuum your table after the delete? On Thu, Aug 20, 2009 at 2:36 AM, Kumar Anand kumar.an...@merceworld.comwrote: Dear all, I face this problem from last few days. here is test2 table with only one column id erp_test= \d test2 Table public.test2 Column | Type | Modifiers

Re: [ADMIN] select count is too slow

VACUUM ANALYZE, rather On Thu, Aug 20, 2009 at 2:21 PM, bricklen brick...@gmail.com wrote: Did you vacuum your table after the delete? On Thu, Aug 20, 2009 at 2:36 AM, Kumar Anand kumar.an...@merceworld.comwrote: Dear all, I face this problem from last few days. here is test2 table