Re: Why do I have reading from the swap partition?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Ioana Danes <ioanasoftware(at)yahoo(dot)ca>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why do I have reading from the swap partition?
Date: 2011-07-22 19:24:59
Message-ID: CAOR=d=3rOHa8Y9qWHSjdOGYv-fc=xZ3kGM-UsiLbhp4Z3cDV0w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 22, 2011 at 12:19 PM, Ioana Danes <ioanasoftware(at)yahoo(dot)ca> wrote:

> I do a select * from a 8 GB table (a different one then the one used in the query). At a point it starts using swap space on disk. Once it starts swapping I still let it run for couple of minutes and the I stop it (CTRL+C).

Are you running psql on the same machine? My guess is that psql is
what's swapping. Try running:

select count(*) from (select * from mybigfreakingtable);

and see if you start hitting swap like that.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pablo Romero Abiti 2011-07-22 20:02:46 Update columns in same table from update trigger?
Previous Message Karl Nack 2011-07-22 19:15:43 Implementing "thick"/"fat" databases