Re: help
От | rob |
---|---|
Тема | Re: help |
Дата | |
Msg-id | 000d01c081d0$d52ef920$4100fd0a@cabrion.org обсуждение исходный текст |
Ответ на | help ("Stephen Hardman" <support@crystal.com.au>) |
Список | pgsql-novice |
Have you run 'vacuum analyze'? --rob ----- Original Message ----- From: "Stephen Hardman" <support@crystal.com.au> To: <pgsql-novice@postgresql.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 > > >
В списке pgsql-novice по дате отправления: