Alan,
here I'm implementing something similar to the Chord protocol [1] on the
application level to partition my data across 6 PostgreSQL servers with N+1
replication. Two up sides on this approch:
1 - When one server is down the load is spread between all the other ones,
instead of going only to
1.1).
I don't know why yesterday we had improved and today we had not.
Best
Daniel
On 12/12/06, Daniel van Ham Colchete <[EMAIL PROTECTED]> wrote:
I'm making some other tests here at another hardware (also Gentoo). I
found out that PostgreSQL stops for a while if I change the -t
para
10:34AM -0200, Daniel van Ham Colchete wrote:
>are you using "-mtune/-mcpu" or "-march" with GCC?
I used exactly the options you said you used.
>Witch GCC version? Are you working with a 32bits OS or 64bits?
3.3.5; 32
Mike Stone
---(end of broad
On 12/12/06, Florian Weimer <[EMAIL PROTECTED]> wrote:
* Cosimo Streppone:
> "-O0" ~ 957 tps
> "-O1 -mcpu=pentium4 -mtune=pentium4" ~ 1186 tps
> "-O2 -mcpu=pentium4 -mtune=pentium4" ~ 1229 tps
> "-O3 -mcpu=pentium4 -mtune=pentium4" ~ 1257 tps
> "-O6 -mcpu=pentium4 -mtune=pentium4" ~ 1254 tps
-m
Mike,
are you using "-mtune/-mcpu" or "-march" with GCC?
Witch GCC version? Are you working with a 32bits OS or 64bits?
Daniel
On 12/11/06, Michael Stone <[EMAIL PROTECTED]> wrote:
Can anyone else reproduce these results? I'm on similar hardware (2.5GHz
P4, 1.5G RAM) and my test results are m
Hi yall,
I made some preliminary tests.
Before the results, I would like to make some acknowledgments:
1 - I didn't show any prove to any of the things I said until now.
2 - It really is a waste of everyone's time to say one thing when I
can't prove it.
But all I said, is the knowledge I have b
On 12/11/06, Chris Browne <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] ("Daniel van Ham Colchete") writes:
> You are right Christopher.
>
> Okay. Let's solve this matter.
>
> What PostgreSQL benchmark software should I use???
pgbench is one option.
On 12/11/06, Steinar H. Gunderson <[EMAIL PROTECTED]> wrote:
On Mon, Dec 11, 2006 at 11:31:48AM -0200, Daniel van Ham Colchete wrote:
> What PostgreSQL benchmark software should I use???
Look up the list archives; search for "TPC".
> I'll test PostgreSQL 8.1 on a Fe
On 12/11/06, Steinar H. Gunderson <[EMAIL PROTECTED]> wrote:
On Mon, Dec 11, 2006 at 11:17:06AM -0200, Daniel van Ham Colchete wrote:
> I just remebered one case with MySQL. When I changed the distro from
> Conectiva 10 (rpm-based ended brazilian distro) to Gentoo, a MySQL
>
On 12/11/06, Steinar H. Gunderson <[EMAIL PROTECTED]> wrote:
On Mon, Dec 11, 2006 at 11:09:13AM -0200, Daniel van Ham Colchete wrote:
>> You know what? I don't.
> So test it yourself.
You're making the claims, you're supposed to be proving them...
> As I said,
06, Christopher Browne <[EMAIL PROTECTED]> wrote:
Oops! [EMAIL PROTECTED] ("Daniel van Ham Colchete") was seen spray-painting on
a wall:
> But, trust me on this one. It's worth it.
No, the point of performance analysis is that you *can't* trust the
people that say "trus
ne <[EMAIL PROTECTED]> wrote:
On Mon, Dec 11, 2006 at 09:05:56AM -0200, Daniel van Ham Colchete wrote:
>unfortunally I don't have any benchmarks right now.
That's fairly normal for gentoo users pushing their compile options.
Mike Stone
---(end of broa
On 12/11/06, Steinar H. Gunderson <[EMAIL PROTECTED]> wrote:
On Mon, Dec 11, 2006 at 09:05:56AM -0200, Daniel van Ham Colchete wrote:
> But, trust me on this one. It's worth it.
You know what? I don't.
So test it yourself.
> Think of this: PostgreSQL and GNU Lib
>>
>> How much memory does this machine have and what version of postgresql
>> are you using?
> It's only a test server with 512MB RAM, I only used it to see how well
> would the PostgreSQL do in a ugly case.
Given that optimal performance for postgresql can require up to 50%
of available memory
gards
Daniel
On 12/11/06, Michael Stone <[EMAIL PROTECTED]> wrote:
On Sun, Dec 10, 2006 at 11:02:44PM -0200, Daniel van Ham Colchete wrote:
>I'm using Gentoo Linux, so all my libraries (including glibc that is
>very important to PostgreSQL), and all my softwares are compiled with
Hi Dave,
On 12/11/06, Dave Cramer <[EMAIL PROTECTED]> wrote:
Hi Daniel
On 10-Dec-06, at 8:02 PM, Daniel van Ham Colchete wrote:
> Hi Gene,
>
> at my postgresql.conf, the only non-comented lines are:
> fsync = off
This can, and will result in lost data.
I know... If there
On 12/11/06, Alexander Staubo <[EMAIL PROTECTED]> wrote:
On Dec 11, 2006, at 02:47 , Daniel van Ham Colchete wrote:
> I never understood what's the matter between the ASCII/ISO-8859-1/UTF8
> charsets to a database. They're all simple C strings that doesn't have
&g
17 matches
Mail list logo
