pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres on VPS - how much is enough?
9+ messages / 6 participants
[nested] [flat]
* Postgres on VPS - how much is enough?
@ 2006-03-06 13:28 Nagita Karunaratne <nagita.k@gmail.com>
0 siblings, 2 replies; 9+ messages in thread
From: Nagita Karunaratne @ 2006-03-06 13:28 UTC (permalink / raw)
To: pgsql-performance
How big a VPS would I need to run a Postgres DB.
I need a Postgres database with about 15 tables that will run on a
single virtual private server.
The 15 tables will be spread over three tablespaces (5 tables per
tablespace) and be accessed by three different applications running on
different machines.
One application will add about 500 orders per day
Another will access this data to create and send about 500 emails per day
A third will access this data to create an after-sales survey for at
most 500 times per day.
What type of VPS would I need to run a database with this type pf load?
Is 128 MB ram enough?
What percentage of a 2.8 GHz CPU would be required?
It's been a long time since I used Postgres.
Thanks for any help,
Nagita
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres on VPS - how much is enough?
@ 2006-03-06 14:56 Matthew Nuzum <mattnuzum@gmail.com>
parent: Nagita Karunaratne <nagita.k@gmail.com>
1 sibling, 2 replies; 9+ messages in thread
From: Matthew Nuzum @ 2006-03-06 14:56 UTC (permalink / raw)
To: Nagita Karunaratne <nagita.k@gmail.com>; +Cc: pgsql-performance
On 3/6/06, Nagita Karunaratne <nagita.k@gmail.com> wrote:
> How big a VPS would I need to run a Postgres DB.
>
> One application will add about 500 orders per day
> Another will access this data to create and send about 500 emails per day
> A third will access this data to create an after-sales survey for at
> most 500 times per day.
>
> What type of VPS would I need to run a database with this type pf load?
> Is 128 MB ram enough?
> What percentage of a 2.8 GHz CPU would be required?
My problem with running PG inside of a VPS was that the VPS used a
virtual filesystem... basically, a single file that had been formatted
and loop mounted so that it looked like a regular hard drive.
Unfortunately, it was very slow. The difference between my application
and yours is that mine well more than filled the 1GB of RAM that I had
allocated. If your data will fit comfortably into RAM then you may be
fine.
If you really want to know how it will work, try running it yourself.
Two projects that make this really easy and free is the colinux
project[1] which allows you to run a linux VPS in Windows and the
linux-vserver project[2] which is free software that works on pretty
much any linux OS.
Try it out, tinker with the values and that way you won't have to
guess when making your purchase decission.
[1] http://www.colinux.org/ Coperative Linux
[2] http://linux-vserver.org/ Linux-vserver project
--
Matthew Nuzum
www.bearfruit.org
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres on VPS - how much is enough?
@ 2006-03-06 15:20 Kevin <kev@drule.org>
parent: Nagita Karunaratne <nagita.k@gmail.com>
1 sibling, 0 replies; 9+ messages in thread
From: Kevin @ 2006-03-06 15:20 UTC (permalink / raw)
To: pgsql-performance
Nagita Karunaratne wrote:
> How big a VPS would I need to run a Postgres DB.
>
> I need a Postgres database with about 15 tables that will run on a
> single virtual private server.
>
> The 15 tables will be spread over three tablespaces (5 tables per
> tablespace) and be accessed by three different applications running on
> different machines.
>
> One application will add about 500 orders per day
> Another will access this data to create and send about 500 emails per day
> A third will access this data to create an after-sales survey for at
> most 500 times per day.
>
> What type of VPS would I need to run a database with this type pf load?
> Is 128 MB ram enough?
> What percentage of a 2.8 GHz CPU would be required?
>
If the database is going to be larger then the allocated memory, disk
I/O is very important. Not all VPS technologies are equal in this
regard. (see link below) Like someone else suggested, the best way to
know what VPS specs you need is to do your own tests/benchamarks.
http://www.cl.cam.ac.uk/Research/SRG/netos/xen/performance.html
-Kevin
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres on VPS - how much is enough?
@ 2006-03-06 16:52 Nagita Karunaratne <nagita.k@gmail.com>
parent: Matthew Nuzum <mattnuzum@gmail.com>
1 sibling, 0 replies; 9+ messages in thread
From: Nagita Karunaratne @ 2006-03-06 16:52 UTC (permalink / raw)
To: pgsql-performance
Thanks for the replies,
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres on VPS - how much is enough?
@ 2006-03-06 17:14 Marc G. Fournier <scrappy@postgresql.org>
parent: Matthew Nuzum <mattnuzum@gmail.com>
1 sibling, 2 replies; 9+ messages in thread
From: Marc G. Fournier @ 2006-03-06 17:14 UTC (permalink / raw)
To: newz@bearfruit.org; +Cc: Nagita Karunaratne <nagita.k@gmail.com>; pgsql-performance
On Mon, 6 Mar 2006, Matthew Nuzum wrote:
> On 3/6/06, Nagita Karunaratne <nagita.k@gmail.com> wrote:
>> How big a VPS would I need to run a Postgres DB.
>>
>
>> One application will add about 500 orders per day
>> Another will access this data to create and send about 500 emails per day
>> A third will access this data to create an after-sales survey for at
>> most 500 times per day.
>>
>> What type of VPS would I need to run a database with this type pf load?
>> Is 128 MB ram enough?
>> What percentage of a 2.8 GHz CPU would be required?
>
> My problem with running PG inside of a VPS was that the VPS used a
> virtual filesystem... basically, a single file that had been formatted
> and loop mounted so that it looked like a regular hard drive.
> Unfortunately, it was very slow. The difference between my application
> and yours is that mine well more than filled the 1GB of RAM that I had
> allocated. If your data will fit comfortably into RAM then you may be
> fine.
We host VPSs here (http://www.hub.org) and don't use the 'single file,
virtual file system' to put them into ... it must depend on where you
host?
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres on VPS - how much is enough?
@ 2006-03-06 19:45 Matthew Nuzum <mattnuzum@gmail.com>
parent: Marc G. Fournier <scrappy@postgresql.org>
1 sibling, 0 replies; 9+ messages in thread
From: Matthew Nuzum @ 2006-03-06 19:45 UTC (permalink / raw)
To: Marc G. Fournier <scrappy@postgresql.org>; Nagita Karunaratne <nagita.k@gmail.com>; +Cc: pgsql-performance
On 3/6/06, Marc G. Fournier <scrappy@postgresql.org> wrote:
> On Mon, 6 Mar 2006, Matthew Nuzum wrote:
> > My problem with running PG inside of a VPS was that the VPS used a
> > virtual filesystem... basically, a single file that had been formatted
> > and loop mounted so that it looked like a regular hard drive.
> > Unfortunately, it was very slow. The difference between my application
> > and yours is that mine well more than filled the 1GB of RAM that I had
> > allocated. If your data will fit comfortably into RAM then you may be
> > fine.
>
> We host VPSs here (http://www.hub.org) and don't use the 'single file,
> virtual file system' to put them into ... it must depend on where you
> host?
That's true... I hope I didn't imply that I am anti-vps, I run my own
servers and one of them is dedicated to doing VPS for different
applications. I think they're wonderful.
On 3/6/06, Nagita Karunaratne <nagita.k@gmail.com> wrote:
> From personal experience, would you run Postgres on a linux machine
> (NOT a vps) with 512MB of ram?
>
> Assumining I can keep all my data in memory.
Nagita,
It all depends on performance... I have one postgres database that
runs on a Pentium 350MHz with 128MB of RAM. It does 1 insert per
minute 24 hours per day. Because the load is so low, I can get away
with minimal hardware.
If your application has a lot of inserts/updates then disk speed is
important and can vary greatly from one VPS to another.
If your application is not time-critical than this may be a moot point anyway.
--
Matthew Nuzum
www.bearfruit.org
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres on VPS - how much is enough?
@ 2006-03-07 18:45 Jim C. Nasby <jnasby@pervasive.com>
parent: Marc G. Fournier <scrappy@postgresql.org>
1 sibling, 1 reply; 9+ messages in thread
From: Jim C. Nasby @ 2006-03-07 18:45 UTC (permalink / raw)
To: Marc G. Fournier <scrappy@postgresql.org>; +Cc: newz@bearfruit.org, Nagita Karunaratne <nagita.k@gmail.com>; pgsql-performance
On Mon, Mar 06, 2006 at 01:14:45PM -0400, Marc G. Fournier wrote:
> We host VPSs here (http://www.hub.org) and don't use the 'single file,
> virtual file system' to put them into ... it must depend on where you
> host?
Yeah, but aren't you also using FreeBSD jails? AFAIK linux doesn't have
an equivalent to jail; all their VPS stuff actually brings up a
full-blown copy of linux, kernel and all.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres on VPS - how much is enough?
@ 2006-03-07 20:08 Dave Page <dpage@vale-housing.co.uk>
parent: Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 1 reply; 9+ messages in thread
From: Dave Page @ 2006-03-07 20:08 UTC (permalink / raw)
To: Jim C. Nasby <jnasby@pervasive.com>; Marc G. Fournier <scrappy@postgresql.org>; +Cc: newz@bearfruit.org; Nagita Karunaratne <nagita.k@gmail.com>; pgsql-performance
On 7/3/06 18:45, "Jim C. Nasby" <jnasby@pervasive.com> wrote:
> On Mon, Mar 06, 2006 at 01:14:45PM -0400, Marc G. Fournier wrote:
>> We host VPSs here (http://www.hub.org) and don't use the 'single file,
>> virtual file system' to put them into ... it must depend on where you
>> host?
>
> Yeah, but aren't you also using FreeBSD jails? AFAIK linux doesn't have
> an equivalent to jail; all their VPS stuff actually brings up a
> full-blown copy of linux, kernel and all.
No, linux vserver is equivalent to a jail - and they work superbly imho.
developer.pgadmin.org is just one such VM that I run.
http://www.linux-vserver.org/
Regards, Dave.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Postgres on VPS - how much is enough?
@ 2006-03-08 02:16 Matthew Nuzum <mattnuzum@gmail.com>
parent: Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 9+ messages in thread
From: Matthew Nuzum @ 2006-03-08 02:16 UTC (permalink / raw)
To: Dave Page <dpage@vale-housing.co.uk>; +Cc: Jim C. Nasby <jnasby@pervasive.com>; Marc G. Fournier <scrappy@postgresql.org>; Nagita Karunaratne <nagita.k@gmail.com>; pgsql-performance
On 3/7/06, Dave Page <dpage@vale-housing.co.uk> wrote:
> On 7/3/06 18:45, "Jim C. Nasby" <jnasby@pervasive.com> wrote:
> > On Mon, Mar 06, 2006 at 01:14:45PM -0400, Marc G. Fournier wrote:
> >> We host VPSs here (http://www.hub.org) and don't use the 'single file,
> >> virtual file system' to put them into ... it must depend on where you
> >> host?
> >
> > Yeah, but aren't you also using FreeBSD jails? AFAIK linux doesn't have
> > an equivalent to jail; all their VPS stuff actually brings up a
> > full-blown copy of linux, kernel and all.
>
> No, linux vserver is equivalent to a jail - and they work superbly imho.
> developer.pgadmin.org is just one such VM that I run.
>
> http://www.linux-vserver.org/
>
> Regards, Dave.
I can confirm this. I've been using linux-vserver for years. It is a
very up-to-date and active project that is extremely responsive and
helpful to users of all experience levels.
--
Matthew Nuzum
www.bearfruit.org
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2006-03-08 02:16 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-06 13:28 Postgres on VPS - how much is enough? Nagita Karunaratne <nagita.k@gmail.com>
2006-03-06 14:56 ` Matthew Nuzum <mattnuzum@gmail.com>
2006-03-06 16:52 ` Nagita Karunaratne <nagita.k@gmail.com>
2006-03-06 17:14 ` Marc G. Fournier <scrappy@postgresql.org>
2006-03-06 19:45 ` Matthew Nuzum <mattnuzum@gmail.com>
2006-03-07 18:45 ` Jim C. Nasby <jnasby@pervasive.com>
2006-03-07 20:08 ` Dave Page <dpage@vale-housing.co.uk>
2006-03-08 02:16 ` Matthew Nuzum <mattnuzum@gmail.com>
2006-03-06 15:20 ` Kevin <kev@drule.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox