On Thu, 2007-08-09 at 12:17 +0530, Pavan Deolasee wrote:

> OK. I wish to have a config parameter so that DBA can set
> the system level default and then override that (if required) for
> each table. It will also be useful for experimenting with different
> fillfactor. The only way today is either to recompile your sources 
> or change the parameter in every CREATE TABLE statement.

Why not just put an extra file into your test script that issues ALTER
TABLE statements on appropriate tables? If you run this between CREATE
and COPY you won't have to edit a thing. You'll be able to more easily
control the tables you want to set, so you'll be in less danger of
having a gain on one table wiped out by a loss on another table.

  Simon Riggs
  EnterpriseDB  http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to