Re: [ADMIN] 8.x Vaccum/Autovacuum settings

2006-06-25 Thread Dawid Kuroczko
On 6/25/06, Chris Hoover <[EMAIL PROTECTED]> wrote: Just curious,What are most of you setting your vacuum and autovacuum parameters to for your 8.x databases.  I just turned on autovacuuming on one of my db servers and went with a very conservative vacuum_cost_delay of 200 and vacuum_cost_limit of

Re: [ADMIN] Is it possible to trace all transactions done?

2006-06-25 Thread kah_hang_ang
Depesz, Thanks, this is I what I need. After I enable the log_statement Postgresql do log the statements triggered but I need more detail info. - time the statements been triggered to be log as well, is it any way to do that? Regards, KH Ang

Re: [ADMIN] Is it possible to trace all transactions done?

2006-06-25 Thread Tom Lane
[EMAIL PROTECTED] writes: > After I enable the log_statement Postgresql do log the statements triggered > but I need more detail info. - time the statements been triggered to be log > as well, In recent PG releases you set log_line_prefix to add whatever you want to log entries. Older versions ar

[ADMIN] TSearch2

2006-06-25 Thread Sidar López Cruz
How to add a spanish dictionary on tsearch2 on windows pg server !!!  Las mejores tiendas, los precios mas bajos, entregas en todo el mundo, YupiMSN Compras: Haz clic aquí...