Csaba Nagy nagy at ecircle-ag.com
Wed Jul 4 08:29:11 PDT 2007
On Wed, 2007-07-04 at 17:13, Christopher Browne wrote:
> Interestingly, the query plans for 100 and 1000 are much the same:
> 
> -  Bitmap Heap Scan on foo atop
>     100 (or 1000) ORed Bitmap Index Scans.
> 
> I was fully expecting to discover some differing query plan; it was 
> quite a surprise to discover both:
> 
> a) That the plans were essentially identical, and
> b) That it's more expensive to delete 1K tuples at a shot than 100.

OK, that surprises me too... and it would be interesting to know why is
that so ? It is completely counterintuitive...

Cheers,
Csaba.




More information about the Slony1-general mailing list