Re: configure options - Mailing list pgsql-general

From Siddharth Shah
Subject Re: configure options
Date
Msg-id 4933E585.2060802@elitecore.com
Whole thread Raw
In response to Re: configure options  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Siddharth Shah <siddharth.shah@elitecore.com> writes:
>
>>     In My Application I have only 256MB storage device and I have to
>> manage many other application in same storage
>>
>
> Quite honestly, you're going to need some other database besides
> Postgres if you need a disk footprint that's only a fraction of 256MB.
> It's just not designed for that.  Maybe sqllite or bdb would be closer
> to what you need.
>
>             regards, tom lane
>
>
>

Hi   Tom,

    I have explored SQLite & DBD but they have limitations on concurrency
My Requirement falls In between lighter & enterprise databases
So finally concluded postgres, My database size on pg is almost 12 MB

Does any cons which I am going to face with pg with slower size then
please mention.
Transaction frequencies  : more select queries than insert / update
Almost 20 queries/sec is executing with current database.

- Siddharth




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: configure options
Next
From: Tom Lane
Date:
Subject: Re: Indexes on NULL's and order by ... limit N queries