Re: Any tips for this particular performance problem? - Mailing list pgsql-hackers

From Stephan Szabo
Subject Re: Any tips for this particular performance problem?
Date
Msg-id Pine.BSF.4.21.0107100944320.92724-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Any tips for this particular performance problem?  (Sergio Bruder <bruder@conectiva.com.br>)
Responses Re: Any tips for this particular performance problem?  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-hackers
On Tue, 10 Jul 2001, 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?
> 
> (Now I'm using MySQL with my SNORT/ACID setup, but I'm willing to
> change to PostgreSQL if more tests are needed)

It might be handy to see schema and query examples for the system.
There may be obvious things in the queries such that we'll at least
be able to tell you why things seem to be slow.




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: FE/BE protocol oddity
Next
From: Bruce Momjian
Date:
Subject: Re: AW: AW: pg_index.indislossy