Skip site navigation (1) Skip section navigation (2)

Re: Scaling concerns

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: tsuraan <tsuraan(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Scaling concerns
Date: 2006-12-16 17:32:21
Message-ID: 20061216173221.GA25410@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
On Sat, Dec 16, 2006 at 11:26:02AM -0600, tsuraan wrote:
> Even an operation like "select count(*) from messages" can take minutes,
> with a totally idle system.  Postgres seems to be the most scalable Free
> database out there, so I must be doing something wrong.

Unqualified SELECT COUNT(*) FROM foo is one of the most expensive operations
you can do on your system, since the visibility information has to be checked
on disk for each row. Instead, try real queries on real data, and post here
if some are too slow for you.

/* Steinar */
-- 
Homepage: http://www.sesse.net/

In response to

Responses

pgsql-performance by date

Next:From: Michael StoneDate: 2006-12-16 17:33:41
Subject: Re: New to PostgreSQL, performance considerations
Previous:From: tsuraanDate: 2006-12-16 17:26:02
Subject: Scaling concerns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group