| 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: | Whole Thread | Raw Message | 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 |