Ticket #221 (closed task: fixed)

Opened 4 years ago

Last modified 4 years ago

Upgrade performance tips in documentation

Reported by: pramsey Owned by: jlivni
Priority: medium Milestone: PostGIS 1.5.0
Component: postgis Version: trunk
Keywords: Cc:

Description

Pull some of the advice from here  http://2007.foss4g.org/presentations/view.php?abstract_id=117 into the documentation section on performance.

Attachments

performance_tips.patch Download (4.5 KB) - added by jlivni 4 years ago.

Change History

Changed 4 years ago by jlivni

Changed 4 years ago by jlivni

  • status changed from new to assigned

A small patch is attached, which includes a few of the tips/tweaks from the abstract.

Changed 4 years ago by robe

  • status changed from assigned to closed
  • resolution set to fixed

committed at r4425. Also took some artistic liberties by linking back to relevant sections of the PostgreSQL manual and other sources as well as items that are obsolete or have changed in later versions of PostgreSQL.

Kevin can you correct if I got anything wrong with the WAL part. That was the part I was most unsure about.

Changed 4 years ago by robe

Patched for doc 1.4 at r4426

Changed 4 years ago by kneufeld

Ah interesting. K, so these tips are getting quite old ... at the time of writing, was geared for 8.0 - 8.1 databases.

I think it would be better to rework the opening paragraphs ... just explain why someone would want to tune their databases. I'm definitely not after any publicity - remove references to me and the now obsolete doc. Perhaps a line "for further reading, see:" followed by a list of reference material like the PostgreSQL docs, Greg's notes, and any other current references folks find useful.

So, with that, the "this setting is now obsolete" type of comments could be replaced with just the current recommended settings as you have started to do, Regina. ie. checkpoint_segment_size and constraint_exclusion.

I can tackle this at some point.

Note: See TracTickets for help on using tickets.