| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | PostgreSQL general list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] []performance issues |
| Date: | 2002-08-02 15:39:32 |
| Message-ID: | 20020802113932.D8966@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Fri, Aug 02, 2002 at 03:48:39PM +0400, Yaroslav Dmitriev wrote:
>
> So I am still interested in PostgreSQL's ability to deal with
> multimillon records tables.
[x-posted and Reply-To: to -general; this isn't a development
problem.]
We have tables with multimillion records, and they are fast. But not
fast to count(). The MVCC design of PostgreSQL will give you very
few concurerncy problems, but you pay for that in the response time
of certain kinds of aggregates, which cannot use an index.
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2002-08-02 15:47:03 | Re: Questions regarding contrib/tsearch |
| Previous Message | Tourtounis Sotiris | 2002-08-02 15:29:33 | Re: How i can empty the buffers of a db |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Blood | 2002-08-02 15:57:16 | Re: [HACKERS] []performance issues |
| Previous Message | Andrew Sullivan | 2002-08-02 15:32:07 | Re: FUNC_MAX_ARGS benchmarks |