[BUGS] index bloat in 8.4-dev

I am seeing index bloat in the current head when the indexed values are constantly increasing, and the lower values are being constantly deleted. I attached a simple python script that can be fed into psql. If this is done on 8.3.3, the number of index relpages stays fairly constant, around 500, a

RES: [BUGS] BUG #4450: Postgres do not ask for passord

This is my pg_hba.conf: # TYPE DATABASEUSER CIDR-ADDRESSMETHOD host all postgres0.0.0.0/0 reject local bancoX userX trust local all allmd5 host all all127.0.0.1/32 md5 host

[BUGS] BUG #4451: initcap() function capitalizes incorrectly

The following bug has been logged online: Bug reference: 4451 Logged by: Scott V Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Mac OS X 10.5.4 Description:initcap() function capitalizes incorrectly Details: initcap() capitalizes incorr

Re: [BUGS] BUG #4410: Indexes not seen right away

Greg Sabino Mullane wrote: > Does it have pg_index.indcheckxmin = true? If so, see README.HOT. >>> Yes, that was probably it. Is this worth noting in the documentation >>> somewhere >>> (other than the technical bowels of HOT)? Perhaps in the CREATE INDEX >>> docs? > ... >> I have attached

Re: [BUGS] BUG #4451: initcap() function capitalizes incorrectly

Scott V wrote: > The following bug has been logged online: > > Bug reference: 4451 > Logged by: Scott V > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3.1 > Operating system: Mac OS X 10.5.4 > Description:initcap() function capitalizes incorrectly > Details

Re: [BUGS] index bloat in 8.4-dev

Jeff Davis wrote: I am seeing index bloat in the current head when the indexed values are constantly increasing, and the lower values are being constantly deleted. ... It's possible that this has something to do with the new FSM. Yep, it clearly has. Looks like I forgot about the index FSMs wh

Re: RES: [BUGS] BUG #4450: Postgres do not ask for passord

"Cadu" <[EMAIL PROTECTED]> writes: > If I try a remote Access using psql or pgadmin and the user is userY it > Access and do not ask for password. > If I use other user it ask for password. Hmm, there's nothing in your pg_hba.conf to explain that. I think maybe you have a ~/.pgpass file (I forget

Re: [BUGS] BUG #4447: install failed to start; libintl3.dll was not found

Jen McCann wrote: > The following bug has been logged online: > > Bug reference: 4447 > Logged by: Jen McCann > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3.4 > Operating system: Win2k3 server sp1 > Description:install failed to start; libintl3.dll was no

Re: [BUGS] BUG #4451: initcap() function capitalizes incorrectly

Magnus Hagander <[EMAIL PROTECTED]> writes: > Scott V wrote: >> PostgreSQL version: 8.3.1 >> Operating system: Mac OS X 10.5.4 >> initcap() capitalizes incorrectly when passing strings containing certain >> two-byte UTF-8 characters. E.g., when argument = 'mātÅ«rāte', initcap >> returns 'MāTÅ

Re: [BUGS] BUG #4451: initcap() function capitalizes incorrectly

Note sure what the correct settings should be, but output from SHOW ALL in psql says: lc_collate C lc_ctype C On Mon, Oct 6, 2008 at 5:37 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > Magnus Hagander <[EMAIL PROTECTED]> writes: >> Scott V wrote: >>> PostgreSQL version: 8.3.1 >>> Operating

Re: [BUGS] BUG #4451: initcap() function capitalizes incorrectly

Scott Vanderbilt wrote: Note sure what the correct settings should be, but output from SHOW ALL in psql says: lc_collate C lc_ctype C There's a chapter on locale support in the user manual: http://www.postgresql.org/docs/8.3/interactive/locale.html The right setting depends on wha

Re: [BUGS] index bloat in 8.4-dev

On Mon, 2008-10-06 at 11:10 +0300, Heikki Linnakangas wrote: > Jeff Davis wrote: > > I am seeing index bloat in the current head when the indexed values are > > constantly increasing, and the lower values are being constantly > > deleted. > > > > ... > > It's possible that this has something to do