how can i UPDATE without dead rows

From: csepinek(at)freemail(dot)hu
To: pgsql-sql(at)postgresql(dot)org
Subject: how can i UPDATE without dead rows
Date: 2005-06-17 13:08:31
Message-ID: 664932514.20050617150831@freemail.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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&nbsp;</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(at)freemail(dot)hu"><BR></A></P>

</BODY></HTML>

Attachment Content-Type Size
unknown_filename text/html 1.8 KB

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bricklen Anderson 2005-06-17 14:54:19 Re: UPDATEABLE VIEWS ... Examples?
Previous Message Michael Fuhr 2005-06-17 12:06:56 Re: substr or char_length problem