Thanks to all for time and valuable help,
Pavel Rotek
2008/3/7, Bill Moran <[EMAIL PROTECTED]>:
>
> In response to "Pavel Rotek" <[EMAIL PROTECTED]>:
>
>
> > 2008/3/7, Tom Lane <[EMAIL PROTECTED]>:
>
>
> [snip]
>
>
> > > If y
2008/3/7, Matthew <[EMAIL PROTECTED]>:
>
> On Fri, 7 Mar 2008, Pavel Rotek wrote:
> > well, this will be the main problem... But... do uncomitted trasactions
> > affect toast space?
>
>
> I think the demonstrated answer to this is yes.
>
>
> > (be
2008/3/7, Matthew <[EMAIL PROTECTED]>:
>
> > "Pavel Rotek" <[EMAIL PROTECTED]> writes:
> >> No i do not mean long running transactions... Update of log entry
> (update of
> >> row in dataaction) is performed in series of short transactions, b
2008/3/7, Tom Lane <[EMAIL PROTECTED]>:
>
> "Pavel Rotek" <[EMAIL PROTECTED]> writes:
> > No i do not mean long running transactions... Update of log entry
> (update of
> > row in dataaction) is performed in series of short transactions, but
> during
2008/3/7, Bill Moran <[EMAIL PROTECTED]>:
>
> In response to "Pavel Rotek" <[EMAIL PROTECTED]>:
>
> >
> > There are inserts and few updates (but what do you mean with update??
>
>
> He means adding or changing data in the table.
I understa
there is no lock on the
table when running vacuum full). I haven't try plain vacuum.
2008/3/7, Richard Huxton <[EMAIL PROTECTED]>:
>
> Pavel Rotek wrote:
> > Hello,
> >
> > i have problem with following table...
> >
> > create table dataac
dataaction takes after restoring about 1,5G, but in few days
grows to 79G(Toast space)... Vacuum on the table doesn't finish.
Where can be the problem?? How to solve it, how to shrink toast space??
Any help will be appretiated.
Kind regards,
Pavel Rotek
mmand is
select df.id as id, df.c as c, df.href as href, df.existing as existing,
df.filesize as filesize from documentfile df where (lower(href) like
'aba001!_223581.djvu' escape '!' ) order by id limit 1 Thank you very
much for any help,
Kind regards,
Pavel Rotek
