On Monday, August 26, 2013, Rafael Martinez wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hello
>
> We have a SQL statement that with 9.1 takes ca 4000ms to finnish and
> with 9.2 over 22000ms.
>
> The explain analyze information is here:
>
Could you do explain (analyze, buffers) o
Hi,
On 27.8.2013 06:06, Adam Ma'ruf wrote:
> Hi
>
> Thanks for the response. I reran the query but first ran the statement
> you provided and set working mem to 2gb. It ended up taking 133s and
> group aggregate was still used
OK.
>
> Here are the values you asked for:
> # - Planner Method C
On 27.8.2013 11:19, Rafael Martinez wrote:
> On 08/26/2013 02:33 PM, Rafael Martinez wrote:
> []
>> The SQL statement is:
>
>> SELECT firstname || ' ' || lastname AS Name FROMPerson R WHERE
>> R.gender like 'F' AND 19 < (SELECT COUNT(DISTINCT filmId) FROM
>> FilmParticipation F W
On Tue, Aug 27, 2013 at 10:55 AM, Andres Freund wrote:
> On 2013-08-27 09:57:38 -0500, Merlin Moncure wrote:
>> + bool
>> + RecoveryMightBeInProgress(void)
>> + {
>> + /*
>> + * We check shared state each time only until we leave recovery mode.
>> We
>> + * can't re-enter recovery,
On 2013-08-27 09:57:38 -0500, Merlin Moncure wrote:
> + bool
> + RecoveryMightBeInProgress(void)
> + {
> + /*
> + * We check shared state each time only until we leave recovery mode. We
> + * can't re-enter recovery, so there's no need to keep checking after
> the
> + * shared v
On Tue, Aug 27, 2013 at 9:12 AM, Merlin Moncure wrote:
> Something like the attached. Note, this patch is for research
> purposes only and should *not* be applied to your production
> environment.
Here is a revised version that is missing the spurious whitespace edit.
merlin
recovery2.patch
D
On Tue, Aug 27, 2013 at 8:38 AM, Merlin Moncure wrote:
> On Tue, Aug 27, 2013 at 8:23 AM, Merlin Moncure wrote:
>> It looks like you're hitting spinlock connection inside
>> heap_page_prune_opt(). Which is commented:
>> * Note: this is called quite often. It's important that it fall out quickl
On Tue, Aug 27, 2013 at 8:23 AM, Merlin Moncure wrote:
> It looks like you're hitting spinlock connection inside
> heap_page_prune_opt(). Which is commented:
> * Note: this is called quite often. It's important that it fall out quickly
> * if there's not any use in pruning.
>
> This in turn ca
On Tue, Aug 27, 2013 at 2:57 AM, Дмитрий Дегтярёв wrote:
> Hello.
>
> Exist 2 identical server DELL PowerEdge™ R720, CPU Dual Intel® Xeon® E5-2620
> Hexa-Core inkl, RAM 256Gb, RAID-10 8 x 600 GB SAS 6 Gb/s 15000 rpm.
>
> $ cat /etc/fedora-release
> Fedora release 19
>
> $ postgres --version
> post
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/26/2013 02:33 PM, Rafael Martinez wrote:
[]
> The SQL statement is:
>
> SELECT firstname || ' ' || lastname AS Name FROMPerson R WHERE
> R.gender like 'F' AND 19 < (SELECT COUNT(DISTINCT filmId) FROM
> FilmParticipation F WHERE
Hello.
Exist 2 identical server DELL PowerEdge™ R720, CPU Dual Intel® Xeon®
E5-2620 Hexa-Core inkl, RAM 256Gb, RAID-10 8 x 600 GB SAS 6 Gb/s 15000 rpm.
$ cat /etc/fedora-release
Fedora release 19
$ postgres --version
postgres (PostgreSQL) 9.2.4
Data ~220Gb and Indexes ~140Gb
iowait ~0.2-0.5. D
11 matches
Mail list logo
