On 07/04/2012 07:13 AM, Reza Taheri wrote:
Following the earlier email introducing the TPC-V benchmark, and that
we are developing an industry standard benchmarking kit for TPC-V
using PostgreSQL, here is a specific performance issue we have run into.
Which version of PostgreSQL are you us
On 07/04/2012 07:08 AM, Reza Taheri wrote:
... so the subcommittee moved forward with developing its own
reference kit. The reference kit has been developed to run on
PostgreSQL, and we are focusing our development efforts and testing on
PostgreSQL.
That's a very positive step. The TPC seems t
Hello PostgreSQL fans,
I would like to introduce myself and the TPC-V benchmark to the PostgreSQL
community. I would then like to ask the community to help us make the TPC-V
reference benchmarking kit a success, and establish PostgreSQL as a common DBMS
used in measuring the performance of enter
It sounds like a lot of marketing BS :)
But I like the fact that they use modern language like C++. It is a
pain to try doing any development on postgresql. Transition to c++
would be nice (I know it's been debated on #hackers a looot).
--
Sent via pgsql-performance mailing list (pgsql-performan
On Fri, Jun 22, 2012 at 11:04:36AM -0700, David Kerr wrote:
> On Fri, Jun 22, 2012 at 01:27:51PM -0400, Tom Lane wrote:
> - David Kerr writes:
> - > I'm trying to work through a root cause on a performance problem. I'd
> like to
> - > be able to "show" that a problem was fixed by analyzing the ta
El 03/07/12 15:44, Kevin Grittner escribió:
You provided too little information to suggest much beyond using JOIN
instead of a subquery. Something like:
I think that adding new columns to Product , lft and rgt with index
should be fast. But does not seem a good design.
Tables:
#
PV wrote:
> Any suggestion?
You provided too little information to suggest much beyond using JOIN
instead of a subquery. Something like:
SELECT pr.id, pr.catid, cat.a, cat.b
FROM pr join cat ON (cat.id = pr.catid)
WHERE "lft" > 1 AND "rgt" < 10 AND (...)
ORDER BY cat.id
OFFSET 0 LIM
Hello,
I "have" this two tables:
Table Cat:
id|A|B
--+-+-
1|3|5
2|5|8
3|6|9
Table Pr:
id|Catid|
--+-
1|3
2|2
3|1
I need replace "Catid" column for corresponding values A and B (Table
Cat) in Table Pr.
Virtual table like this:
Table Pr:
id|Catid|A|B
--+-+-+
1|3|6|9
2|2|5|8
3|1|3|5
Someth
