Re: WAS: PostgreSQL Replication Server? IS: Zend comparison - Mailing list pgsql-general

From Gregory Wood
Subject Re: WAS: PostgreSQL Replication Server? IS: Zend comparison
Date
Msg-id 004b01c0f37f$d6e74210$7889ffcc@comstock.com
Whole thread Raw
In response to Re: WAS: PostgreSQL Replication Server? IS: Zend comparison chart  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-general
> > we did some testing where a client was seeing 4k+ TPS *shrug*
>
> So, is one select statement equal to one of these transactions? Seems to
me
> that talking about transactions per second is like talking about
instructions
> per second on a complex instruction-set CPU - depending what you use
> for an instruction, your answer could vary significantly.

Just reading this discussion it sounds to me like empty transactions (ie. a
bunch of BEGIN; COMMIT;). Which is a good measure of transaction overhead,
but not necessarily real world performance.

Greg


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: very big problem with NULL
Next
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: Please help! Functions passing records between them