Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

I will try the the RPMs from the rhel 6 link & post updates. Thanks Bhushan Pathak On Mon, Jun 9, 2014 at 8:06 PM, Adrian Klaver wrote: > On 06/09/2014 01:53 AM, Bhushan Pathak wrote: > >> >> I do not have any earlier versions of postgres installed, neither a >> parallel instance running. In t

Re: [GENERAL] two questions about fulltext searchign / tsvector indexes

On Mon, Jun 9, 2014 at 8:55 PM, Jonathan Vanasco wrote: > I can't figure out which one to use. This is on a steadily growing > table of around 20MM rows that gets 20-80k new records a day, but existing > records are rarely updated. The question as always is a time-space trade-off. How

Re: [GENERAL] two questions about fulltext searchign / tsvector indexes

Vick Khera wrote: > Jonathan Vanasco wrote: > Personally in these days of cheap disks I'd go with the dedicated > column. Given that, you want to just have a GIN index on that one > column, and the query you want, given some plain text string like > "fluffy dog" is this: > > select plainto_tsqu

Re: [GENERAL] pg_standby replication problem

On 06/09/2014 10:02 PM, Khangelani Gama wrote: -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, June 10, 2014 1:42 AM To: Khangelani Gama; pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_standby replication problem On 06/09/2014 11:15 AM, Kh

[GENERAL] How can I tell if pg_restore is running?

My extension has a config table that is dumped by pg_dump and populated by pg_restore. However, this table has triggers on it that I would like not to do anything if the table is being populated by pg_restore. I want the triggers to operate only if the user is manipulating the table directly after

Re: [GENERAL] How can I tell if pg_restore is running?

On Tue, Jun 10, 2014 at 10:02 AM, Moshe Jacobson wrote: > My extension has a config table that is dumped by pg_dump and populated by > pg_restore. > However, this table has triggers on it that I would like not to do > anything if the table is being populated by pg_restore. I want the triggers > t

Re: [GENERAL] two questions about fulltext searchign / tsvector indexes

On Jun 10, 2014, at 8:26 AM, Vick Khera wrote: Thanks so much for this. We do a lot of searching on this column, so pre-computing seems to be the way. I'm not worried about disk space for now, and can revisit that later if there is a problem Just for clarification on this: Option A (less fas

Re: [GENERAL] How can I tell if pg_restore is running?

> My extension has a config table that is dumped by pg_dump and > populated by pg_restore. > However, this table has triggers on it that I would like not to do > anything if the table is being populated by pg_restore. I want the > triggers to operate only if the user is manipulating the table >

Re: [GENERAL] How can I tell if pg_restore is running?

Hi Moshe: On Tue, Jun 10, 2014 at 4:02 PM, Moshe Jacobson wrote: > My extension has a config table that is dumped by pg_dump and populated by > pg_restore. > Is there a way for my extension's trigger functions to return immediately > when triggered by pg_restore? Is there any reason to avoi

Re: [GENERAL] pg_standby replication problem

Thank You, I will have a look. -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, June 10, 2014 3:45 PM To: Khangelani Gama; pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_standby replication problem On 06/09/2014 10:02 PM, Khangelani Gama wro

Re: [GENERAL] slow query question: more indexes considered harmful

This went outside the purview of the mailing list. I wanted to get some input regarding the odd behaviour of the query planner. Mostly out of curiosity. This (http://explain.depesz.com/s/vj4) query plan has actual time = 17217 vs. this one (http://explain.depesz.com/s/ojX) which has actual time =

[GENERAL] Warm standby (log shipping) from PG 8.3 to 9.3

Is it safe to assume that my working PG 8.3 archive command on the master and recovery.conf (using contrib's pg_standby) on the standby will work the same under 9.3? That is, under PG 8.3, my master server uses: archive_mode = on archive_command = '~/postgresql/bin/copyWAL "%p" "%f"' archive_t

Re: [GENERAL] Warm standby (log shipping) from PG 8.3 to 9.3

On Tue, Jun 10, 2014 at 8:13 PM, David Wall wrote: > Is it safe to assume that my working PG 8.3 archive command on the master > and recovery.conf (using contrib's pg_standby) on the standby will work the > same under 9.3? > Yes, it will work just fine. Of course you can't load 9.3 xlogs into 8.

Re: [GENERAL] Warm standby (log shipping) from PG 8.3 to 9.3

On 6/10/2014 11:54 AM, hubert depesz lubaczewski wrote: On Tue, Jun 10, 2014 at 8:13 PM, David Wall > wrote: Is it safe to assume that my working PG 8.3 archive command on the master and recovery.conf (using contrib's pg_standby) on the standby will work t

[GENERAL] Question about partial functional indexes and the query planner

Hi everyone, I am using a partial functional index on a table where F(a) = a. Querying whre F(a) = a hits the index as expected. However the reverse statement a = F(a) does not. I have verified this in 9.3.4. Is this a deficiency with the query planner, or are these not actually equivalent? I

Re: [GENERAL] Question about partial functional indexes and the query planner

Brian Dunavant writes: > I am using a partial functional index on a table where F(a) = a. Querying > whre F(a) = a hits the index as expected. However the reverse statement a > = F(a) does not. I have verified this in 9.3.4. > Is this a deficiency with the query planner, or are these not actual

[GENERAL] Accessing structured datatypes using libpq

Hi, What is the recommended way of accessing structured data-types (especially JSONB and HSTORE) using libpq? It seems that by default JSONB data for example is returned as text. Is it not possible to have binary access to these data-types? If it is possible, then how do I do it exactly as the on

Re: [GENERAL] Accessing structured datatypes using libpq

On 6/10/2014 11:20 PM, Raimo Jormakka wrote: What is the recommended way of accessing structured data-types (especially JSONB and HSTORE) using libpq? It seems that by default JSONB data for example is returned as text. Is it not possible to have binary access to these data-types? If it is