On Tue, Oct 17, 2017 at 3:22 AM, Andres Freund <and...@anarazel.de> wrote: > Hi Rafia, > > On 2017-05-19 17:25:38 +0530, Rafia Sabih wrote: >> head: >> explain analyse select * from t where i < 30000000; >> QUERY PLAN > > Could you share how exactly you generated the data? Just so others can > compare a bit better with your results? >
Sure. I used generate_series(1, 10000000); Please find the attached script for the detailed steps. -- Regards, Rafia Sabih EnterpriseDB: http://www.enterprisedb.com/
large_tbl_gen.sql
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers