Re: [PERFORM]

2017-06-28 Thread Brad DeJong
On 2017-06-28, Pavel Stehule wrote ... > On 2017-06-28, Yevhenii Kurtov wrote ... >> On 2017-06-28, Pavel Stehule wrote ... >>> On 2017-06-28, Yevhenii Kurtov wrote ... We have a query that is run almost each second and it's very important to squeeze every other ms out of it. The query

Re: [PERFORM] Optimizing around retained tuples

2017-03-24 Thread Brad DeJong
On Tue, Mar 21, 2017 at 4:24 PM, James Parks wrote: > What can I do to keep running long maintenance operations on large > tables (SELECTing significant fractions of B, DELETEing significant > fractions of B, running VACUUM FULL on B) without denying other > Postgresql backends their ability to ef