Skip site navigation (1) Skip section navigation (2)

Re: Hardware/OS recommendations for large databases (

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Luke Lonergan <llonergan(at)greenplum(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, "eng(at)intranet(dot)greenplum(dot)com" <eng(at)intranet(dot)greenplum(dot)com>
Subject: Re: Hardware/OS recommendations for large databases (
Date: 2005-11-24 05:34:03
Message-ID: 438550CB.5020506@paradise.net.nz (view raw or flat)
Thread:
Lists: pgsql-performance
Luke Lonergan wrote:
> Mark,
> 
> This is an excellent idea – unfortunately I’m in Maui right now 
> (Mahalo!) and I’m not getting to testing with this.  My first try was 
> with 8.0.3 and it’s an 8.1 function I presume.
> 
> Not to be lazy – but any hint as to how to do the same thing for 8.0?
> 

Yeah, it's 8.1 - I didn't think to check against 8.0. The attached 
variant works with 8.0.4 (textToQualifiedNameList needs 2 args)

cheers

Mark

P.s. Maui eh, sounds real nice.

Attachment: fastcount-8.0.c
Description: text/plain (1.0 KB)

In response to

pgsql-performance by date

Next:From: Luke LonerganDate: 2005-11-24 08:17:06
Subject: Re: Hardware/OS recommendations for large databases (
Previous:From: andrewDate: 2005-11-24 05:20:19
Subject: Re: 8.1 count(*) distinct: IndexScan/SeqScan

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group