Home > mailing lists
Re: BUG: PG do not use index - Mailing list pgsql-bugs

From
Subject	Re: BUG: PG do not use index
Date	March 26, 2008 09:45:35
Msg-id	021d01c88f26$1b7daf10$1200a8c0@kharkov.localhost Whole thread Raw
In response to	BUG: PG do not use index (<Eugen.Konkov@aldec.com>)
List	pgsql-bugs
Tree view
Ok. thx for answer.
When upgrading from 8.0 to 8.3
(http://www.postgresql.org/docs/8.3/interactive/install-upgrading.html)

if those error messages are normal?

C:\Program Files\PostgreSQL\8.3\bin>psql -d postgres -U root -W -f
../../pg_dump
new 2>&1 > c:/restore.log
Password for user root:
Password for user root:
psql:../../pg_dumpnew:15: ERROR:  role "postgres" already exists
psql:../../pg_dumpnew:17: ERROR:  role "root" already exists
Password for user root:
psql:../../pg_dumpnew:88: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize": No
such
file or directory
psql:../../pg_dumpnew:91: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.database_size(name) Ð½Ðµ
ÑÑÑÐµÑÑÐ²Ñ
ÐµÑ
psql:../../pg_dumpnew:99: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize": No
such
file or directory
psql:../../pg_dumpnew:102: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_database_size(oid) Ð½Ðµ
ÑÑÑÐµÑ
ÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:110: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
file or directory
psql:../../pg_dumpnew:113: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_dir_ls(text, boolean)
Ð½Ðµ ÑÑ
ÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:132: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
file or directory
psql:../../pg_dumpnew:135: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_read(text, bigint,
big
int) Ð½Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:143: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
file or directory
psql:../../pg_dumpnew:146: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_rename(text, text,
tex
t) Ð½Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:165: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
file or directory
psql:../../pg_dumpnew:168: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_stat(text) Ð½Ðµ
ÑÑÑÐµÑÑÐ²Ñ
ÐµÑ
psql:../../pg_dumpnew:176: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
file or directory
psql:../../pg_dumpnew:179: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_unlink(text) Ð½Ðµ
ÑÑÑÐµÑÑ
Ð²ÑÐµÑ
psql:../../pg_dumpnew:187: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
file or directory
psql:../../pg_dumpnew:190: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_write(text, text,
bool
ean) Ð½Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:198: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
file or directory
psql:../../pg_dumpnew:201: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_logdir_ls() Ð½Ðµ
ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:209: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
file or directory
psql:../../pg_dumpnew:212: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_postmaster_starttime()
Ð½Ðµ Ñ
ÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:220: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize": No
such
 file or directory
psql:../../pg_dumpnew:223: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_relation_size(oid) Ð½Ðµ
ÑÑÑÐµÑ
ÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:231: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
file or directory
psql:../../pg_dumpnew:234: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_reload_conf() Ð½Ðµ
ÑÑÑÐµÑÑÐ²ÑÐµÑ

psql:../../pg_dumpnew:242: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize": No
such
 file or directory
psql:../../pg_dumpnew:245: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_size_pretty(bigint) Ð½Ðµ
ÑÑÑÐµ
ÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:253: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize": No
such
 file or directory
psql:../../pg_dumpnew:256: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_tablespace_size(oid) Ð½Ðµ
ÑÑÑ
ÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:264: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize": No
such
 file or directory
psql:../../pg_dumpnew:267: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.relation_size(text) Ð½Ðµ
ÑÑÑÐµÑÑÐ²
ÑÐµÑ
psql:../../pg_dumpnew:969: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ pg_logdir_ls() Ð½Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
Ð¡Ð¢Ð ÐÐÐ 2:    SELECT a.filetime, a.filename FROM pg_logdir_ls() a(file...
                                                ^
ÐÐÐÐ¡ÐÐÐÐÐ:  No function matches the given name and argument types. You might
nee
d to add explicit type casts.
psql:../../pg_dumpnew:972: ERROR:  Ð¾ÑÐ½Ð¾ÑÐµÐ½Ð¸Ðµ "public.pg_logdir_ls" Ð½Ðµ
ÑÑÑÐµÑÑÐ²ÑÐµÑ

Password for user root:
psql:../../pg_dumpnew:2225: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize": No
suc
h file or directory
psql:../../pg_dumpnew:2228: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.database_size(name) Ð½Ðµ
ÑÑÑÐµÑÑ
Ð²ÑÐµÑ
psql:../../pg_dumpnew:2270: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize": No
suc
h file or directory
psql:../../pg_dumpnew:2273: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_database_size(oid) Ð½Ðµ
ÑÑÑÐµ
ÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:2281: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
 file or directory
psql:../../pg_dumpnew:2284: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_dir_ls(text, boolean)
Ð½Ðµ Ñ
ÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:2303: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
 file or directory
psql:../../pg_dumpnew:2306: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_read(text,
bigint, bi
gint) Ð½Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:2314: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
 file or directory
psql:../../pg_dumpnew:2317: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_rename(text,
text, te
xt) Ð½Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:2336: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
 file or directory
psql:../../pg_dumpnew:2339: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_stat(text) Ð½Ðµ
ÑÑÑÐµÑÑÐ²
ÑÐµÑ
psql:../../pg_dumpnew:2347: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
 file or directory
psql:../../pg_dumpnew:2350: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_unlink(text) Ð½Ðµ
ÑÑÑÐµÑ
ÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:2358: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
 file or directory
psql:../../pg_dumpnew:2361: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_write(text, text,
boo
lean) Ð½Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:2369: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
 file or directory
psql:../../pg_dumpnew:2372: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_logdir_ls() Ð½Ðµ
ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:2380: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
 file or directory
psql:../../pg_dumpnew:2383: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_postmaster_starttime()
Ð½Ðµ
ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:2391: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize": No
suc
h file or directory
psql:../../pg_dumpnew:2394: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_relation_size(oid) Ð½Ðµ
ÑÑÑÐµ
ÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:2402: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin": No
such
 file or directory
psql:../../pg_dumpnew:2405: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_reload_conf() Ð½Ðµ
ÑÑÑÐµÑÑÐ²ÑÐµ
Ñ
psql:../../pg_dumpnew:2413: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize": No
suc
h file or directory
psql:../../pg_dumpnew:2416: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_size_pretty(bigint) Ð½Ðµ
ÑÑÑ
ÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:2424: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize": No
suc
h file or directory
psql:../../pg_dumpnew:2427: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_tablespace_size(oid)
Ð½Ðµ ÑÑ
ÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:2435: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize": No
suc
h file or directory
psql:../../pg_dumpnew:2438: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.relation_size(text) Ð½Ðµ
ÑÑÑÐµÑÑ
Ð²ÑÐµÑ
psql:../../pg_dumpnew:3505: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ pg_logdir_ls() Ð½Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
Ð¡Ð¢Ð ÐÐÐ 2:    SELECT a.filetime, a.filename FROM pg_logdir_ls() a(file...
                                                ^
ÐÐÐÐ¡ÐÐÐÐÐ:  No function matches the given name and argument types. You might
nee
d to add explicit type casts.
psql:../../pg_dumpnew:3508: ERROR:  Ð¾ÑÐ½Ð¾ÑÐµÐ½Ð¸Ðµ "public.pg_logdir_ls" Ð½Ðµ
ÑÑÑÐµÑÑÐ²ÑÐµ
Ñ
psql:../../pg_dumpnew:9213484: ERROR:  ÑÐ·ÑÐº "plpgsql" ÑÐ¶Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213495: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize":
No
such file or directory
psql:../../pg_dumpnew:9213498: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.database_size(name) Ð½Ðµ
ÑÑÑ
ÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213506: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize":
No
such file or directory
psql:../../pg_dumpnew:9213509: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_database_size(oid)
Ð½Ðµ Ñ
ÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213517: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin":
No s
uch file or directory
psql:../../pg_dumpnew:9213520: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_dir_ls(text,
boolean) Ð½
Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213539: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin":
No s
uch file or directory
psql:../../pg_dumpnew:9213542: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_read(text,
bigint,
 bigint) Ð½Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213550: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin":
No s
uch file or directory
psql:../../pg_dumpnew:9213553: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_rename(text,
text,
 text) Ð½Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213572: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin":
No s
uch file or directory
psql:../../pg_dumpnew:9213575: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_stat(text) Ð½Ðµ
ÑÑÑÐµ
ÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213583: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin":
No s
uch file or directory
psql:../../pg_dumpnew:9213586: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_unlink(text)
Ð½Ðµ ÑÑ
ÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213594: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin":
No s
uch file or directory
psql:../../pg_dumpnew:9213597: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_file_write(text,
text,
boolean) Ð½Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213605: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin":
No s
uch file or directory
psql:../../pg_dumpnew:9213608: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_logdir_ls() Ð½Ðµ
ÑÑÑÐµÑÑÐ²Ñ
ÐµÑ
psql:../../pg_dumpnew:9213616: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin":
No s
uch file or directory
psql:../../pg_dumpnew:9213619: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ
public.pg_postmaster_starttime()
Ð½Ðµ ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213627: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize":
No
such file or directory
psql:../../pg_dumpnew:9213630: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_relation_size(oid)
Ð½Ðµ Ñ
ÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213638: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/admin":
No s
uch file or directory
psql:../../pg_dumpnew:9213641: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_reload_conf() Ð½Ðµ
ÑÑÑÐµÑÑ
Ð²ÑÐµÑ
psql:../../pg_dumpnew:9213649: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize":
No
such file or directory
psql:../../pg_dumpnew:9213652: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.pg_size_pretty(bigint)
Ð½Ðµ
ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213660: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize":
No
such file or directory
psql:../../pg_dumpnew:9213663: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ
public.pg_tablespace_size(oid) Ð½Ðµ
 ÑÑÑÐµÑÑÐ²ÑÐµÑ
psql:../../pg_dumpnew:9213671: ERROR:  Ð½ÐµÑ Ð´Ð¾ÑÑÑÐ¿Ð° Ðº ÑÐ°Ð¹Ð»Ñ "$libdir/dbsize":
No
such file or directory
psql:../../pg_dumpnew:9213674: ERROR:  ÑÑÐ½ÐºÑÐ¸Ñ public.relation_size(text) Ð½Ðµ
ÑÑÑ
ÐµÑÑÐ²ÑÐµÑ


----- Original Message -----
From: "Tomasz Ostrowski" <tometzky@batory.org.pl>
To: <Eugen.Konkov@aldec.com>
Cc: <pgsql-bugs@postgresql.org>
Sent: Wednesday, March 26, 2008 11:08 AM
Subject: Re: [BUGS] BUG: PG do not use index


> On 2008-03-26 09:41, Eugen.Konkov@aldec.com wrote:
>
>> 5. explain select count(*) from akh_testing_result
>> Aggregate  (cost=206372.95..206372.95 rows=1 width=0)
>>   ->  Seq Scan on akh_testing_result  (cost=0.00..184804.56 rows=8627356
>> width=0)
>
> You will always get seq scan when you select count(*) without where:
> http://sql-info.de/en/postgresql/postgres-gotchas.html#1_7
>
>> select max(id) from akh_testing_result
>> 8817173
>> I will try to update from 8.0 to 8.3
>
> This will help with select max(id). An update is recommended anyway. And
> it is required if you are using Windows, as 8.0 is not supported on
> Windows anymore.
>
> Regards
> Tometzky
> --
> ...although Eating Honey was a very good thing to do, there was a
> moment just before you began to eat it which was better than when you
> were...
>                                                      Winnie the Pooh
>
pgsql-bugs by date:
From: Tomasz Ostrowski
Date: 26 March 2008, 09:08:15
Subject: Re: BUG: PG do not use index
From: Alvaro Herrera
Date: 26 March 2008, 13:00:55
Subject: Re: BUG #4059: Vacuum full not always cleaning empty tables
Re: BUG: PG do not use index - Mailing list pgsql-bugs

Previous

Next
