Re: pgbench create index anomoly - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pgbench create index anomoly
Date
Msg-id 15573.1148337259@sss.pgh.pa.us
Whole thread Raw
In response to pgbench create index anomoly  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
"Jim C. Nasby" <jnasby@pervasive.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


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: FW: iDefense Q2 2006 Vulnerability Challenge
Next
From: Tom Lane
Date:
Subject: Re: group by points