> 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
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
In response to
pgsql-hackers-win32 by date
|Next:||From: Barry Lind||Date: 2004-03-17 15:59:22|
|Subject: Re: shutdown problems on win32|
|Previous:||From: Bruce Momjian||Date: 2004-03-17 13:20:39|
|Subject: Re: [HACKERS] socket calls in signal handler (WAS:|