> Isn't there anything faster than this? > > I was hoping to run many thousands of small (i.e. 100ms or less) queries > and if it takes a couple of seconds to restart the database I'm not > going to be able to do this.
Are you forgetting the OS's file system cache? That will also have a huge effect on performance, and so you'll need to clear it as well. -- Scott Ribe scott_r...@killerbytes.com http://www.killerbytes.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general