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

Sorting Tuples

From: Manolo <manolo(dot)espa(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Sorting Tuples
Date: 2008-03-13 11:25:53
Message-ID: 1205407553.25988.14.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-novice
Hi to all.

INTRODUCTION:
I created a patch for PostgreSQL even if i'm not a PostgreSQL user. I
just wanted to implement an idea for possibly getting better External
Sorting module on PostgreSQL just using some basic C programming
knowledge and now I'm facing to using PostgreSQL for a while in order to
test my patch.
My patch "activates" when user is trying to sort a load of data more or
less twice bigger than his available memory (e.g.: sorting 5GB of data
just disposing of 1GB of available memory)

PROBLEM:
First of all I want to realise my patch does sorts correctly or not. But
it's a little bit difficult to check when

	SELECT * FROM huge_table ORDER BY a_column_of_huge_table;

means checking a 4 or 5 GB result...

QUESTION:
Is there a way to discover if data is sorted correctly other than
spending 2 months taking a look to the 5 GB result tuples, one by one?

Thanks for your attention.
Regards, Manolo.


Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2008-03-13 12:32:36
Subject: Re: Sorting Tuples
Previous:From: G. J. WalshDate: 2008-03-13 06:16:46
Subject: Re: array syntax in pg_execute call

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