Re: TABLESAMPLE patch - Mailing list pgsql-hackers

From Petr Jelinek
Subject Re: TABLESAMPLE patch
Date
Msg-id 5492C521.203@2ndquadrant.com
Whole thread Raw
In response to Re: TABLESAMPLE patch  (Petr Jelinek <petr@2ndquadrant.com>)
Responses Re: TABLESAMPLE patch  (Tomas Vondra <tv@fuzzy.cz>)
Re: TABLESAMPLE patch  (Jaime Casanova <jaime@2ndquadrant.com>)
List pgsql-hackers
Hi,

v2 version of this patch is attached.


On 16/12/14 09:31, Petr Jelinek wrote:
> On 16/12/14 08:43, Jaime Casanova wrote:
>>
>> Sadly when the jsonb functions patch was committed a few oids where
>> used, so you should update the ones you are using. at least to make
>> the patch easier for testing.
>
> Will do.

Done.

>>
>> The test added for this failed, attached is the diff. i didn't looked
>> up why it failed
>>
>
> It isn't immediately obvious to me why, will look into it.

Fixed.

>
>> Finally, i created a view with a tablesample clause. i used the view
>> and the tablesample worked, then dumped and restored and the
>> tablesample clause went away... actually pg_get_viewdef() didn't see
>> it at all.
>>
>
> Yeah, as I mentioned in the submission the ruleutils support is not
> there yet, so that's expected.
>

Also fixed.

I also added proper costing/row estimation. I consider this patch
feature complete now, docs could still use improvement though.

--
  Petr Jelinek                  http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: pgbench -f and vacuum
Next
From: Fujii Masao
Date:
Subject: Re: Add generate_series(numeric, numeric)