Re: [GENERAL] vacuum analyze again...

2001-02-21 Thread Pete Forman
* Allow ANALYZE to process a certain random precentage of > rows Does this reduced analysis need to be random? Why not allow the DBA to specify what rows or blocks to do in some way. -- Pete Forman -./\.- Disclaimer: This post is originated WesternGeco

[GENERAL] Re: How do I import table information?

2001-01-19 Thread Pete Forman
the comments with sed 's/^#/--/' /home/dir/database.sql | psql -e database or ignore them with grep -v '^#' /home/dir/database.sql | psql -e database -- Pete Forman -./\.- Disclaimer: This post is originated WesternGeco -./\.-