Re: poor pefrormance with regexp searches on large tables - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: poor pefrormance with regexp searches on large tables
Date
Msg-id 4E427819020000250003FD57@gw.wicourts.gov
Whole thread Raw
In response to Re: poor pefrormance with regexp searches on large tables  (Grzegorz Blinowski <g.blinowski@gmail.com>)
List pgsql-performance
Grzegorz Blinowski <g.blinowski@gmail.com> wrote:

> autovacuum                | off

BTW, that's generally not a good idea -- it leaves you much more
vulnerable to bloat which could cause performance problems to
manifest in any number of ways.  You might want to calculate your
heap bloat on this table.

-Kevin

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Autovacuum running out of memory
Next
From: "Kevin Grittner"
Date:
Subject: Re: poor pefrormance with regexp searches on large tables