Re: [SQL] Questions about vacuum analyze

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Steven M(dot) Wheeler" <swheeler(at)sabre(dot)com>, pgsql-sql(at)hub(dot)org
Subject: Re: [SQL] Questions about vacuum analyze
Date: 1999-10-11 15:45:13
Message-ID: 8117.939656713@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> writes:
> The thing I liked about the existing algorithm is that it did the
> sorting without the page faulting/thrashing caused by many sort
> algorithms.

Yes, I think we want to stick with the basic architecture of an
initial replacement-selection filter operating in limited memory,
followed by merge passes. I'm just thinking about how to reduce
the amount of disk space chewed up by intermediate merge results...

regards, tom lane

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1999-10-11 16:14:28 Re: [SQL] Questions about vacuum analyze
Previous Message Bruce Momjian 1999-10-11 15:07:44 Re: [SQL] Questions about vacuum analyze