[PERFORM] queries on huge tables

2005-03-17 Thread Lending, Rune
Title: Melding Hello all.   I am having a couple of tables with couple of hundre millions records in them. The tables contains a timestamp column. I am almost always interested in getting datas from a specific day or month. Each day contains aprox. 400.000 entries.   When I do such querie

[PERFORM] pg_autovacuum parameters

2004-08-03 Thread Lending, Rune
Title: Melding Hello all.   I am managing a large database with lots of transactions in different tables. The largest tables have around 5-6 millions tuples and around 5-6 inserts and maybe 2 updates pr day. While the smalest tables have only a few tuples and a few updates /ins