Re: Really really slow select count(*) - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Really really slow select count(*)
Date
Msg-id AANLkTi=BOpBe_23dqTqq7rKiP7H-0cGtVx-4+8n8LbJ5@mail.gmail.com
Whole thread Raw
In response to Re: Really really slow select count(*)  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-performance
On Tue, Feb 8, 2011 at 3:08 PM, Greg Smith <greg@2ndquadrant.com> wrote:
> Scott Marlowe wrote:
>>
>> Are there any settings in postgresql.conf that would make it unsafe to
>> use -m immediate?
>>
>
> Two concerns:
>
> -Clients will be killed without any review, and data related to them lost
>
> -The server will have to go through recovery to start back up again, which
> could potentially take a long time.  If you manage a successful shutdown
> that doesn't happen.
>
> Shouldn't be unsafe, just has those issues.

Good, I was kinda worried about full_page_writes being off or fsync or
something like that being a problem.

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Really really slow select count(*)
Next
From: Dave Crooke
Date:
Subject: Re: Bad query plan when the wrong data type is used