Horton

Thread

  1. Re: Temporary Table

    Joshua D. Drake <jd@commandprompt.com> — 2005-11-08T02:10:38Z

    Christian Paul B. Cosinas wrote:
> I try to run this command in my linux server.
> VACUUM FULL pg_class;
> VACUUM FULL pg_attribute;
> VACUUM FULL pg_depend;
> 
> But it give me the following error:
> 	-bash: VACUUM: command not found

That needs to be run from psql ...

> 
> 
> 
> 
> 
> I choose Polesoft Lockspam to fight spam, and you?
> http://www.polesoft.com/refer.html    
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org

  2. Re: Temporary Table

    Christopher Kings-Lynne <chriskl@familyhealth.com.au> — 2005-11-08T02:14:45Z

    Ummm...they're SQL commands.  Run them in PostgreSQL, not on the unix 
command line...

Christian Paul B. Cosinas wrote:
> I try to run this command in my linux server.
> VACUUM FULL pg_class;
> VACUUM FULL pg_attribute;
> VACUUM FULL pg_depend;
> 
> But it give me the following error:
> 	-bash: VACUUM: command not found
> 
> 
> 
> 
> 
> I choose Polesoft Lockspam to fight spam, and you?
> http://www.polesoft.com/refer.html    
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org

  3. Re: Temporary Table

    Christopher Kings-Lynne <chriskl@familyhealth.com.au> — 2005-11-08T02:15:10Z

    > In what directory in my linux server will I find these 3 tables?

Directory?  They're tables in your database...

  4. Re: Temporary Table

    Jeff Frost <jeff@frostconsultingllc.com> — 2005-11-08T02:22:54Z

    You can use the vacuumdb external command.  Here's an example:

vacuumdb --full --analyze --table mytablename mydbname



On Tue, 8 Nov 2005, Christian Paul B. Cosinas wrote:

> But How Can I put this in the Cron of my Linux Server?
> I really don't have an idea :)
> What I want to do is to loop around all the databases in my server and
> execute the vacuum of these 3 tables in each tables.
>
> -----Original Message-----
> From: Joshua D. Drake [mailto:jd@commandprompt.com]
> Sent: Tuesday, November 08, 2005 2:11 AM
> To: Christian Paul B. Cosinas
> Cc: 'Alvaro Nunes Melo'; pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Temporary Table
>
> Christian Paul B. Cosinas wrote:
>> I try to run this command in my linux server.
>> VACUUM FULL pg_class;
>> VACUUM FULL pg_attribute;
>> VACUUM FULL pg_depend;
>>
>> But it give me the following error:
>> 	-bash: VACUUM: command not found
>
> That needs to be run from psql ...
>
>>
>>
>>
>>
>>
>> I choose Polesoft Lockspam to fight spam, and you?
>> http://www.polesoft.com/refer.html
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>>                http://archives.postgresql.org
>
>
> I choose Polesoft Lockspam to fight spam, and you?
> http://www.polesoft.com/refer.html
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

-- 
Jeff Frost, Owner 	<jeff@frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954

  5. Re: Temporary Table

    Christopher Kings-Lynne <chriskl@familyhealth.com.au> — 2005-11-08T02:24:20Z

    Or you could just run the 'vacuumdb' utility...

Put something like this in cron:

# Vacuum full local pgsql database
30 * * * *  postgres  vacuumdb -a -q -z

You really should read the manual.

Chris

Christian Paul B. Cosinas wrote:
> I see.
> 
> But How Can I put this in the Cron of my Linux Server?
> I really don't have an idea :)
> What I want to do is to loop around all the databases in my server and
> execute the vacuum of these 3 tables in each tables.
> 
> -----Original Message-----
> From: Joshua D. Drake [mailto:jd@commandprompt.com]
> Sent: Tuesday, November 08, 2005 2:11 AM
> To: Christian Paul B. Cosinas
> Cc: 'Alvaro Nunes Melo'; pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Temporary Table
> 
> Christian Paul B. Cosinas wrote:
> 
>>I try to run this command in my linux server.
>>VACUUM FULL pg_class;
>>VACUUM FULL pg_attribute;
>>VACUUM FULL pg_depend;
>>
>>But it give me the following error:
>>	-bash: VACUUM: command not found
> 
> 
> That needs to be run from psql ...
> 
> 
>>
>>
>>
>>
>>I choose Polesoft Lockspam to fight spam, and you?
>>http://www.polesoft.com/refer.html    
>>
>>
>>---------------------------(end of 
>>broadcast)---------------------------
>>TIP 4: Have you searched our list archives?
>>
>>               http://archives.postgresql.org
> 
> 
> 
> I choose Polesoft Lockspam to fight spam, and you?
> http://www.polesoft.com/refer.html    
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

  6. Re: Temporary Table

    Andrew McMillan <andrew@catalyst.net.nz> — 2005-11-08T02:35:20Z

    On Tue, 2005-11-08 at 10:22 +0000, Christian Paul B. Cosinas wrote:
