Yang Zhang <yanghatespam@xxxxxxxxx> writes: > On Mon, Feb 22, 2010 at 1:13 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: >> the speed depends on setting of working_memory. Try to increase a working_memory > It's already at > 20000kB According to your original posting, you're trying to sort something like a gigabyte of data. 20MB is peanuts. I wouldn't recommend increasing the value across-the-board, but setting it to several hundred meg for this particular query might help. How much RAM in your machine anyway? Also, the fact that mysql is faster suggests that having an index does help. Possibly the data is nearly ordered by transactionid, in which case an indexscan would not have random-access problems and would be much faster than an explicit sort. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
