Search Postgresql Archives

Re: Beginner's Questions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux