On Wednesday 26 September 2001 09:29 am, Mihai Gheorghiu wrote:
> Thank you very much.
> Actually, it was the optimization parameters that I was interested in. My
> db works rather slow even in single user mode and I wondered if I had
> missed some setup.
See Bruce's Performance article, which is linked to from
techdocs.postgresql.org. But, the direct link is
Even though it discusses hardware performance tuning, sizing the shared
buffer cache and the sort size is also discussed.
> BTW, is there a way to see what parameters are in
From a psql session you can show any runtime parameter that is set by using
the SQL 'SHOW' command. For instance, using SHOW tcpip_socket; from a psql
session I can get:
template1=# show tcpip_socket;
NOTICE: tcpip_socket is off
template1=# show shared_buffers;
NOTICE: shared_buffers is 64
Use the listing in the administrator's guide (the link above) to see a
listing of the possible paramters, and then SHOW that parameter to see what
you want to see.
Although SHOW should have a way of listing ALL settings, IMHO.
WGCR Internet Radio
1 Peter 4:11
In response to
pgsql-general by date
|Next:||From: Arcady Genkin||Date: 2001-09-26 17:35:48|
|Subject: Authenticating user `postgres'|
|Previous:||From: Vic Cekvneich||Date: 2001-09-26 17:24:30|
|Subject: Re: JDBC update wont, plz help.|