Hi all<br /><br />I ran a simple query like the one displayed below and it takes a lot of time to execute on this
table.<br/>This table has 48 million records....and i worry about this table a lot coz i need to perform join on this
<br/>table with some other table having around 13 million records....I've tried vacuuming this table many time<br />but
dinthelp me much...is there any other trick to speed up this table....once i tried deleting and restoring a table <br
/>andit worked perfectly fine for a small table of size upto 5-6 million records<br /><br />sm=> explain analyze
select* from ma limit 10;<br /> QUERY
PLAN <br
/>-------------------------------------------------------------------------------------------------------------------------------------<br
/> Limit (cost=0.00..0.45 rows=10 width=76) (actual time=21985.292..22204.340 rows=10 loops=1) <br /> -> Seq Scan
onma (cost=0.00..2181956.92 rows=48235392 width=76) (actual time=21985.285..22204.308 rows=10 loops=1)<br /> Total
runtime:22204.476 ms<br />(3 rows)<br /><br clear="all" /><br />-- <br />Thanks,<br />Sumeet