Hi, Frank, Frank Wiles wrote: >> The temporary data is not swapping, it's the Postgres on-disk sort >> algorithm. > > Are you actually running a query where you have a GB of data > you need to sort? If not I fear you may be causing the system > to swap by setting it this high. Yes, the table itself is about 40 Gigs in size, thus much larger than the memory. The machine has 16 Gigs of ram, and 10-12 Gigs are available for PostgreSQL + Disk Cache. There's no swapping, only 23 MB of swap are used (40 Gigs are available). That's one example configuration, there are others on different machines where it turns out that forcing index usage leads to faster queries, and less overall ressource consumption. (Or, at least, faster delivery of the first part of the result so the application can begin to process it asynchroneously). Thanks, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org
