Skip site navigation (1) Skip section navigation (2)

Re: Storage Architecture!

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 (view raw or flat)
Thread:
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

In response to

pgsql-hackers-win32 by date

Next:From: Barry LindDate: 2004-03-17 15:59:22
Subject: Re: shutdown problems on win32
Previous:From: Bruce MomjianDate: 2004-03-17 13:20:39
Subject: Re: [HACKERS] socket calls in signal handler (WAS:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group