[PERFORM] pg_dump and pg_restore

2010-05-16 Thread Jayadevan M
Hello all, I was testing how much time a pg_dump backup would take to get restored. Initially, I tried it with psql (on a backup taken with pg_dumpall). It took me about one hour. I felt that I should target for a recovery time of 15 minutes to half an hour. So I went through the blogs/documenta

Re: [PERFORM] Planner issue on sorting joining of two tables with limit

2010-05-16 Thread Robert Haas
On Fri, May 7, 2010 at 11:35 AM, Tom Lane wrote: > "Kevin Grittner" writes: >> Alexander Korotkov wrote: I just don't find why it is coincidence. I think that such plan will always produce result ordered by two columns, because such nested index scan always produce this result. >