Re: pgbench create index anomoly

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pgbench create index anomoly
Date: 2006-05-22 22:34:19
Message-ID: 15573.1148337259@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> What's with the second workMem setting?

That's the second sort bucket for recently-dead tuples (which still have
to be indexed, but shouldn't be fed into the unique-checking sort).
We assume there won't be a lot of them, hence don't use
maintenance_work_mem to size that sort.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-05-22 22:38:35 Re: group by points
Previous Message Mischa Sandberg 2006-05-22 22:00:08 Re: Porting MSSQL to PGSQL (Was: [OT] MySQL is bad, but