Re: [GENERAL] A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?

Dear Scott, When I pg_dump -t bigtablename on the Slony slave, the dump file is 212G in size. I am unable to perform the same test on the master until I get a maintenance window, which may not be for a few weeks, as it does impact our production system when we dump from the master (the web ap

Re: [GENERAL] full text search and ILIKE type clauses.

> > If you're using 9.1, you might look into contrib/pg_trgm instead. If I was to use trgm would it be better to create a trigram index on each text field? In the past I have created a text field which contains the rest of the fields concatenated. That works great as long as you are looking for a

Re: [GENERAL] full text search and ILIKE type clauses.

Tim Uckun writes: > I want to be able to search a lot of fields using queries that use > ILIKE and unfortunately many of the queries will be using the > '%SOMETHING%' or '%SOMETHING' type clauses. Since indexes are useless > on those I was thinking I could use tsvectors but I can't figure out >

[GENERAL] full text search and ILIKE type clauses.

I want to be able to search a lot of fields using queries that use ILIKE and unfortunately many of the queries will be using the '%SOMETHING%' or '%SOMETHING' type clauses. Since indexes are useless on those I was thinking I could use tsvectors but I can't figure out how to accomplish this. One

Re: [GENERAL] Error installing postgresq91-python package

On 03/10/2012 01:51 PM, PgSQL wrote: Thanks.. >>>Is there another mechanism to install mx, other than yum in the mean time? I unknow if exist. But I need YUM in my CentOs 5.7 :'( Any command, any form please??? I'm afraid I am not going to be much help here. I would probably cause more

Re: [GENERAL] Error installing postgresq91-python package

Thanks.. >>>Is there another mechanism to install mx, other than yum in the mean time? I unknow if exist. But I need YUM in my CentOs 5.7 :'( Any command, any form please??? 2012/3/10, Adrian Klaver-3 [via PostgreSQL] : > > > On 03/10/2012 09:59 AM, PgSQL wrote: >> Thanks. >> >> You can see:

Re: [GENERAL] Error installing postgresq91-python package

>>>If the OP can identify and download the relevant .rpm file I download this packages: wget http://mirror.centos.org/centos-5/5.7/os/i386/CentOS/elfutils-0.137-3.el5.i386.rpm wget http://mirror.centos.org/centos-5/5.7/os/i386/CentOS/elfutils-libs-0.137-3.el5.i386.rpm wget http://mirror.cento

Re: [GENERAL] Parse message is not generating a ParseOk response

=?ISO-8859-1?Q?Maur=EDcio_Linhares?= writes: > I'm writing an async driver for PosgreSQL in Scala ( > https://github.com/mauricio/postgresql-netty ) and I'm now working on > getting the prepared statements to work. Following the protocol > documentation for extended queries ( > http://www.postgres

[GENERAL] Parse message is not generating a ParseOk response

Hello everyone, I'm writing an async driver for PosgreSQL in Scala ( https://github.com/mauricio/postgresql-netty ) and I'm now working on getting the prepared statements to work. Following the protocol documentation for extended queries ( http://www.postgresql.org/docs/9.1/static/protocol-flow.ht

Re: [GENERAL] permission denied to create extension "ltree" Must be superuser to create this extension.

On Sat, Mar 10, 2012 at 7:57 AM, krz...@gmail.com wrote: > Why does ltree require superuser privledge? Is it dangerous and allow CREATE EXTENSION must be run by superusers only. > circumventing server security? No mention of this in manual so it is There is a mention here http://www.postgresql.