pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [INTERFACES] table very big !!!!!
8+ messages / 6 participants
[nested] [flat]
* table very big !!!!!
@ 1999-11-22 17:33 Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>
1999-11-22 18:00 ` Re: [INTERFACES] table very big !!!!! Hannu Krosing <hannu@tm.ee>
1999-11-22 19:40 ` Re: [INTERFACES] table very big !!!!! Peter Mount <peter@retep.org.uk>
0 siblings, 2 replies; 8+ messages in thread
From: Pablo Salazar Loaiza @ 1999-11-22 17:33 UTC (permalink / raw)
To: pgsql-interfaces
Hello all
I have a DB in Postgres, and i have one application that work with this
DB, and exist one table where dialy is writing register in this table,
but to midnigth , i do delete from table.
But the size always is growing.
Thanks in advance
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] table very big !!!!!
1999-11-22 17:33 table very big !!!!! Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>
@ 1999-11-22 18:00 ` Hannu Krosing <hannu@tm.ee>
1 sibling, 0 replies; 8+ messages in thread
From: Hannu Krosing @ 1999-11-22 18:00 UTC (permalink / raw)
To: Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>; +Cc: pgsql-interfaces
Pablo Salazar Loaiza wrote:
>
> Hello all
>
> I have a DB in Postgres, and i have one application that work with this
> DB, and exist one table where dialy is writing register in this table,
> but to midnigth , i do delete from table.
>
> But the size always is growing.
>
You should run the database command
>analyze;
that will get rid of old tuples that are no longer used
--------------
Hannu
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] table very big !!!!!
1999-11-22 17:33 table very big !!!!! Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>
@ 1999-11-22 19:40 ` Peter Mount <peter@retep.org.uk>
1999-11-22 10:20 ` Re: [INTERFACES] table very big !!!!! Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>
1 sibling, 1 reply; 8+ messages in thread
From: Peter Mount @ 1999-11-22 19:40 UTC (permalink / raw)
To: Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>; +Cc: pgsql-interfaces
On Mon, 22 Nov 1999, Pablo Salazar Loaiza wrote:
> Hello all
>
> I have a DB in Postgres, and i have one application that work with this
> DB, and exist one table where dialy is writing register in this table,
> but to midnigth , i do delete from table.
>
> But the size always is growing.
Are you running a vacuum after the delete?
Peter
--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] table very big !!!!!
1999-11-22 17:33 table very big !!!!! Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>
1999-11-22 19:40 ` Re: [INTERFACES] table very big !!!!! Peter Mount <peter@retep.org.uk>
@ 1999-11-22 10:20 ` Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>
1999-11-22 20:37 ` Re: [INTERFACES] table very big !!!!! Peter Mount <peter@retep.org.uk>
1999-11-23 13:17 ` Re: [INTERFACES] table very big !!!!! Hiroshi Inoue <Inoue@tpf.co.jp>
0 siblings, 2 replies; 8+ messages in thread
From: Pablo Saul Salazar - CESERCOMP @ 1999-11-22 10:20 UTC (permalink / raw)
To: Peter Mount <peter@retep.org.uk>; +Cc: pgsql-interfaces
Yes, i have a C program that first do delete and after run command vacuum
analyze, but this command dont do nothing, because the size the table
grow
another solutions!!! ???
Thanks
Pablo Salazar Loaiza
Asistente de Redes
CESERCOMP-ESPOL
On Mon, 22 Nov 1999, Peter Mount wrote:
> On Mon, 22 Nov 1999, Pablo Salazar Loaiza wrote:
>
> > Hello all
> >
> > I have a DB in Postgres, and i have one application that work with this
> > DB, and exist one table where dialy is writing register in this table,
> > but to midnigth , i do delete from table.
> >
> > But the size always is growing.
>
> Are you running a vacuum after the delete?
>
> Peter
>
> --
> Peter T Mount peter@retep.org.uk
> Main Homepage: http://www.retep.org.uk
> PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
> Java PDF Generator: http://www.retep.org.uk/pdf
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] table very big !!!!!
1999-11-22 17:33 table very big !!!!! Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>
1999-11-22 19:40 ` Re: [INTERFACES] table very big !!!!! Peter Mount <peter@retep.org.uk>
1999-11-22 10:20 ` Re: [INTERFACES] table very big !!!!! Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>
@ 1999-11-22 20:37 ` Peter Mount <peter@retep.org.uk>
1999-11-23 00:06 ` Re: [INTERFACES] table very big !!!!! Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 8+ messages in thread
From: Peter Mount @ 1999-11-22 20:37 UTC (permalink / raw)
To: Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>; +Cc: pgsql-interfaces
On Mon, 22 Nov 1999, Pablo Saul Salazar - CESERCOMP wrote:
> Yes, i have a C program that first do delete and after run command vacuum
> analyze, but this command dont do nothing, because the size the table
> grow
Ah, try running first vacuum; then vacuum analyze. The first one will
truncate the table removing the wasted space. The second simply rebuilds
some statistics about the table.
Peter
>
> another solutions!!! ???
>
> Thanks
>
>
> Pablo Salazar Loaiza
> Asistente de Redes
> CESERCOMP-ESPOL
>
>
> On Mon, 22 Nov 1999, Peter Mount wrote:
>
> > On Mon, 22 Nov 1999, Pablo Salazar Loaiza wrote:
> >
> > > Hello all
> > >
> > > I have a DB in Postgres, and i have one application that work with this
> > > DB, and exist one table where dialy is writing register in this table,
> > > but to midnigth , i do delete from table.
> > >
> > > But the size always is growing.
> >
> > Are you running a vacuum after the delete?
> >
> > Peter
> >
> > --
> > Peter T Mount peter@retep.org.uk
> > Main Homepage: http://www.retep.org.uk
> > PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
> > Java PDF Generator: http://www.retep.org.uk/pdf
> >
> >
>
--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] table very big !!!!!
1999-11-22 17:33 table very big !!!!! Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>
1999-11-22 19:40 ` Re: [INTERFACES] table very big !!!!! Peter Mount <peter@retep.org.uk>
1999-11-22 10:20 ` Re: [INTERFACES] table very big !!!!! Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>
1999-11-22 20:37 ` Re: [INTERFACES] table very big !!!!! Peter Mount <peter@retep.org.uk>
@ 1999-11-23 00:06 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-11-23 06:53 ` Re: [INTERFACES] table very big !!!!! Peter Mount <peter@retep.org.uk>
0 siblings, 1 reply; 8+ messages in thread
From: Tom Lane @ 1999-11-23 00:06 UTC (permalink / raw)
To: Peter Mount <peter@retep.org.uk>; +Cc: Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>; pgsql-interfaces
Peter Mount <peter@retep.org.uk> writes:
> Ah, try running first vacuum; then vacuum analyze. The first one will
> truncate the table removing the wasted space. The second simply rebuilds
> some statistics about the table.
This is not right --- AFAICT, vacuum *always* runs the compaction phase.
You can allow or skip the stats-gathering phase by specifying "analyze"
or not, but "vacuum analyze" implies "vacuum".
It sounds like Pablo has a problem with vacuum not doing what it is
supposed to ... has anyone else ever seen that? It's a new one on me.
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] table very big !!!!!
1999-11-22 17:33 table very big !!!!! Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>
1999-11-22 19:40 ` Re: [INTERFACES] table very big !!!!! Peter Mount <peter@retep.org.uk>
1999-11-22 10:20 ` Re: [INTERFACES] table very big !!!!! Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>
1999-11-22 20:37 ` Re: [INTERFACES] table very big !!!!! Peter Mount <peter@retep.org.uk>
1999-11-23 00:06 ` Re: [INTERFACES] table very big !!!!! Tom Lane <tgl@sss.pgh.pa.us>
@ 1999-11-23 06:53 ` Peter Mount <peter@retep.org.uk>
0 siblings, 0 replies; 8+ messages in thread
From: Peter Mount @ 1999-11-23 06:53 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>; pgsql-interfaces
On Mon, 22 Nov 1999, Tom Lane wrote:
> Peter Mount <peter@retep.org.uk> writes:
> > Ah, try running first vacuum; then vacuum analyze. The first one will
> > truncate the table removing the wasted space. The second simply rebuilds
> > some statistics about the table.
>
> This is not right --- AFAICT, vacuum *always* runs the compaction phase.
> You can allow or skip the stats-gathering phase by specifying "analyze"
> or not, but "vacuum analyze" implies "vacuum".
Thanks for the correction. I've always run both myself, hence the answer.
Peter
--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [INTERFACES] table very big !!!!!
1999-11-22 17:33 table very big !!!!! Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>
1999-11-22 19:40 ` Re: [INTERFACES] table very big !!!!! Peter Mount <peter@retep.org.uk>
1999-11-22 10:20 ` Re: [INTERFACES] table very big !!!!! Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>
@ 1999-11-23 13:17 ` Hiroshi Inoue <Inoue@tpf.co.jp>
1 sibling, 0 replies; 8+ messages in thread
From: Hiroshi Inoue @ 1999-11-23 13:17 UTC (permalink / raw)
To: Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>; +Cc: Peter Mount <peter@retep.org.uk>; pgsql-interfaces
Pablo Saul Salazar - CESERCOMP wrote:
>
> Yes, i have a C program that first do delete and after run command vacuum
> analyze, but this command dont do nothing, because the size the table
> grow
>
> another solutions!!! ???
>
Are there any pending transactions ?
If a very old transaction is alive,vacuum never
remove deleted tuples.
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~1999-11-23 13:17 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-11-22 17:33 table very big !!!!! Pablo Salazar Loaiza <ssalazar@goliat.espol.edu.ec>
1999-11-22 18:00 ` Hannu Krosing <hannu@tm.ee>
1999-11-22 19:40 ` Peter Mount <peter@retep.org.uk>
1999-11-22 10:20 ` Pablo Saul Salazar - CESERCOMP <ssalazar@goliat.espol.edu.ec>
1999-11-22 20:37 ` Peter Mount <peter@retep.org.uk>
1999-11-23 00:06 ` Re: [INTERFACES] table very big !!!!! Tom Lane <tgl@sss.pgh.pa.us>
1999-11-23 06:53 ` Re: [INTERFACES] table very big !!!!! Peter Mount <peter@retep.org.uk>
1999-11-23 13:17 ` Hiroshi Inoue <Inoue@tpf.co.jp>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox