From: | "rob" <rob(at)cabrion(dot)com> |
---|---|
To: | "Stephen Hardman" <support(at)crystal(dot)com(dot)au>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: help |
Date: | 2001-01-19 04:32:27 |
Message-ID: | 000d01c081d0$d52ef920$4100fd0a@cabrion.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Have you run 'vacuum analyze'?
--rob
----- Original Message -----
From: "Stephen Hardman" <support(at)crystal(dot)com(dot)au>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Tuesday, January 16, 2001 9:44 AM
Subject: help
> hi i have a database it was running but i ignored it so yes i deserve to
die
> it was running fine but now it chews all cpu through postmaster is there a
> way to delete the information contained in tables
> +------------------+----------------------------------+----------+
> | Owner | Relation | Type |
> +------------------+----------------------------------+----------+
> | ispdb | acl | table |
> | ispdb | acl_adminname_key | index |
> | ispdb | actions | table |
> | ispdb | actions_pkey | index |
> | ispdb | actionsall_key | index |
> | ispdb | bringups | table |
> | ispdb | bringups_by_userid | index |
> | ispdb | bringups_pkey | index |
> | ispdb | gst | table |
> | ispdb | gst_pkey | index |
> | ispdb | invoice | table |
> | ispdb | invoice_pkey | index |
> | ispdb | joinrequest | table |
> | ispdb | joinrequest_pkey | index |
> | ispdb | logins | table |
> | ispdb | logins_pkey | index |
> | ispdb | mailalias | table |
> | ispdb | mailalias_alias_key | index |
> | ispdb | mailalias_pkey | index |
> | ispdb | maxnums | table |
> | ispdb | netservers | table |
> | ispdb | onlineusers | table |
> | ispdb | plantype | table |
> | ispdb | plantype_pkey | index |
> | ispdb | prepaidhours | table |
> | ispdb | prepaidhours_pkey | index |
> | ispdb | retiredusers | table |
> | ispdb | retiredusers_pkey | index |
> | ispdb | supservices | table |
> | ispdb | supservices_pkey | index |
> | ispdb | usagesummary | table |
> | ispdb | usagesummary_pkey | index |
> | ispdb | userbilling | table |
> | ispdb | userbilling_pkey | index |
> | ispdb | userprofile | table |
> | ispdb | userprofile_pkey | index |
> | ispdb | userprofile_username_key | index |
> +------------------+----------------------------------+----------+
> to remove all the info in the big nes
> i know i am a idiot but trying to learn
> thanks
> stephen hardman
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | ashley | 2001-01-19 04:46:08 | Front End |
Previous Message | Tom Lane | 2001-01-19 02:27:08 | Re: Argh! What's a 'bpchar'? (copy/serial issues...I think) |