Hi. It is sometimes hard to tune complicated queries. Maybe add new attribute to functions returning boolean - selectivity, defining how big is percent of rows for which the function returns true. 2011/4/15, Edison So <edison.so2@xxxxxxxxx>: > I have a DELL server running Windows server 2003 and Postgres 8.1. > > I used pg_dump to back up a database test: > > pg_dump -v -h localhost -p 5432 -U postgres -F c -b -f > "D:/db_dump/backup.bak" test > > The backup was showing the following error. > . > pg_dump: dumping contents of table history > pg_dump: [custom archiver] WARNING: ftell mismatch with expected position -- > ftell used > > pg_dump: dumping contents of table history_archive > > pg_dump: [custom archiver] WARNING: ftell mismatch with expected position -- > ftell used > > pg_dump: dumping contents of table historymetadata > > pg_dump: [custom archiver] WARNING: ftell mismatch with expected position -- > ftell used > > I was trying to do a Posgres 8.1.4 backup and restored it to Postgres 9.0 on > a new Dell server running Windows server 2008. > > Any clue how to resolve it? > > Edison > > -- > Edison > -- ------------ pasman -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
