Sorry for my post to the wrong list, I re-posted the mail to the jobs list.
-- Andreas
Andreas Hartmann schrieb:
Dear PostgreSQL community,
we're looking for a freelancer with PostgreSQL experience in the area of
Zürich, Switzerland. The task will be to maintain and improve the
dat
s and indices, backups,
performance analysis and optimization, ...).
If you're interested, don't hesitate to contact me.
Thanks a lot in advance!
-- Andreas
--
Andreas Hartmann, CTO
BeCompany GmbH
http://www.becompany.ch
Tel.: +41 (0) 43 818 57 01
---(e
Andreas Hartmann wrote:
Hi all,
I'm running the same database on two systems:
A) Debian PostgreSQL 7.4.7
B) SuSE PostgreSQL 7.3.4
Both machines have approx. 1GHz and 1GB RAM.
The amount of data is almost equal (+- 10%). But I'm facing
huge performance differences. For instance
Hi all,
I'm running the same database on two systems:
A) Debian PostgreSQL 7.4.7
B) SuSE PostgreSQL 7.3.4
Both machines have approx. 1GHz and 1GB RAM.
The amount of data is almost equal (+- 10%). But I'm facing
huge performance differences. For instance, a simple sequential
scan results in the fo
Richard Huxton wrote:
Andreas Hartmann wrote:
Dear postgresql community,
I have a quite complex statement. When I execute it directly via
psql, the execution time is approx. 2000 ms.
When I execute it via JDBC (Apache Cocoon), the execution time
is either 600..1000 ms or approx. 10.000 ms, based
Dear postgresql community,
I have a quite complex statement. When I execute it directly via
psql, the execution time is approx. 2000 ms.
When I execute it via JDBC (Apache Cocoon), the execution time
is either 600..1000 ms or approx. 10.000 ms, based on a certain
value in a table.
An interesting po
