On Wed, Feb 1, 2012 at 12:48 PM, Alessandro Gagliardi
wrote:
> LIMIT 65536; Total query runtime: 14846 ms.
> - http://explain.depesz.com/s/I3E
> LIMIT 69632: Total query runtime: 80141 ms.
> - http://explain.depesz.com/s/9hp
>
> So it looks like when the limit crosses a certain threshold (somewher
I created a table with two columns: an id SERIAL (primary key) and a
text (not null), and then added a unique index on the text field.
Then I ran the following query (with a huge work_mem - 20GB):
insert into tableA (text_field) select distinct other_text_field from
some_huge_set_of_tables
After
On Thu, Feb 2, 2012 at 6:52 AM, Merlin Moncure wrote:
> also, is effective_cache_size set to a reasonable value?
>
> Yeah, it's 153kB
On Thu, Feb 2, 2012 at 10:41 AM, Gudmundur Johannesson
wrote:
> Do you think I should try using the latest build of the source for 9.2 since
> index-only-scan is "ready" according to
> http://www.depesz.com/index.php/2011/10/08/waiting-for-9-2-index-only-scans/
> ?
hm, interesting.
You are simpl
On Thu, Feb 2, 2012 at 9:28 AM, Jon Nelson wrote:
> I created a table with two columns: an id SERIAL (primary key) and a
> text (not null), and then added a unique index on the text field.
> Then I ran the following query (with a huge work_mem - 20GB):
>
> insert into tableA (text_field) select di
