From: Jim C. Nasby <jnasby@pervasive.com>
To: tobbe <tobbe@tripnet.se>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance for relative large DB
Date: Mon, 29 Aug 2005 16:09:17 -0500
Message-ID: <20050829210917.GC11282@pervasive.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>
On Tue, Aug 23, 2005 at 11:25:02PM -0700, tobbe wrote:
> Hi Chris.
>
> Thanks for the answer.
> Sorry that i was a bit unclear.
>
> 1) We update around 20.000 posts per night.
Doesn't seem like a lot at all.
> 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.
Just so no one gets confused, PervasiveSQL is our Btrieve-based
database; it has nothing to do with Pervasive Posgres or PosgreSQL.
Also, feel free to contact me off-list if you'd like our help with this.
> 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.
Probably, depending on what those queries are, what hardware you have
and how the table is laid out. Unless you've got a really high query
load I suspect you could handle this on some fairly mundane hardware...
> 3) How well does postgres work with load balancing environments. Is it
> built-in?
As Chris said, there is no built-in solution. PGCluster
(http://pgfoundry.org/projects/pgcluster/) is a possible solution should
you need clustering/load balancing, but as I mentioned I suspect you
should be ok without it.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com 512-569-9461
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: jnasby@pervasive.com, tobbe@tripnet.se
Subject: Re: Performance for relative large DB
In-Reply-To: <20050829210917.GC11282@pervasive.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