[SQL] apt.postgresql.org vs. Pitti PPA - install error

2013-06-18 Thread rawi
Working on Ubuntu 13.04 64bit (raring) I red, that Pitti-PPA will be discontinued in the future, so we should make the switch to apt.postgresql.org. But trying to "aptitude install postgresql-9.3" (and with 9.2 - the same) I get an install error: The following packages have unmet dependencies:

Re: [SQL] apt.postgresql.org vs. Pitti PPA - install error

2013-06-18 Thread basti
Please post your /etc/apt/source.list entry and "lsb_release -c" Am 18.06.2013 12:12, schrieb rawi: > Working on Ubuntu 13.04 64bit (raring) > > I red, that Pitti-PPA will be discontinued in the future, so we should make > the switch to apt.postgresql.org. > > But trying to "aptitude install postg

Re: [SQL] apt.postgresql.org vs. Pitti PPA - install error

2013-06-18 Thread rawi
/etc/apt/sources.list.d/apt_postgresql_org.list: deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main 9.3 (for 9.2 also tryed only 'deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main') lsb_release -c Codename: raring but there is no repository for raring... so I took

[SQL] Re: Index Usage and Running Times by FullTextSearch with prefix matching

2013-06-18 Thread rawi
rawi wrote > > Tom Lane-2 wrote >> FWIW, I get fairly decent performance for cases like this in HEAD >> (at least with a GIN index; GIST seems much less able to do well with >> short prefixes). What PG version are you testing? > Thank you Tom, > > I'm testing on PG 9.1 on UbuntuServer 12.10, 64b