Postgres Pro
Downloads
Home   >   mailing lists

Limiting number of records to show. - Mailing list pgsql-novice

From Wim
Subject Limiting number of records to show.
Date
Msg-id 3CD24E85.8000008@belbone.be
Whole thread Raw
List pgsql-novice
Tree view 
Hello,

I have a table with over 1.000.000 records. I'd like to limit the
maximum number of records to display, so if one my users opens the whole
table, he will see only for example 1000 records.
If I don't limit and they open the whole table, the server's CPU-load
raises to 150...
I searched the docs, but couldn't find the info....

Is this possible? If yes, how do I do this?

Thanx!

pgsql-novice by date:

Previous
From: cristi voinicaru
Date:
Subject: unsubscribe
Next
From: "Duncan Adams (DNS)"
Date:
Subject: Re: Limiting number of records to show.