pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCapacity planning.
3+ messages / 3 participants
[nested] [flat]
* Capacity planning.
@ 2010-03-25 14:02 David Harel <hareldvd@gmail.com>
2010-03-31 14:47 ` Re: Capacity planning. Bruce Momjian <bruce@momjian.us>
2010-04-01 13:12 ` Re: Capacity planning. Brad Nicholson <bnichols@ca.afilias.info>
0 siblings, 2 replies; 3+ messages in thread
From: David Harel @ 2010-03-25 14:02 UTC (permalink / raw)
To: pgsql-sql
Hi,
Any way to get transaction count from the postgres daemon or any log?
Also where can I find docs that can help me make a capacity plan for max
100,000 clients making around 200 transactions a day each.
--
Regards.
David Harel,
==================================
Home office +972 77 7657645
Cellular: +972 54 4534502
Snail Mail: Amuka
D.N Merom Hagalil
13802
Israel
Email: hareldvd@ergolight-sw.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Capacity planning.
2010-03-25 14:02 Capacity planning. David Harel <hareldvd@gmail.com>
@ 2010-03-31 14:47 ` Bruce Momjian <bruce@momjian.us>
1 sibling, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 2010-03-31 14:47 UTC (permalink / raw)
To: David Harel <hareldvd@gmail.com>; +Cc: pgsql-sql
David Harel wrote:
> Hi,
>
>
> Any way to get transaction count from the postgres daemon or any log?
See the system view pg_stat_database.
> Also where can I find docs that can help me make a capacity plan for max
> 100,000 clients making around 200 transactions a day each.
No idea. You should be using connection pooling for that setup.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Capacity planning.
2010-03-25 14:02 Capacity planning. David Harel <hareldvd@gmail.com>
@ 2010-04-01 13:12 ` Brad Nicholson <bnichols@ca.afilias.info>
1 sibling, 0 replies; 3+ messages in thread
From: Brad Nicholson @ 2010-04-01 13:12 UTC (permalink / raw)
To: David Harel <hareldvd@gmail.com>; +Cc: pgsql-sql
On Thu, 2010-03-25 at 16:02 +0200, David Harel wrote:
> Also where can I find docs that can help me make a capacity plan for
> max 100,000 clients making around 200 transactions a day each.
You will need a whole lot more information than that in order to do
capacity planning.
Here are a few questions to get you started
-What is the expected percentage of read vs write transactions.
-Are they small OLTP style writes, or larger ones?
-Do you expect these transactions to be equally distributed over the
day, or do you expect bursts?
-Are you going to be dealing with highly concurrent access, or is it
distributed?
-what is the expected cache hit ratio?
-what is the expected data size? What is the expected growth rate?
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-04-01 13:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-25 14:02 Capacity planning. David Harel <hareldvd@gmail.com>
2010-03-31 14:47 ` Bruce Momjian <bruce@momjian.us>
2010-04-01 13:12 ` Brad Nicholson <bnichols@ca.afilias.info>
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