| Lists: | pgsql-hackers-win32 |
|---|
| From: | Mohan <mohanyes(at)shafika(dot)vetri(dot)com> |
|---|---|
| To: | pgsql-hackers-win32(at)postgresql(dot)org |
| Subject: | Storage Architecture! |
| Date: | 2004-03-17 07:25:54 |
| Message-ID: | 4057FD82.25F455E4@shafika.vetri.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers-win32 |
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.
Regards,
Mohan
| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Mohan <mohanyes(at)shafika(dot)vetri(dot)com> |
| Cc: | pgsql-hackers-win32(at)postgresql(dot)org |
| Subject: | Re: Storage Architecture! |
| Date: | 2004-03-17 15:41:48 |
| Message-ID: | 200403171541.i2HFfmq19231@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers-win32 |
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(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