Re: Should pg 11 use a lot more memory building an spgist index?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Bruno Wolff III <bruno@wolff.to>

Cc: pgsql-general@lists.postgresql.org

Date: 2018-10-24T09:21:11Z

Lists: pgsql-hackers

Bruno Wolff III <bruno@wolff.to> writes:
> If I have a substantial database dump file to provide for reproducing this 
> do you prefer it on a web server somewhere? I expect that mailing very 
> large attachments to the lists is a bad idea.

No, don't do that.  If you can make sample data available for download,
or point to some accessible dataset somewhere, that'd work.

			regards, tom lane

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix memory leak in repeated SPGIST index scans.
- 696b0c5fd0a8 12.0 landed
- 95015b1f8e8e 9.4.20 landed
- 92e371f9b143 10.6 landed
- 82dd1c271492 9.3.25 landed
- 558571afc7c4 9.6.11 landed
- 156a737a6b73 9.5.15 landed
- 2493e2c2d167 11.1 landed
Add support for nearest-neighbor (KNN) searches to SP-GiST
- 2a6368343ff4 12.0 cited