Re: [ADMIN] Auto Vacuum not starting unless postgres is restarted

2006-09-15 Thread Nick Howden
iptables -A OUTPUT -p tcp \ --dport 1024:65535 \ --sport 5432 \ -m state --state ESTABLISHED,RELATED \ -j ACCEPT but these should be the same both during boot and after the boot process has finished Nick -- Nick Howden - Senior IT Analyst QinetiQ Trusted Infor

[ADMIN] Auto Vacuum not starting unless postgres is restarted

2006-09-15 Thread Nick Howden
a what the problem might be? Postgres Version: 8.1.4 OS: Ubuntu Linux 6.0.6 Thanks Nick -- Nick Howden - Senior IT Analyst QinetiQ Trusted Information Management Woodward Building, Room B009 Malvern Technology Park, WR14 3PS Telephone 01684 895566, Fax 896660 The Information contained in this

[ADMIN] Auto Vacuum not starting unless postgres is restarted

2006-09-15 Thread Nick Howden
a what the problem might be? Postgres Version: 8.1 OS: Ubuntu Linux 6.0.6 -- Nick Howden - Senior IT Analyst QinetiQ Trusted Information Management Woodward Building, Room B009 Malvern Technology Park, WR14 3PS Telephone 01684 895566, Fax 896660 The Information contained in this E-Mail and any

[ADMIN] unsubscribe

2006-03-13 Thread Nick Howden
unsubscribe ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[ADMIN] Is is possible to persuade the query planner that ~* operations are grossly expensive?

2002-12-17 Thread Nick Howden
rows this is very slow. So, can I force the query optimizer to delay doing the ~* until after the selective joins? -- Nick Howden - Senior IT Analyst QinetiQ Trusted Information Management Woodward Building, Room B009 Malvern Technology Park, WR14 3PS Telephone 01684 895566, Fax 896660 The I