On Fri, 2 May 2008, PFC wrote:
CREATE TABLE derived AS SELECT ... FROM ... (perform all your derived
calculations here)
Given what you have said (that you really want all the data in one table)
it may be best to proceed like this:
First, take your original table, create an index on the prima
On Fri, May 2, 2008 at 4:51 PM, Alexy Khrabrov <[EMAIL PROTECTED]> wrote:
>
> On May 2, 2008, at 1:40 PM, Scott Marlowe wrote:
>
> > Again, a database protects your data from getting scrambled should the
> > program updating it quit halfway through etc...
> >
>
> Right -- but this is a data minin
[EMAIL PROTECTED] writes:
What version of Postgres you are running ?
8.2
If you are using 8.3, you can use pg_stat_all_tables.If Not you can use
http://www.postgresql.org/docs/current/static/pgstattuple.html>http://
www.postgresql.org/docs/current/static/pgstattuple.html
pgstattuple is al
Francisco Reyes wrote:
[EMAIL PROTECTED] writes:
What version of Postgres you are running ?
8.2
If you are using 8.3, you can use pg_stat_all_tables.If Not you can
use
http://www.postgresql.org/docs/current/static/pgstattuple.html>http://
www.postgresql.org/docs/current/static/pgstattuple
