| From: | Wes <wespvp(at)syntegra(dot)com> |
|---|---|
| To: | Greg Stark <gsstark(at)mit(dot)edu>, Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
| Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Much Ado About COUNT(*) |
| Date: | 2005-01-13 23:55:14 |
| Message-ID: | BE0C6682.3EEA%wespvp@syntegra.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On 1/13/05 9:50 AM, "Greg Stark" <gsstark(at)mit(dot)edu> wrote:
> I think the Oracle syntax looks like
>
> SELECT * FROM foo SAMPLE (0.1)
>
> I don't think I would have picked this syntax but it seems like a better idea
> to copy the existing practice rather than invent a new one.
Of course, in Oracle 'count(*)' is instantaneous. It doesn't have to count
the physical records one by one.
Wes
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2005-01-14 00:44:44 | Re: [HACKERS] Much Ado About COUNT(*) |
| Previous Message | Mark Dexter | 2005-01-13 23:18:12 | Version Control Software for Database Objects |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2005-01-13 23:58:43 | Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster) |
| Previous Message | Tom Lane | 2005-01-13 23:55:11 | Re: Bug? 8.0 does not use partial index |