Mohan wrote:
> Hi,
> I am re-writting an application for my company, which uses the volume of
> 1 million to 2 million records per day. Currently the application is
> exisiting in ctrack and partially in Visual Foxpro.
> I suggested my company about using PostgreSQL and went to a win to win
> situation. After research with postgresql 7.2.1 on windows with ultra,
> (i suffered a lot to compile 7.4.1 for windows) i switched to linux 8.2
> with postgresql 7.4.1. The performance is comparable with MySql and
> MsAccess when i run Postgresql on Linux. Its lagging only in the select
> query.
> Well anyways, my problems is to get to know about the storage
> architecture of the database for where he is pinching on me.
Hard to know how to help you. There is a performance mailing list. I
would ask there.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073