Hello, Nick!

Tuesday, July 30, 2013, 1:41:21 PM, you wrote:

NU> gstat -r output:

NU> pre backup/restore

you again checked select * from table at that moment?
and it is 4.8 sec?

NU> post backup/restore
and here - 0.3 sec?

NU> I obviously expect some improvement from backup/restore but 15x seems more
NU> than can be accounted for

I doubt that your measures are correct.
Since I see 130k records, I think that
4.8 seconds of select * from table
takes FetchAll, i.e. transferring all records to client application.

And, 0.3 seconds for the same query on 130k records
means that FetchAll is not in effect, ony some parts of records
are being read.

Or, (which is a bit suspicious), your hard drive is very slow
at random reads, if at first case this table pages were fragmented
in the DB.

--
Dmitry Kuzmenko, www.ib-aid.com