From: Chris Travers <chris@travelamericas.com>
To: tobbe <tobbe@tripnet.se>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance for relative large DB
Date: Fri, 26 Aug 2005 23:30:08 -0700
Message-ID: <43100870.8070406@travelamericas.com> (raw)
In-Reply-To: <1124864702.822522.64410@g49g2000cwa.googlegroups.com>
References: <1124799264.282119.167760@g47g2000cwa.googlegroups.com>
<60wtmcptzg.fsf@dba2.int.libertyrms.com>
<1124864702.822522.64410@g49g2000cwa.googlegroups.com>
tobbe wrote:
>Hi Chris.
>
>Thanks for the answer.
>Sorry that i was a bit unclear.
>
>1) We update around 20.000 posts per night.
>
>2) What i meant was that we suspect that the DBMS called PervasiveSQL
>that we are using today is much to small. That's why we're looking for
>alternatives.
>
>Today we base our solution much on using querry-specific tables created
>at night, so instead of doing querrys direct on the "post" table (with
>4-6M rows) at daytime, we have the data pre-aligned in several much
>smaller tables. This is just to make the current DBMS coop with our
>amount of data.
>
>What I am particulary interested in is if we can expect to run all our
>select querrys directly from the "post" table with PostgreSQL.
>
>
20k transactions per day? Doesn't seem too bad. That amounts to how
many transactions per second during peak times? Personally I don't
think it will be a problem, but you might want to clarify what sort of
load you are expecting during its peak time.
>3) How well does postgres work with load balancing environments. Is it
>built-in?
>
>
There is no load balancing "built in." You would need to use Slony-I
and possibly Pg-Pool for that. I don't know about Pg-Pool, but Slony-I
was written in large part by member(s?) of the core development team so
even if it is not "built in" it is not as if it is a team of outsiders
who wrote it.
If you need something proprietary, there are similar solutions with
replication built in which are based on PostgreSQL and licensed under
proprietary licenses.
Best Wishes,
Chris Travers
Metatron Technology Consulting
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: chris@travelamericas.com, tobbe@tripnet.se
Subject: Re: Performance for relative large DB
In-Reply-To: <43100870.8070406@travelamericas.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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