pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedneed suggestion for server sizing
3+ messages / 2 participants
[nested] [flat]
* need suggestion for server sizing
@ 2005-06-10 21:12 Havasvölgyi Ottó <h.otto@freemail.hu>
0 siblings, 1 reply; 3+ messages in thread
From: Havasvölgyi Ottó @ 2005-06-10 21:12 UTC (permalink / raw)
To: pgsql-novice@postgresql.org
Hi all,
I need your help to determine the configuration of a server machine, and the
PG DBMS.
There will be not more than 25 concurrent users. They will use a business
software that accesses tha database. The database will be not that large, it
seems that none of the tables's recordcount will exceed 1-2 million, but
there will be a lot of small (<5000 record) tables. The numbert of tables
will be about 300. What server would you install to such a site to make the
database respond quickly in any case?
I would like to leave fsync on.
Perhaps you need some additional information. In this case just indicate it.
Thanks in advance,
Otto
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: need suggestion for server sizing
@ 2005-06-13 13:25 János <janos.lobb@yale.edu>
parent: Havasvölgyi Ottó <h.otto@freemail.hu>
0 siblings, 1 reply; 3+ messages in thread
From: János @ 2005-06-13 13:25 UTC (permalink / raw)
To: Havasvölgyi Ottó <h.otto@freemail.hu>; +Cc: pgsql-novice@postgresql.org
Any XServe from Apple will do it.
János
On Jun 10, 2005, at 5:12 PM, Havasvölgyi Ottó wrote:
> Hi all,
>
> I need your help to determine the configuration of a server
> machine, and the
> PG DBMS.
> There will be not more than 25 concurrent users. They will use a
> business
> software that accesses tha database. The database will be not that
> large, it
> seems that none of the tables's recordcount will exceed 1-2
> million, but
> there will be a lot of small (<5000 record) tables. The numbert of
> tables
> will be about 300. What server would you install to such a site to
> make the
> database respond quickly in any case?
> I would like to leave fsync on.
> Perhaps you need some additional information. In this case just
> indicate it.
>
> Thanks in advance,
> Otto
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that
> your
> message can get through to the mailing list cleanly
>
------------------------------------------
"There was a mighty king in the land of the Huns whose goodness and
wisdom had no equal."
Nibelungen-Lied
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: need suggestion for server sizing
@ 2005-06-14 16:31 Havasvölgyi Ottó <h.otto@freemail.hu>
parent: János <janos.lobb@yale.edu>
0 siblings, 0 replies; 3+ messages in thread
From: Havasvölgyi Ottó @ 2005-06-14 16:31 UTC (permalink / raw)
To: pgsql-novice@postgresql.org
Janos,
Thank you. Sorry, but I wanted to install Linux on the server, I haven't
mentioned it. I am not that familiar in the server-world. So, what
configuration is enough on X86 (32 bit) architecture for PostgreSQL with the
conditions listed in my previous post?
Thanks,
Otto
----- Original Message -----
From: "János" <janos.lobb@yale.edu>
To: "Havasvölgyi Ottó" <h.otto@freemail.hu>
Cc: <pgsql-novice@postgresql.org>
Sent: Monday, June 13, 2005 3:25 PM
Subject: Re: [NOVICE] need suggestion for server sizing
Any XServe from Apple will do it.
János
On Jun 10, 2005, at 5:12 PM, Havasvölgyi Ottó wrote:
> Hi all,
>
> I need your help to determine the configuration of a server
> machine, and the
> PG DBMS.
> There will be not more than 25 concurrent users. They will use a
> business
> software that accesses tha database. The database will be not that
> large, it
> seems that none of the tables's recordcount will exceed 1-2
> million, but
> there will be a lot of small (<5000 record) tables. The numbert of
> tables
> will be about 300. What server would you install to such a site to
> make the
> database respond quickly in any case?
> I would like to leave fsync on.
> Perhaps you need some additional information. In this case just
> indicate it.
>
> Thanks in advance,
> Otto
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that
> your
> message can get through to the mailing list cleanly
>
------------------------------------------
"There was a mighty king in the land of the Huns whose goodness and
wisdom had no equal."
Nibelungen-Lied
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-06-14 16:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-10 21:12 need suggestion for server sizing Havasvölgyi Ottó <h.otto@freemail.hu>
2005-06-13 13:25 ` János <janos.lobb@yale.edu>
2005-06-14 16:31 ` Havasvölgyi Ottó <h.otto@freemail.hu>
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