Re: [PERFORM] Backup/restore of pg_statistics

2003-11-19 Thread Tom Lane
Joel Jacobson <[EMAIL PROTECTED]> writes: > I understand that it is not possible to occasionally re-plan the queries in a > PL/pgSQL function without dropping and re-creating the function. Huh? You only need to start a fresh connection. regards, tom lane

[PERFORM] Backup/restore of pg_statistics

2003-11-17 Thread Joel Jacobson
Hi, I understand that it is not possible to occasionally re-plan the queries in a PL/pgSQL function without dropping and re-creating the function. I think it would be useful if the queries in a PL/pgSQL function could be re-planned on-the-fly. When a lot of data has been added/modified and ANALY