Re: IN question

Mat Caughron wrote:
> All:
>
> In the interest of investigating various throughput limits.
> Where do we get cache and buffer and heap size limitations, and how to
> set these?
> Is there something similar in postgres-world to the mysql-world
> equivalent of the following:
>
> mysql> show variables like '%size%';
> +---------------------------------+------------+
> | Variable_name | Value |
> +---------------------------------+------------+
> | bdb_cache_size | 8388600 |
> ...
There's the pg_settings table. More verbose than you want, probably, so
choose the records and columns of interest:
select * from pg_settings;

There are certain settings which can be altered by a user during a
session via the "set" command.

Some settings can only be altered by the administrator and of those,
some require a restart for the change to take effect.

Cheers,
Steve