Re: [HACKERS] []performance issues

From: "David Blood" <david(at)matraex(dot)com>
To: "'PostgreSQL general list'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [HACKERS] []performance issues
Date: 2002-08-02 15:57:16
Message-ID: 002e01c23a3d$4a656410$1f00a8c0@redwood
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


Count() is slow even on your Sun server with 16gb ram? How big is the
database?

David Blood
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Andrew Sullivan
Sent: Friday, August 02, 2002 9:40 AM
To: PostgreSQL-development
Cc: PostgreSQL general list
Subject: Re: [GENERAL] [HACKERS] []performance issues

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2002-08-02 16:20:06 Re: Selecting random row
Previous Message Andrew Sullivan 2002-08-02 15:54:56 Re: How i can empty the buffers of a db

Browse pgsql-hackers by date

  From Date Subject
Next Message J. R. Nield 2002-08-02 16:26:52 Re: PITR, checkpoint, and local relations
Previous Message Andrew Sullivan 2002-08-02 15:39:32 Re: [HACKERS] []performance issues