Re: add_path optimization - Mailing list pgsql-hackers

From Tom Lane
Subject Re: add_path optimization
Date
Msg-id 18073.1233633295@sss.pgh.pa.us
Whole thread Raw
In response to Re: add_path optimization  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: add_path optimization  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I'm interested, but I need maybe a 1GB data set, or smaller.  The
> thing that we are benchmarking is the planner, and planning times are
> related to the complexity of the database and the accompanying
> queries, not the raw volume of data.

In fact, the only reason to care whether there is any data in the DB
*at all* is that you need some realistic content in pg_statistic.
So it should be possible to set up a planner test DB with very little
data bulk, which would surely make testing a lot less painful.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: add_path optimization
Next
From: KaiGai Kohei
Date:
Subject: Re: How to get SE-PostgreSQL acceptable