Re: [ADMIN] pg_* Tables

2010-12-05 Thread Greg Williamson
Samuel Stearns wrote: >> Howdy, >> >> Environment: >> >> Solaris 10 >> Postgres 8.3.3 >> >> I’m getting high sequential scans for some pg_* tables: >> >> =# select relname, sum(seq_scan) as seq_scan,sum(seq_tup_read) >> as seq_tup_read,sum(idx_scan) as idx_scan, sum(idx_tup_fetch) as

[ADMIN] pg_* Tables

2010-12-05 Thread Samuel Stearns
Howdy, Environment: Solaris 10 Postgres 8.3.3 I'm getting high sequential scans for some pg_* tables: =# select relname, sum(seq_scan) as seq_scan,sum(seq_tup_read) as seq_tup_read,sum(idx_scan) as idx_scan, sum(idx_tup_fetch) as idx_tup_fetch, sum(n_tup_ins) as n_tup_ins, sum(n_tup_upd) as n

Re: [ADMIN] failing to compile v. 9.0.1 on debian squeeze with readline

2010-12-05 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= writes: > On Sun, 2010-12-05 at 17:49 -0500, Tom Lane wrote: >> Maybe you need to lobby the Debian folks to revert to a less broken >> version of libreadline. It surely has got no business exporting >> either of those symbols. > Could it be libreadline5 vs libr

Re: [ADMIN] failing to compile v. 9.0.1 on debian squeeze with readline

2010-12-05 Thread Devrim GÜNDÜZ
On Sun, 2010-12-05 at 17:49 -0500, Tom Lane wrote: > Maybe you need to lobby the Debian folks to revert to a less broken > version of libreadline. It surely has got no business exporting > either of those symbols. Could it be libreadline5 vs libreadline 6? -- Devrim GÜNDÜZ PostgreSQL Danışmanı/C

Re: [ADMIN] failing to compile v. 9.0.1 on debian squeeze with readline

2010-12-05 Thread Tom Lane
Imre Oolberg writes: > $ make > ... > gcc -O2 -Wall -Wmissing-prototypes ... > ... > postmaster/postmaster.o: In function `PostmasterMain': > postmaster.c:(.text+0x420c): undefined reference to `optreset' > tcop/postgres.o: In function `process_postgres_switches': > postgres.c:(.text+0x122b): unde

[ADMIN] failing to compile v. 9.0.1 on debian squeeze with readline

2010-12-05 Thread Imre Oolberg
Hi! I am trying to compile PostgreSQL v. 9.0.1 on coming Debian Squeeze (as installed with Debian Installer 6.0 Beta1 release, http://www.debian.org/devel/debian-installer/) amd64 doing following steps 1. install required dependecies (i have done similarly on debian lenny like apt-get build-dep p