[GENERAL] Problem with odbc_fdw

2011-10-16 Thread pasman pasmański
Hi. I can't compile odbc_fdw module: make: Entering directory `/e/pg91/postgres/contrib/odbc_fdw' dllwrap -o odbc_fdw.dll --dllname odbc_fdw.dll --def libodbc_fdwdll.def odbc_fd w.o -L../../src/port -Wl,--allow-multiple-definition -Wl,--as-needed -lodbc - L../../src/backend -lpostgres c:/min

Re: [GENERAL] index bloat question

2011-10-16 Thread Rob Sargent
Scott Marlowe wrote: On Sun, Oct 16, 2011 at 2:41 PM, Szymon Guz wrote: Hi, just a couple of questions: will there be an index bloat if I have: - a serial column and only add rows to the table? - a text column and I only add rows to the table? For the serial column the numbers are only inc

Re: [GENERAL] index bloat question

2011-10-16 Thread Scott Marlowe
On Sun, Oct 16, 2011 at 2:41 PM, Szymon Guz wrote: > Hi, > just a couple of questions: > will there be an index bloat if I have: > - a serial column and only add rows to the table? > - a text column and I only add rows to the table? > For the serial column the numbers are only incremented, for the

Re: [GENERAL] 9.1 got really fast ;)

2011-10-16 Thread Scott Marlowe
On Sun, Oct 16, 2011 at 5:24 PM, Tom Lane wrote: > Scott Marlowe writes: >> On Sat, Oct 15, 2011 at 2:20 PM, Thomas Kellerer wrote: >>> Total runtime: -2.368 ms   << this is amazing ;) > >> I get something similar when I do select now()-query_start from >> pg_stat_activity on my Ubuntu 10.04

Re: [GENERAL] 9.1 got really fast ;)

2011-10-16 Thread Tom Lane
Scott Marlowe writes: > On Sat, Oct 15, 2011 at 2:20 PM, Thomas Kellerer wrote: >> Total runtime: -2.368 ms   << this is amazing ;) > I get something similar when I do select now()-query_start from > pg_stat_activity on my Ubuntu 10.04 / pg 8.3 servers. Within a transaction block that's not

Re: [GENERAL] 9.1 got really fast ;)

2011-10-16 Thread Scott Marlowe
On Sat, Oct 15, 2011 at 2:20 PM, Thomas Kellerer wrote: > > Total runtime: -2.368 ms   << this is amazing ;) > > This is with 9.1.1 on a Windows XP machine I get something similar when I do select now()-query_start from pg_stat_activity on my Ubuntu 10.04 / pg 8.3 servers. -- Sent via pgsql

Re: [GENERAL] 9.1 got really fast ;)

2011-10-16 Thread Filip Rembiałkowski
2011/10/15 Chris Travers > > > On Sat, Oct 15, 2011 at 1:33 PM, Grzegorz Jaskiewicz wrote: > >> >> On 15 Oct 2011, at 21:20, Thomas Kellerer wrote: >> > >> > Total runtime: -2.368 ms << this is amazing ;) >> > >> > This is with 9.1.1 on a Windows XP machine >> >> Are you saying that Windows

[GENERAL] index bloat question

2011-10-16 Thread Szymon Guz
Hi, just a couple of questions: will there be an index bloat if I have: - a serial column and only add rows to the table? - a text column and I only add rows to the table? For the serial column the numbers are only incremented, for the text column I add random strings. regards Szymon

[GENERAL] Files being created under data/pg_xlog during failover testing

2011-10-16 Thread Schoen Matthew-MSCHOEN1
Hello Postgres community, I am running Postgres 9.0.3 on dual node RHEL 5.5 system. I have postgres setup to run on both nodes as active hot-standby. I am seeing a potential issue...or hopefully I have a configuration problem. Every time I failover the DB I am seeing wal segement files (or ch

Re: [GENERAL] 9.1 got really fast ;)

2011-10-16 Thread Edson Richter
Em 15-10-2011 18:18, John R Pierce escreveu: On 10/15/11 1:59 PM, Chris Travers wrote: Are you saying that Windows XP is the ultimate server OS for high performance PostgreSQL installations?  Are there optimizations that this platform can t

Re: [GENERAL] 9.1 got really fast ;)

2011-10-16 Thread Dmitriy Igrishin
2011/10/16 John R Pierce > On 10/15/11 1:59 PM, Chris Travers wrote: > >> Are you saying that Windows XP is the ultimate server OS for high >> performance PostgreSQL installations? Are there optimizations that this >> platform can take advantage of, perhaps extending Pg timelines into actual >>