| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Guido Barosio <gbarosio(at)sinectis(dot)com(dot)ar> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Strange scenary. |
| Date: | 2004-07-08 16:46:46 |
| Message-ID: | 20040708093450.B95902@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sat, 3 Jul 2004, Guido Barosio wrote:
> Hi,
>
> This is the problem. I create a database from cero. I create a empty table, name students. I ask for an EXPLAIN
> on this new table, and the output of the query analyzer tells me that this table is filled with 1000 rows.
>
> So...why is that?
That's the default value set for the estimated number of rows; that row
count is the estimated rows based on the statistics not the actual
number of rows returned (see EXPLAIN ANALYZE's second set of numbers
for each step for that information) and you haven't run analyze to give it
more accurate statistics.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2004-07-08 16:47:36 | Re: Connect to postgres from a script using password |
| Previous Message | Devrim GUNDUZ | 2004-07-08 16:44:09 | Re: Connect to postgres from a script using password |