Re: vacuum locking - Mailing list pgsql-performance

From Tom Lane
Subject Re: vacuum locking
Date
Msg-id 24018.1067472198@sss.pgh.pa.us
Whole thread Raw
In response to Re: vacuum locking  (Rob Nagler <nagler@bivio.biz>)
Responses Re: vacuum locking  (Rob Nagler <nagler@bivio.biz>)
List pgsql-performance
Rob Nagler <nagler@bivio.biz> writes:
> q5 and q6 are too complex to discuss here,

How do you expect us to get better if you don't show us the problems?

BTW, have you tried any of this with a 7.4beta release?  Another project
that I'm aware of saw several bottlenecks in their Oracle-centric code
go away when they tested 7.4 instead of 7.3.  For instance, there is
hash aggregation capability, which would probably solve the aggregate
query problem you were complaining about in
http://archives.postgresql.org/pgsql-performance/2003-10/msg00640.php

            regards, tom lane

pgsql-performance by date:

Previous
From: Rob Nagler
Date:
Subject: Re: vacuum locking
Next
From: Christopher Browne
Date:
Subject: Re: PostgreSQL 7.4beta5 vs MySQL 4.0.16 with RT(DBIx::SearchBuilder)