[GENERAL] Backup/Restore bytea data

2013-01-13 Thread sub3
Hi, I am having an issue upgrading a really old 8.2 db up to 9.2.2. One of the tables contains a bytea field. When I backup & restore using pgadmin from my 9.2.2 install, it doesn't convert this field correctly. The original 8.2 database was created like: CREATE DATABASE test... ENCODING = 'SQL

[GENERAL] Full Text Search - Slow on common words

2010-10-28 Thread sub3
Hi, I have a small web page set up to search within my domain based on keywords. One of the queries is: SELECT page.id ts_rank_cd('{1.0, 1.0, 1.0, 1.0}',contFTI,q) FROM page, to_tsquery('steve') as q WHERE contFTI @@ q My problem is: when someone puts in a commonly seen word, the system