Prev: [HACKERS] git config user.email
Next: git config user.email
From: "mac_man2008 on 21 Jul 2010 11:54
Hi to all.

I am trying to see how PostgreSQL performance changes on the basis of
work_mem. So, I am going to execute the 22 queries of TPCH
(http://www.tpc.org/tpch/) again and again, each time for a different
value of work_mem.
Since I am interested just in work_mem variations, I should prevent each
query to take advantages from revious executions of the 22 queries them
selves. For example, taking cache advantages. So, taking into account
that the 22 queries are those http://pastebin.com/7Dg50YRZ and are
executed on tables of hundreds of MB and

1) Is it sufficient to run change the values of work_mem through psql
and running the queries again without restarting postgres?

2) Or, should I restart postgres?

3) Or, shoud I restart the machine each time I execute the 22 queries?

Thanks for your time.
Regards.

Manolo.

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

 | 
Pages: 1
Prev: [HACKERS] git config user.email
Next: git config user.email