Re: [PERFORM] Drop statistics?

2012-07-04 Thread David Kerr
On Jul 3, 2012, at 10:16 AM, Bruce Momjian wrote: > 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 a

Re: [PERFORM] Introducing the TPC-V benchmark, and its relationship to PostgreSQL

2012-07-04 Thread Mark Kirkwood
On 05/07/12 06:24, Reza Taheri wrote: I'll pick up Greg's book. We had been focusing on functionality, but our focus will shift to performance soon. To be blunt, the team is very experienced in benchmarks and in database performance, but most of us are new to PGSQL. The book is well worth

Re: [PERFORM] Introducing the TPC-V benchmark, and its relationship to PostgreSQL

2012-07-04 Thread Reza Taheri
Thanks for reply, Craig. As far as publishing a draft, we are planning to do something along those lines. For the schema and the queries, we are pretty much taking those wholesale from TPC-E, whose specification is public (http://www.tpc.org/tpce/spec/v1.12.0/TPCE-v1.12.0.pdf). The high-level

Re: [PERFORM] The need for clustered indexes to boost TPC-V performance

2012-07-04 Thread Daniel Farina
On Tue, Jul 3, 2012 at 10:43 PM, Craig Ringer wrote: > 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 w

Re: [PERFORM] static virtual columns as result?

2012-07-04 Thread PV
SOLVED: 1) Try remove old functions tsearch, ltree,..., "old" database format 2) Vacuum or rebuild database One could solve the problem. Regards -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpre

Re: [PERFORM] The need for clustered indexes to boost TPC-V performance

2012-07-04 Thread Craig Ringer
On 07/04/2012 03:57 PM, Thomas Kellerer wrote: Craig Ringer, 04.07.2012 07:43: I'm not sure what the best option for getting a 9.2 beta build for Windows is. Download the ZIP from here: http://www.enterprisedb.com/products-services-training/pgbindownload Gah, I'm blind. I looked at that pa

Re: [PERFORM] The need for clustered indexes to boost TPC-V performance

2012-07-04 Thread Thomas Kellerer
Craig Ringer, 04.07.2012 07:43: I'm not sure what the best option for getting a 9.2 beta build for Windows is. Download the ZIP from here: http://www.enterprisedb.com/products-services-training/pgbindownload Unzip, initdb, pg_ctl start Regards Thomas -- Sent via pgsql-performance mailin