Opened 7 years ago

Closed 7 years ago

#3746 closed task (fixed)

Bring performance tips section up to newer versions

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 2.3.3
Component: documentation Version: 2.3.x
Keywords: Cc:

Description

Clearly we haven't done much with this section in a while giving we are still referring to 8.0. THis whole section probably needs to be updated to the time.

Andreas Schild created an issue for the string: Current PostgreSQL versions (including 8.0) suffer from a query optimizer weakness regarding TOAST tables. TOAST tables are a kind of "extension room" used to store large (in the sense of data size) values that do not fit into normal data pages (like long texts, images or complex geometries with lots of vertices), see <ulink url="http://www.postgresql.org/docs/current/static/storage-toast.html">the PostgreSQL Documentation for TOAST</ulink> for more information). 
 
Current PostgreSQL versions (including 8.0) ?? ...current Version is 9.6	

	
 
Project: PostGIS
 
Resource: performance_tips.xml.pot
 
Language: German (Germany)

 

Change History (3)

comment:1 by robe, 7 years ago

Milestone: PostGIS 2.4.0PostGIS 2.3.3

Andreas also pointed out we still talk about manually updating the geometry_columns table. How embarrassing.

comment:2 by robe, 7 years ago

In 15468:

Bring performance tips section up to newer versions
References #3746 for PostGIS 2.4 (trunk)

comment:3 by robe, 7 years ago

Resolution: fixed
Status: newclosed

In 15469:

Bring performance tips section up to newer versions
Closes #3746 for PostGIS 2.3 (branch)

Note: See TracTickets for help on using tickets.