[PERFORM] Why I lost the last pg_xlog file?

? How is the correctly way to perform a recovery in this case? Thanks, Waldomiro Caraiani -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] Server Freezing

bgwriter_lru_maxpages=5 bgwriter_lru_percent=1 fsync=on full_page_writes=on stats_block_level=on stats_command_string=on stats_reset_on_server_start=off stats_row_level=on stats_start_collector=on Waldomiro Fernando Hevia escreveu: -Mensaje original- De: pgsql-performance-ow...@postgresql.org

Re: [PERFORM] Server Freezing

I´m using PostgreSQL 8.1. There is a way to see that? Waldomiro Greg Smith escreveu: Waldomiro wrote: Is It possible the checkpoint is doing that? Or the archiving? How can I see? If you're using PostgreSQL 8.3 or later, you can turn on log_checkpoints and you'll get a note

[PERFORM] Server Freezing

? Or the archiving? How can I see? Someone have any idea? Thank you Waldomiro Caraiani -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] Too much blocks read

here is not, I think it´s a good idea for the next versions. Thank you, Waldomiro Caraiani -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] query planning different in plpgsql?

query like this: SELECT field, field2 ... FROM table1 WHERE trim(field3) = 'xxx' AND field4 = 'yyy' AND trim(field5) = 'zzz' I  didn´t give any option to the planner, so I get what plan I want. Waldomiro Tom Lane escreveu: "Michal J. Kubski" wri

[PERFORM] There is a statistic table?

keep more data in cache? Thanks, Waldomiro -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] INSERT OU UPDATE WITHOUT SELECT?

Hi, Is there a command to Insert a record If It does not exists and a update if It exists? I do not want to do a select before a insert or update. I mean the postgres should test if a record exist before insert and if It exist then the postgres must do an update instead an insert. Thanks,