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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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 | Content-Type | Size |
---|---|---|
fastcount-8.0.c | text/plain | 1.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Luke Lonergan | 2005-11-24 08:17:06 | Re: Hardware/OS recommendations for large databases ( |
Previous Message | andrew | 2005-11-24 05:20:19 | Re: 8.1 count(*) distinct: IndexScan/SeqScan |