From: | Sergio Bruder <bruder(at)conectiva(dot)com(dot)br> |
---|---|
To: | Hannu Krosing <hannu(at)tm(dot)ee> |
Cc: | pgsql-hackers(at)postgresql(dot)org, andreas(at)conectiva(dot)com(dot)br |
Subject: | Re: Any tips for this particular performance problem? |
Date: | 2001-07-10 14:01:59 |
Message-ID: | 20010710110159.A1106@conectiva.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Jul 10, 2001 at 04:04:43PM +0200, Hannu Krosing wrote:
> Sergio Bruder wrote:
> >
> > If you have time, take a quick look at
> >
> > http://acidlab.sourceforge.net/perf/acid_perf.html
> >
> > PostgreSQL has serious scalability problems with snort + acid. Any
> > advices?
>
> Usually porting from MySQL to PostgreSQL needs some rewrite of
> queries and process logic if good performance is required.
ACID is using ADODB SQL interface, thus using the same queries for
MySQL and PostgreSQL.
>
> > (Now I'm using MySQL with my SNORT/ACID setup, but I'm willing to
> > change to PostgreSQL if more tests are needed)
>
> Are these tests run using BSDDB backend (for transaction support) or
> the old/fast MySQL storage ?
Dunno (These tests arent executed by me), but probably using the
old transaction-less format of MySQL.
Sergio Bruder
--
Coordenação de Desenvolvimento - Projetos Especiais, Conectiva
http://www.conectiva.com.br, http://sergio.bruder.net, http://pontobr.org
-----------------------------------------------------------------------------
pub 1024D/0C7D9F49 2000-05-26 Sergio Devojno Bruder <bruder(at)conectiva(dot)com(dot)br>
Key fingerprint = 983F DBDF FB53 FE55 87DF 71CA 6B01 5E44 0C7D 9F49
sub 1024g/138DF93D 2000-05-26
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2001-07-10 14:04:43 | Re: Any tips for this particular performance problem? |
Previous Message | Janning Vygen | 2001-07-10 13:21:37 | Re: Performance tuning for linux, 1GB RAM, dual CPU? |