On Fri, Jul 22, 2011 at 12:19 PM, Ioana Danes <ioanasoftw...@yahoo.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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
