Re: [ADMIN] Setting kernel.shmmax
To: "fatih ozturk"
Cc: pgsql-admin@postgresql.org
Date: Friday, July 10, 2009, 9:21 AM
Free memory is going to be used by operating system as cache memory. If
operating system does not need to use this memory, it will remain as free.
How big
Hi
My question is about shmmax kernel parameter and its importance in tuning
postgresql database.
Our database version:
postgres=# select version();
version
-
ril 2009 à 11:02:24, Fujii Masao a écrit :
> Hi,
>
> On Thu, Apr 9, 2009 at 5:15 PM, fatih ozturk wrote:
> > Problem is i dont understand the difference between log_statement='all'
> > and log_statement='mod'?
>
> AFAIK, 'mod' doesn&#
Hi
In http://www.postgresql.org/docs/8.3/static/runtime-config-logging.html
log_statement explained as
"
log_statement (string)Controls which SQL statements are logged. Valid
values are none, ddl, mod, and all. ddl logs all data
definition statements, such as CR
Thank you
"Yes, it does. It might be worthwile to use
WHERE sel=123 AND mod(sel,6)=3
I think you could use a rule to add the mod() condition automatically.
"
this is great idea
But the problem is i did not accomplish to find a way to change query like
partitioning=# select * from main
Hi
My problem in partitioning is about using functions in table check constraints.
let me explain it
"
DROP DATABASE partitioning;
\set ON_ERROR_STOP y
CREATE DATABASE partitioning;
ALTER DATABASE partitioning set constraint_exclusion TO true;
\c partitioning
CREATE language plpgsql;
CREATE TABL
Hi
I want to ask some part of a question that is asked before by "Duan Ligong" and
not answered
"
Could you explain how the clog files work roughly?
(What is inside of the clog files? when and how the new clog files
are created? when and in what case the old files are deleted
or rotated? how
