[GENERAL] Logging affected rows

2013-01-18 Thread classical_89
When i run a query , i just only want to the affected rows are logged to log file,What can i do ? .Is there a parameter in postgresql.conf to do that ? .Thanks in advance -- View this message in context: http://postgresql.1045698.n5.nabble.com/Logging-affected-rows-tp5740689.html Sent from the

[GENERAL] Correlation in pg_stats

2012-11-26 Thread classical_89
Hi,First sorry for my bad English :D.I'm new in PostgreSQL and database .Now i'm researching about statistic correlation .I want to make a example with the table -assume that I have tbl_test table and two column - id & name - and do something to get correlation of a column is near 0 (zero).What ste

Re: [GENERAL] Correlation in pg_stats

2012-11-27 Thread classical_89
Thanks , i just want to get a correlation of near 0 to understand exactly what correlation , i quite ambiguity about this concept . / Statistical correlation between physical row ordering and logical ordering of the column values. This ranges from -1 to +1. When the value is near -1 or +1, an index

[GENERAL] Chang wal block size and database block size in Windows

2012-11-28 Thread classical_89
Hi everyone , I work with PostgreSQL on Windows XP . I want to ask you something .How can i change Postgres wal block size and database block size in Windows ?.I had tried search in postgresql.conf but seem these params not list in this file , i think it would be place at somewhere -- View this