pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhow can i UPDATE without dead rows
2+ messages / 2 participants
[nested] [flat]
* how can i UPDATE without dead rows
@ 2005-06-17 13:08 csepinek@freemail.hu
2005-06-17 16:09 ` Re: how can i UPDATE without dead rows Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 2+ messages in thread
From: csepinek@freemail.hu @ 2005-06-17 13:08 UTC (permalink / raw)
To: pgsql-sql
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<STYLE type="text/css"><!--
BODY {
margin: 5px 5px 5px 5px;
background-color: #FFFFFF;
}
/*----------Text Styles----------*/
HR { color: #000000}
BODY, TABLE /* Normal text */
{
font-size: 9pt;
font-family: 'Courier New';
font-style: normal;
font-weight: normal;
color: #000000;
text-decoration: none;
}
SPAN.RVTS1 /* Heading */
{
font-size: 10pt;
font-family: 'Arial';
font-weight: bold;
color: #0000FF;
}
SPAN.RVTS2 /* Subheading */
{
font-size: 10pt;
font-family: 'Arial';
font-weight: bold;
color: #000080;
}
SPAN.RVTS3 /* Keywords */
{
font-size: 10pt;
font-family: 'Arial';
font-style: italic;
color: #800000;
}
A.RVTS4, SPAN.RVTS4 /* Jump 1 */
{
font-size: 10pt;
font-family: 'Arial';
color: #008000;
text-decoration: underline;
}
A.RVTS5, SPAN.RVTS5 /* Jump 2 */
{
font-size: 10pt;
font-family: 'Arial';
color: #008000;
text-decoration: underline;
}
SPAN.RVTS6
{
font-size: 8pt;
font-family: 'arial';
font-style: italic;
color: #C0C0C0;
}
A.RVTS7, SPAN.RVTS7
{
font-size: 8pt;
font-family: 'arial';
color: #0000FF;
text-decoration: underline;
}
/*----------Para Styles----------*/
P,UL,OL /* Paragraph Style */
{
text-align: left;
text-indent: 0px;
padding: 0px 0px 0px 0px;
margin: 0px 0px 0px 0px;
}
.RVPS1 /* Centered */
{
text-align: center;
white-space: normal;
}
--></STYLE>
</HEAD>
<BODY>
<P>Hi!</P>
<P><BR></P>
<P>My program must use UPDATE usualy, and there will be many dead rows in this table </P>
<P>what throttle down the db server. I would like to update so not create dead row.</P>
<P>How can i do this?</P>
<P><BR></P>
<P>sorry for my english :)</P>
<P><A class=RVTS7 href="mailto:csepinek@freemail.hu"><BR></A></P>
</BODY></HTML>
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: how can i UPDATE without dead rows
2005-06-17 13:08 how can i UPDATE without dead rows csepinek@freemail.hu
@ 2005-06-17 16:09 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 2+ messages in thread
From: Richard Huxton @ 2005-06-17 16:09 UTC (permalink / raw)
To: csepinek@freemail.hu; +Cc: pgsql-sql
csepinek@freemail.hu wrote:
> Hi!
>
>
> My program must use UPDATE usualy, and there will be many dead rows in this table
> what throttle down the db server. I would like to update so not create dead row.
> How can i do this?
You can't - that's how MVCC works. Make sure your free-space-map
settings are large enough in postgresql.conf and that you vacuum enough
- that will keep the "dead" space being re-used.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-06-17 16:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-17 13:08 how can i UPDATE without dead rows csepinek@freemail.hu
2005-06-17 16:09 ` Richard Huxton <dev@archonet.com>
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