Re: problems with large table

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Mike Charnoky <noky(at)nextbus(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: problems with large table
Date: 2007-09-12 20:09:50
Message-ID: 20070912200950.GA5593@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cultural Sublimation 2007-09-12 20:18:54 Re: Cannot declare record members NOT NULL
Previous Message Mike Charnoky 2007-09-12 20:03:18 Re: problems with large table