Re: Removing useless \. at the end of copy in pgbench

Поиск
Список
Период
Сортировка
Искать
От
Fabien COELHO
Тема
Re: Removing useless \. at the end of copy in pgbench
Дата
Msg-id
alpine.DEB.2.21.1808291615280.14012@lancre
Ответ на
Список
Дерево обсуждения
Removing useless \. at the end of copy in pgbench Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Removing useless \. at the end of copy in pgbench Tom Lane <tgl@sss.pgh.pa.us>
Re: Removing useless \. at the end of copy in pgbench Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Removing useless \. at the end of copy in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: Removing useless \. at the end of copy in pgbench Tom Lane <tgl@sss.pgh.pa.us>
Re: Removing useless \. at the end of copy in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: Removing useless \. at the end of copy in pgbench Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Removing useless \. at the end of copy in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: Removing useless \. at the end of copy in pgbench Tom Lane <tgl@sss.pgh.pa.us>
Re: Removing useless \. at the end of copy in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: Removing useless \. at the end of copy in pgbench Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Removing useless \. at the end of copy in pgbench Chapman Flack <chap@anastigmatix.net>
Re: Removing useless \. at the end of copy in pgbench Fabien COELHO <coelho@cri.ensmp.fr>
Re: Removing useless \. at the end of copy in pgbench Andres Freund <andres@anarazel.de>
Re: Removing useless \. at the end of copy in pgbench Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Removing useless \. at the end of copy in pgbench Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Removing useless \. at the end of copy in pgbench Fabien COELHO <coelho@cri.ensmp.fr>

Hello Peter,

>> """
>> Pgbench is expected to work with all PostgreSQL supported versions at
>> the time it is released. Some options may work only with newer servers. It
>> may work with older version down to 8.2.
>> """
>
> It is generally expected (nowadays) that client programs work
> independent of the server version, unless restrictions are specifically
> documented (e.g., pg_dump) or there is some obvious feature dependency
> (e.g., unlogged tables).

Yep, that is somehow what I said in the mail.

> So the above paragraph does not add any useful information.

It tells that it will not work from 8.1 and below.

> Also, I don't find any reason why 8.2 is the cutoff, and saying that it 
> may work down to 8.2 (implying that it may not) is content-free.

The "may" is because I could *not* test: I could not run a 8.2 on my 
laptop, "initdb" fails on:

  creating template1 database in <...>/src/test/regress/./tmp_check/data/base/1 ... ok
  initializing pg_authid ... FATAL:  wrong number of index expressions
  STATEMENT:  CREATE TRIGGER pg_sync_pg_database   AFTER INSERT OR UPDATE OR DELETE ON pg_database   FOR EACH STATEMENT EXECUTE PROCEDURE flatfile_update_trigger();

So I did not feel confident in saying that it would work for 8.2. That is 
just me being precise:-)

As explained in the previous mail, pgbench "CREATE TABLE" always uses 
"FILLFACTOR" which was introduced in 8.2, so it is sure to fail before 
that.

What about:

"""
Pgbench requires a PostgreSQL version 8.2 or above server.
"""

Some information is provided...

I understood that Tom found that an explicit compatibility note would be 
welcome, so I provided one. I'm also fine with saying nothing.

-- 
Fabien.

В списке pgsql-hackers по дате отправления
От: Yugo Nagata
Дата:
От: Fabien COELHO
Дата:
FAQ