> I see.
> 
> But How Can I put this in the Cron of my Linux Server?
> I really don't have an idea :)
> What I want to do is to loop around all the databases in my server and
> execute the vacuum of these 3 tables in each tables.

I usually write a small shell script something like:

==================================================
#!/bin/sh

psql somedatabase <<EOQ
  VACUUM this;
  VACUUM that;
  DELETE FROM someotherplace WHERE delete_this_record;
EOQ
==================================================

and so forth...

This makes the SQL quite nicely readable.


Regards,
					Andrew McMillan.

-------------------------------------------------------------------------
Andrew @ Catalyst .Net .NZ  Ltd,  PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/            PHYS: Level 2, 150-154 Willis St
DDI: +64(4)803-2201      MOB: +64(272)DEBIAN      OFFICE: +64(4)499-2267
            You work very hard.  Don't try to think as well.
-------------------------------------------------------------------------

  7. Re: Temporary Table

    Christian Paul Cosinas <cpc@cybees.com> — 2005-11-08T10:04:01Z

    In what directory in my linux server will I find these 3 tables?

-----Original Message-----
From: Alvaro Nunes Melo [mailto:al_nunes@atua.com.br]
Sent: Wednesday, October 26, 2005 10:49 AM
To: Christian Paul B. Cosinas
Subject: Re: [PERFORM] Temporary Table

Christian Paul B. Cosinas wrote:

>I am creating a temporary table in every function that I execute.
>Which I think is bout 100,000 temporary tables a day.
>  
>
I think that a lot. ;)

>What is the command for vacuuming these 3 tables?
>  
>
VACUUM FULL pg_class;
VACUUM FULL pg_attribute;
VACUUM FULL pg_depend;

I'm using this ones. Before using them, take a look in the size that this
tables are using in your HD, and compare to what you get after running this
commands.



I choose Polesoft Lockspam to fight spam, and you?
http://www.polesoft.com/refer.html

  8. Re: Temporary Table

    Christian Paul Cosinas <cpc@cybees.com> — 2005-11-08T10:09:00Z

    I try to run this command in my linux server.
VACUUM FULL pg_class;
VACUUM FULL pg_attribute;
VACUUM FULL pg_depend;

But it give me the following error:
	-bash: VACUUM: command not found





I choose Polesoft Lockspam to fight spam, and you?
http://www.polesoft.com/refer.html

  9. Re: Temporary Table

    Christian Paul Cosinas <cpc@cybees.com> — 2005-11-08T10:22:01Z

    I see.

But How Can I put this in the Cron of my Linux Server?
I really don't have an idea :)
What I want to do is to loop around all the databases in my server and
execute the vacuum of these 3 tables in each tables.

-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Tuesday, November 08, 2005 2:11 AM
To: Christian Paul B. Cosinas
Cc: 'Alvaro Nunes Melo'; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Temporary Table

Christian Paul B. Cosinas wrote:
> I try to run this command in my linux server.
> VACUUM FULL pg_class;
> VACUUM FULL pg_attribute;
> VACUUM FULL pg_depend;
> 
> But it give me the following error:
> 	-bash: VACUUM: command not found

That needs to be run from psql ...

> 
> 
> 
> 
> 
> I choose Polesoft Lockspam to fight spam, and you?
> http://www.polesoft.com/refer.html    
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org


I choose Polesoft Lockspam to fight spam, and you?
http://www.polesoft.com/refer.html