Re: Sequencial scan instead of using index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "markir@xxxxxxxxxxxxxxx" <markir@xxxxxxxxxxxxxxx>
Subject: Re: Sequencial scan instead of using index
From: markir@xxxxxxxxxxxxxxx
Date: Wed, 12 Apr 2006 10:20:55 +1200 (NZST)
Cc: Harry Hehl <Harry.Hehl@xxxxxxxxxxxxxx>, Mark Kirkwood <markir@xxxxxxxxxxxxxxx>, "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <1144793874.443c2b1272c80@xxxxxxxxxxxxxxxxxxx>
References: <6AD4F3A63B017C4FB074E2C895AD18541090C6@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> <1144793874.443c2b1272c80@xxxxxxxxxxxxxxxxxxx>
User-agent: IMP/PHP IMAP webmail program 2.2.7

Quoting "markir@xxxxxxxxxxxxxxx" <markir@xxxxxxxxxxxxxxx>:


> Hmm - that first query needs to do a sort, so you might want to
> experiment with
> the sort_mem parameter

Oops - I mean work_mem...

References:
- Re: Sequencial scan instead of using index
  - From: Harry Hehl
- Re: Sequencial scan instead of using index
  - From: markir

Prev by Date: Re: Sequencial scan instead of using index
Next by Date: Re: Sequencial scan instead of using index
Previous by thread: Re: Sequencial scan instead of using index
Next by thread: Re: Sequencial scan instead of using index
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux