From: Markus Schaber <schabi@logix-tt.com>
To: PostgreSQL Performance List <pgsql-performance@postgresql.org>
Subject: Re: PostgreSQL underestimates sorting
Date: Wed, 22 Nov 2006 17:59:46 +0100
Message-ID: <45648202.3050109@logix-tt.com> (raw)
In-Reply-To: <20061122105341.79874069.frank@wiles.org>
References: <456423B3.7010505@logix-tt.com>
<20061122135434.GA9669@uio.no>
<45645E7C.4030101@logix-tt.com>
<20061122105341.79874069.frank@wiles.org>
Hi, Frank,
Frank Wiles wrote:
>> The temporary data is not swapping, it's the Postgres on-disk sort
>> algorithm.
>
> Are you actually running a query where you have a GB of data
> you need to sort? If not I fear you may be causing the system
> to swap by setting it this high.
Yes, the table itself is about 40 Gigs in size, thus much larger than
the memory. The machine has 16 Gigs of ram, and 10-12 Gigs are available
for PostgreSQL + Disk Cache.
There's no swapping, only 23 MB of swap are used (40 Gigs are available).
That's one example configuration, there are others on different machines
where it turns out that forcing index usage leads to faster queries, and
less overall ressource consumption. (Or, at least, faster delivery of
the first part of the result so the application can begin to process it
asynchroneously).
Thanks,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: schabi@logix-tt.com
Subject: Re: PostgreSQL underestimates sorting
In-Reply-To: <45648202.3050109@logix-tt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox