On 9 November 2010 09:34, Machiel Richards <machielr(at)rdc(dot)co(dot)za> wrote:
> Good day all
> I am trying to find out how I can select the last 2 or (n amount ) of
> rows from a specific table.
> We have a table which has been growing rediculously the last view
> days (I must say after a code go-live).
> I am trying to find out what data is being written to the table that
> is causing this, however due to the size of the table at the moment, it can
> cause problems so I am just interested in the last number of records.
> I would appreciate any assistance in this.
Well, you'll have to decide what determines the order of your tuples. If
you have a column bound to a sequence, and that is considered to put them in
order, then it would be
ORDER BY sequence_column DESC
Or you could replace that with a date field if appropriate. But whatever
column you use, you'd need an index on it.
IRC (freenode): dark_ixion
Registered Linux user: #516935
In response to
pgsql-novice by date
|Next:||From: Majid Azimi||Date: 2010-11-09 09:48:42|
|Subject: Re: Selecting the last 2 rows of a table|
|Previous:||From: Machiel Richards||Date: 2010-11-09 09:34:48|
|Subject: Selecting the last 2 rows of a table|