[HACKERS] pg_autovacuum bug and feature request

2003-07-04 Thread Vincent van Leeuwen
ge tables can be totally ignored by pg_autovacuum in my setup. As you can see from the weird -t and -T parameters I already tried to make it favor those smaller tables (which get about the same amount of updates as the large tables), but I'm not quite sure I'm doing it the right way. Rega

Re: [HACKERS] Detecting corrupted pages earlier

2003-04-03 Thread Vincent van Leeuwen
On 2003-04-03 18:40:54 -0500, Tom Lane wrote: > Vincent van Leeuwen <[EMAIL PROTECTED]> writes: > > ... This cost us about 10 hours downtime. If I'd had the option I just > > would've set ZERO_DAMAGED_PAGES to true and let it run for a few days to sort > > its

Re: [HACKERS] Detecting corrupted pages earlier

2003-04-03 Thread Vincent van Leeuwen
t remains that I actually have a real-life situation where running (for a while at least) with ZERO_DAMAGED_PAGES on makes some kind of sense. Vincent van Leeuwen Media Design - http://www.mediadesign.nl/ ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Hard problem with concurrency

2003-02-19 Thread Vincent van Leeuwen
s kind of functionality in PG, I've got a database that caches data which only gets conditional INSERT/UPDATEs, so that would save a lot of wasted SQL commands. Vincent van Leeuwen Media Design ---(end of broadcast)--- TIP 2: you can