Could you give more detailed information? What does explain say?
On Mon, 8 Sep 2003, Vasilis Ventirozos wrote: > Hi all, i work in a telco and i have huge ammount of data, (50 million) > but i see a lack of performance at huge tables with postgres, > are 50 million rows the "limit" of postgres ? (with a good performance) > i am waiting for 2004 2 billion records so i have to do something. > Does anyone have a huge database to ask him some issues ? > > my hardware is good ,my indexes are good plz dont answer me something like use > vacuum :) > > > > The Joy of Index > > Vasilis Ventirozos > -------------------- > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match