> Did we decide against LAZY? Seems we have a number of people 
> concerned about vacuum downtime, and I can see this as a win
> for them. If they don't specify LAZY, the code is not run.

First sorry that I wasn't able to deal with vlazy earlier.

Now I have one more open item for 7.1 - restoring index structure
at runtime (add tuple to parent page for aborted split op,
create root page if no one exists). I'll try to deal with both
items (in any case vlazy will be ported to 7.1, as required
by contract).

As for reported problem: I just looked at Denis' tgz and
found only table, index and sequence(?) data files - I would
need in schema definitions, pg_log and pg_variable files
as well. Denis? Also, when these copies were made -
before/after unsuccessful vacuum+lazy?

Vadim

Wed, 24 Jan 2001 16:55:13 -0800
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
RE: (one more time) Patches with vacuum fixes available
	 .
> > Did we decide against LAZY? Seems we have a number of people
> > concerned about vacuum downtime, and I can see this as a win
> > for them. If they don't specify LAZY, the code is not run.
>
> First sorry that I wasn't able to deal with vlazy earlier.
>
> Now I have one more open item for 7.1 - restoring index structure
> at runtime (add tuple to parent page for aborted split op,
> create root page if no one exists). I'll try to deal with both
> items (in any case vlazy will be ported to 7.1, as required
> by contract).
>
> As for reported problem: I just looked at Denis' tgz and
> found only table, index and sequence(?) data files

I sent users* :-)))

> - I would
> need in schema definitions, pg_log and pg_variable files
> as well. Denis?

I have sent them to you by private mail.
Schema:

webmailstation=# \d users
                                 Table "users"
     Attribute     |   Type    |                    Modifier
-------------------+-----------+------------------------------------------------
 id                | integer   | not null default 
nextval('users_id_seq'::text)
 account_name      | text      |
 account_pass      | text      |
 blocked           | boolean   | default 'f'
 commercial        | boolean   | default 'f'
 expire_date       | timestamp | default now()
 num_of_pop3       | integer   | default 1
 num_of_local      | integer   | default 1
 first_name        | text      |
 last_name         | text      |
 bd_year           | integer   |
 gender            | integer   |
 occupation        | integer   |
 income            | integer   |
 alternate_email   | text      |
 state             | integer   |
 country           | integer   |
 phone             | text      |
 password_question | integer   |
 password_answer   | text      |
 crypt             | char(13)  |
 last_login_ip     | char(31)  |
 last_seen         | timestamp |
 registered        | timestamp |
 in_limit          | integer   | not null default 30
 out_limit         | integer   | not null default 10
 max_msg_size      | integer   | not null default 64
 max_reply_size    | integer   | not null default 16
 max_attach_size   | integer   | not null default 0
 max_replies       | integer   | not null default 10
 max_attachments   | integer   | default 0
Indices: ix_users_account_name,
         ix_users_blocked,
         users_id_key

Do you need 2 other indices?

> Also, when these copies were made - before/after unsuccessful vacuum+lazy?

Surely before. :-))) Otherwise they would be almost useless for you.

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

Thu, 25 Jan 2001 20:13:09 +0600
Denis Perchine <dyp@perchine.com>
Re: (one more time) Patches with vacuum fixes available .