Re: Beginner's Questions - Mailing list pgsql-general

I'm running my database on a Pentium 2 with 450MHz CPU.
It runs dbmail and spamassassin's Bayes and has overhead available.
You'll find it works well enough for your database size.

As for being it overkill.  I think you've answered your own questions:
I don't have to write as much code -- less bugs, less development time.
It's know to be reliable for what I'm doing -- less bugs, less
testing time.

So, if it *can* run on your machine why wouldn't you run it on your
machine?

I don't limit this thinking to just postgresql...  You've identified
postgresql as something that can provide you with a simpler solution
to the architecture, you have sufficient hardware for it.  And if for
some reason your estimates are wrong about the size of the project
you can easily grow for sometime with minor modifications, if any, to
your application.

On Mar 9, 2007, at 7:03 AM, Don Lavelle wrote:

> Hey, All,
>
> I'm working on a project (for a friend and for self-education) and
> want to learn a little more about what sorts of applications
> PostgreSQL is used for.  I'm currently looking at a single-computer
> desktop application that may be scaled to a client-server model
> with multiple desktop clients and a centralized server.
>
> My database is quite small (only 13 lucky tables, though that may
> expand a little) and will not hold a great amount of data.  (There
> will be at most records in the thousands for the single-user or
> tens of thousands for the multi-user.)  I will either use Java or C+
> + for the project.  I would run PostgreSQL as a child process.
>
> Is PostgreSQL overkill for such a project?  My other choices are to
> go with a flat-file format or to use an embedded SQL server.  The
> reason to go with PostgreSQL are that I don't have to write as much
> code, it's known to be reliable for what I'm doing, and it's known
> to be reliable for what I might be doing.  The reason to not go
> with PostgreSQL is that it might be too much for a modest personal
> computer; I don't know that the computers running this will even
> have XP.  (I'm not a MS Windows user, myself, unless I have to be.
> My development boxes are a 1.1 GHz Athlon with 512 RAM with XP and
> a dual-processor G4 with MacOS 10.4.)
>
> Are there ballpark requirements for what such a database will need
> to run?
>
> Thanks!
>
>      Don
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org/
>