On Thu, Jan 20, 2005 at 10:08:47AM -0500, Stephen Frost wrote:
> * Christopher Kings-Lynne ([EMAIL PROTECTED]) wrote:
> > PostgreSQL has replication, but not partitioning (which is what you want).
>
> It doesn't have multi-server partitioning.. It's got partitioning
> within a single server (does
On Thu, Jan 20, 2005 at 10:40:02PM -0200, Bruno Almeida do Lago wrote:
>
> I was thinking the same! I'd like to know how other databases such as Oracle
> do it.
>
In a nutshell, in a clustered environment (which iirc in oracle means
shared disks), they use a set of files for locking and consiste
On Thu, Jan 20, 2005 at 07:12:42AM -0800, Joshua D. Drake wrote:
>
> >>then I was thinking. Couldn't he use
> >>multiple databases
> >>over multiple servers with dblink?
> >>
> >>It is not exactly how I would want to do it, but it would provide what
> >>he needs I think???
> >>
> >>
> >
> >Yes
> On January 20, 2005 06:49 am, Joshua D. Drake wrote:
> > Stephen Frost wrote:
> > >* Herv? Piedvache ([EMAIL PROTECTED]) wrote:
> > >>Le Jeudi 20 Janvier 2005 15:30, Stephen Frost a écrit :
> > >>>* Herv? Piedvache ([EMAIL PROTECTED]) wrote:
> > Is there any solution with PostgreSQL matching
Oracle's RAC is good, but I think it's best to view it as a step in the high
availability direction rather than a performance enhancer. While it can help
your application scale up, that depends on the usage pattern. Also it's not
100% transparent to the application for example you can't depend o
1) pgpool does the load balance and sends query to Slony-I's slave and
master if the query is SELECT.
2) pgpool sends query only to the master if the query is other than
SELECT.
Remaining problem is that Slony-I is not a sync replication
solution. Thus you need to prepare that the load balance
Tatsuo,
> Yes. However it would be pretty easy to modify pgpool so that it could
> cope with Slony-I. I.e.
>
> 1) pgpool does the load balance and sends query to Slony-I's slave and
>master if the query is SELECT.
>
> 2) pgpool sends query only to the master if the query is other than
>SEL
Hi,
I have the go ahead
of a customer to do some testing on Postgresql in a couple of weeks as a
replacement for Oracle.
The reason for the
test is that the number of users of the warehouse is going to increase and this
will have a serious impact on licencing costs. (I bet that sounds
fa
On Mon, 17 Jan 2005 18:36:35 -0500
Dave Cramer <[EMAIL PROTECTED]> wrote:
> The *only* way to avoid this is to go to a 64 bit processor (opteron)
> and then
> for greater performance use a linux distribution compiled for a 64bit
> processor.
Or NetBSD (http://www.NetBSD.org/) which has been 64 b
I have no experience with pgCluster, but I found:
PGCluster is a multi-master and synchronous replication system that
supports load balancing of PostgreSQL.
http://www.software-facilities.com/databases-software/pgcluster.php
May be some have some expierience with this tool?
- Original Message -
This idea won't work with postgresql only one instance can operate on a
datastore at a time.
Dave
Bruno Almeida do Lago wrote:
I was thinking the same! I'd like to know how other databases such as Oracle
do it.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
"[EMAIL PROTECTED] (Frank Wiles)" wrote in pgsql.performance:
> On Thu, 6 Jan 2005 19:01:38 + (UTC)
> Randolf Richardson <[EMAIL PROTECTED]> wrote:
>
>> I'm looking for recent performance statistics on PostgreSQL vs.
>> Oracle
>> vs. Microsoft SQL Server. Recently someone
"Ron Mayer <[EMAIL PROTECTED]>" wrote in pgsql.performance:
> Randolf Richardson wrote:
>
>>> While this doesn't exactly answer your question, I use this little
>>> tidbit of information when "selling" people on PostgreSQL.
>>> PostgreSQL was chosen over Oracle as the database to handle all of
"[EMAIL PROTECTED]" wrote in pgsql.performance:
> Quoting Randolf Richardson <[EMAIL PROTECTED]>:
>
>> I'm looking for recent performance statistics on PostgreSQL
>> vs. Oracle
>>
>> vs. Microsoft SQL Server. Recently someone has been trying to convince
>> my
>
> I don't kn
No support for partitioned tables? Perhaps in name ... but I use a time-based
"partition" tables that inherit from a base table; new partitions are "placed"
(moved) round-robin on a set of drives. Somewhat manual, but if you really need
a solution now, it works.
Quoting Greg Stark <[EMAIL PROTECTE
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Bernd Heller <[EMAIL PROTECTED]> wrote:
>> there is no entry in pg_stats for that column at all!! I can only
>> suspect that this has to do with the column being all null.
> Someone else reported this recently and I think it is going to be fixed.
Y
Randolf Richardson <[EMAIL PROTECTED]> writes:
> "Ron Mayer <[EMAIL PROTECTED]>" wrote in pgsql.performance:
>> Randolf Richardson wrote:
>>> While this doesn't exactly answer your question, I use this little
>>> tidbit of information when "selling" people on PostgreSQL.
>>> PostgreSQL was chosen
101 - 117 of 117 matches
Mail list logo
