Re: problems with large table - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: problems with large table
Date
Msg-id 20070912200950.GA5593@alvh.no-ip.org
Whole thread Raw
In response to Re: problems with large table  (Mike Charnoky <noky@nextbus.com>)
Responses Re: problems with large table
List pgsql-general
Mike Charnoky wrote:

> Alvaro: The cluster suggestion probably won't help in my case since data
> in the table should already be naturally ordered by date.

It's not helpful only for reordering, but also for getting rid of dead
tuples.

--
Alvaro Herrera                         http://www.flickr.com/photos/alvherre/
"Porque Kim no hacia nada, pero, eso sí,
con extraordinario éxito" ("Kim", Kipling)
/bin/bash: sigcommand: command not found

pgsql-general by date:

Previous
From: Mike Charnoky
Date:
Subject: Re: problems with large table
Next
From: Cultural Sublimation
Date:
Subject: Re: Cannot declare record members NOT NULL