Hi,
I have found under
http://www.physiol.ox.ac.uk/Computing/Online_Documentation/postgresql/plpgsql.html#PLPGSQL-OVERVIEW
Note: The PL/pgSQL EXECUTE statement is not related to the EXECUTE
statement supported by the PostgreSQL server. The server's EXECUTE
stateme
On Thu, 19 Apr 2007, Sergey Tsukinovsky wrote:
I know that 7.0.2 is an old version and therefore ran the same test on
7.3.18 - the performance behavior was similar.
Why have you choosen just another very old version for performance
comparison and not the latest stable release?
Kind regards
On Thu, 22 Mar 2007, Andreas Kostyrka wrote:
Which version of PG?
Ahh, sorry, forgot that. The issue occurs in Debian (Etch) packaged
version 7.4.16. I plan to switch soon to 8.1.8.
That's the reason why PG (check the newest releases, I seem to
remember that there has been some aggregate o
Hi,
I just try to find out why a simple count(*) might last that long.
At first I tried explain, which rather quickly knows how many rows
to check, but the final count is two orders of magnitude slower.
My MS_SQL server using colleague can't believe that.
$ psql InfluenzaWeb -c 'explain SELECT
Hi,
I'm running a Zope web application that obtains most of its data
from a PostgreSQL 8.1 database in a virtual machine. I'm able to
adjust the memory of this machine according to reasonable values
and can choose between one or two (emulated) processors. The
question is: How can I find an opti
Hi,
I'm running a web application using Zope that obtains all data
from a PostgreSQL 7.4 database (Debian Sarge system with package
7.4.7-6sarge4 on an "older" Sparc machine, equipped with 2GB
memory and two processors E250 server). Once I did some performance
tuning and found out that
max
