Re: [HACKERS] select statement against pg_stats returns inconsistent data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Joe Conway <mail(at)joeconway(dot)com>, Shelby Cain <alyandon(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] select statement against pg_stats returns inconsistent data
Date: 2004-02-25 04:15:26
Message-ID: 328.1077682526@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> Has anyone given any thought as to whether dumping and restoring
> pg_statistic is worthwhile?

Why? You can reconstruct it with a simple "ANALYZE" command. Dumping
and restoring would mean nailing down cross-version assumptions about
what it contains, which doesn't seem real forward-looking...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-02-25 04:37:11 Re: [GENERAL] select statement against pg_stats returns
Previous Message Humble Geek 2004-02-25 04:11:37 PLSQL Question regarding multiple inserts

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin Sherry 2004-02-25 04:21:57 Re: bgwriter never dies
Previous Message Christopher Kings-Lynne 2004-02-25 04:07:20 Re: [HACKERS] select statement against pg_stats returns