sub select performance due to seq scans
This is a discussion on sub select performance due to seq scans within the Pgsql Performance forums, part of the PostgreSQL category; --> Hi, Scott and Hale, Scott Marlowe wrote: > Make sure analyze has been run and that the statistics are ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 09:13 AM
| ||||
| ||||
 Re: sub select performance due to seq scans Hi, Scott and Hale, Scott Marlowe wrote: > Make sure analyze has been run and that the statistics are fairly > accurate. It might also help to increase the statistics_target on the column in question. HTH, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster      |
Linear Mode
